SnowflakeSnowflake
COF-C02 · Question #190
COF-C02 Question #190: Real Exam Question with Answer & Explanation
The correct answer is A: SHOW STORAGE BY TABLE;. 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
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.