
Answer-first summary for fast verification
Answer: SHOW TABLES;, Information Schema -> TABLE_STORAGE_METRICS
The question asks for two methods to monitor data storage for individual tables. Option B (SHOW TABLES) displays table metadata including the 'bytes' column, which shows the storage size for each table. Option E (Information Schema -> TABLE_STORAGE_METRICS) provides detailed storage metrics specifically designed for monitoring table storage consumption, including active and time travel bytes. Both are directly supported by Snowflake documentation for this purpose. Option A (SHOW STORAGE BY TABLE) is not a valid Snowflake command. Option C (TABLE_HISTORY) shows table change history but not storage metrics. Option D (TABLE_FUNCTION) is not a specific Information Schema view for storage monitoring. The community discussion shows 100% consensus on BE with multiple users confirming these options work and providing documentation links.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which commands and/or objects can be used to monitor data storage for individual tables? (Choose two.)
A
SHOW STORAGE BY TABLE;
B
SHOW TABLES;
C
Information Schema -> TABLE_HISTORY
D
Information Schema -> TABLE_FUNCTION
E
Information Schema -> TABLE_STORAGE_METRICS
No comments yet.