SnowPro Core Certification — Question 891

How can a user get the MOST detailed information about individual table storage details in Snowflake?

Answer options

• A. SHOW TABLES command
• B. SHOW EXTERNAL TABLES command
• C. TABLES view
• D. TABLE_STORAGE_METRICS view

Correct answer: D

Explanation

The TABLE_STORAGE_METRICS view provides in-depth details about the storage characteristics of each table, making it the best choice for this inquiry. The SHOW TABLES command and SHOW EXTERNAL TABLES command mainly list tables without detailed storage information, while the TABLES view offers a general overview rather than specific storage metrics.