Answer-first summary for fast verification
Answer: TABLE_STORAGE_METRICS view in the ACCOUNT_USAGE schema, TABLE_STORAGE_METRICS view in the INFORMATION_SCHEMA schema
The question asks for queries to view data storage details for individual tables. According to Snowflake documentation and the community consensus (100% agreement on BD), the correct views are TABLE_STORAGE_METRICS in both ACCOUNT_USAGE and INFORMATION_SCHEMA schemas. Option B (TABLE_STORAGE_METRICS in ACCOUNT_USAGE) provides historical storage metrics for all tables in the account. Option D (TABLE_STORAGE_METRICS in INFORMATION_SCHEMA) provides storage metrics for tables accessible to the current role. Option A (METERING_HISTORY) shows general account usage, not table-specific storage. Option C (STORAGE_USAGE) shows overall storage consumption, not per-table details. Option E (METERING_DAILY_HISTORY in ORGANIZATION_USAGE) is for organization-level usage, not individual tables.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which two queries can a user with appropriate privileges execute to view the data storage details for individual tables?
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
No comments yet.