Answer-first summary for fast verification
Answer: The TABLE_STORAGE_METRICS view in the INFORMATION_SCHEMA
The TABLE_STORAGE_METRICS view in the INFORMATION_SCHEMA (option C) provides the most current information about table-level storage utilization because INFORMATION_SCHEMA views reflect metadata in near real-time. In contrast, the ACCOUNT_USAGE schema (option B) has built-in latency of up to a few hours due to batch extraction processes, making it less current. Option A (data share view) surfaces the same lagged Account Usage data as option B. Option D (STORAGE_USAGE_HISTORY) is a historical time-series log rather than current point-in-time metrics. The community discussion confirms this understanding with 100% consensus on option C and detailed reasoning about the real-time nature of INFORMATION_SCHEMA versus the latency in ACCOUNT_USAGE views.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which view provides the most current information on table-level storage utilization?
A
The TABLE_STORAGE_METRICS view in a Snowflake data share
B
The TABLE_STORAGE_METRICS view in the ACCOUNT_USAGE schema
C
The TABLE_STORAGE_METRICS view in the INFORMATION_SCHEMA
D
The STORAGE_USAGE_HISTORY view in the INFORMATION_SCHEMA
No comments yet.