Answer: TABLE_STORAGE_METRICS

The correct answer is B (TABLE_STORAGE_METRICS) because this Snowflake metadata view specifically displays table-level storage utilization information that includes data for dropped tables that are still incurring storage costs. According to the Snowflake documentation and the community discussion consensus (with 100% agreement and multiple upvoted comments), TABLE_STORAGE_METRICS is designed to show storage billing information for all tables in the account, including those that have been dropped but still have storage costs. The other options are incorrect: DATABASE_STORAGE_USAGE_HISTORY shows database-level usage, STORAGE_DAILY_HISTORY shows daily storage metrics, and STAGE_STORAGE_USAGE_HISTORY shows stage storage usage - none of these specifically include dropped table data in the same way TABLE_STORAGE_METRICS does.

Author: LeetQuiz Editorial Team