SnowPro Core Certification — Question 290

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

Answer options

• A. SHOW STORAGE BY TABLE;
• B. SHOW TABLES;
• C. Information Schema -> TABLE_HISTORY
• D. Information Schema -> TABLE_FUNCTION
• E. Information Schema -> TABLE_STORAGE_METRICS

Correct answer: B, E

Explanation

The correct choices are B and E. 'SHOW TABLES' provides a list of tables which can give insights into storage, while 'Information Schema -> TABLE_STORAGE_METRICS' specifically details the storage metrics of each table. The other options do not directly relate to monitoring data storage for individual tables.