nerdexam
Snowflake

COF-C02 · Question #190

Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)

The correct answer is A. SHOW STORAGE BY TABLE; E. Information Schema -> TABLE_STORAGE_METRICS. To monitor data storage for individual tables, the commands and objects that can be used are SHOW STORAGE BY TABLE;' and the Information Schema view TABLE_STORAGE_METRICS'. These tools provide detailed information about the storage utilization for tables.

Storage and Data Protection

Question

Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)

Options

  • ASHOW STORAGE BY TABLE;
  • BSHOW TABLES;
  • CInformation Schema -> TABLE_HISTORY
  • DInformation Schema -> TABLE_FUNCTION
  • EInformation Schema -> TABLE_STORAGE_METRICS

How the community answered

(26 responses)
  • A
    92% (24)
  • B
    4% (1)
  • C
    4% (1)

Explanation

To monitor data storage for individual tables, the commands and objects that can be used are SHOW STORAGE BY TABLE;' and the Information Schema view TABLE_STORAGE_METRICS'. These tools provide detailed information about the storage utilization for tables.

Topics

#Storage Monitoring#Table Storage#Information Schema Views#SHOW Commands

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full COF-C02 Practice