SnowPro Core Certification — Question 904

Any user with the appropriate privileges can view data storage for individual tables by using which queries? (Choose two.)

Answer options

• A. METERING_HISTORY view in the ACCOUNT_USAGE schema
• B. TABLE_STORAGE_METRICS view in the ACCOUNT_USAGE schema
• C. STORAGE_USAGE view in the ACCOUNT_USAGE schema
• D. TABLE_STORAGE_METRICS view in the INFORMATION_SCHEMA schema
• E. METERING_DAILY_HISTORY view in the ORGANIZATION_USAGE schema

Correct answer: B, D

Explanation

The correct answers are B and D because the TABLE_STORAGE_METRICS view in both the ACCOUNT_USAGE schema and the INFORMATION_SCHEMA schema provides insights into table storage metrics. The other options either do not pertain specifically to table storage or are not located in the correct schemas for this purpose.