Which metadata table will store the storage utilization information even for dropped tables?

The correct answer is B. TABLE_STORAGE_METRICS. TABLE_STORAGE_METRICS is a metadata table in the Snowflake INFORMATION_SCHEMA that tracks storage utilization at the table level, and crucially, it retains records even for dropped tables (those still within the Time Travel or Fail-safe retention period). This makes it useful…

Storage and Data Protection

Question

Options

ADATABASE_STORAGE_USAGE_HISTORY
BTABLE_STORAGE_METRICS
CSTORAGE_DAILY_HISTORY
DSTAGE STORAGE USAGE HISTORY

How the community answered

(53 responses)

A
2% (1)
B
92% (49)
C
4% (2)
D
2% (1)

Explanation

TABLE_STORAGE_METRICS is a metadata table in the Snowflake INFORMATION_SCHEMA that tracks storage utilization at the table level, and crucially, it retains records even for dropped tables (those still within the Time Travel or Fail-safe retention period). This makes it useful for auditing storage usage of deleted objects. DATABASE_STORAGE_USAGE_HISTORY tracks database-level aggregate storage over time but is oriented toward historical trend data rather than individual dropped-table granularity. STORAGE_DAILY_HISTORY and STAGE STORAGE USAGE HISTORY are not standard Snowflake metadata table names.

Topics

#Storage Utilization#Account Usage#Metadata Tables#Dropped Tables

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice