Which view can be used to determine if a table has frequent row updates or deletes?

The correct answer is B. TABLE_STORAGE_METRICS. The TABLE_STORAGE_METRICS view is the correct view for identifying tables with frequent row updates or deletes. When rows are updated or deleted, Snowflake's immutable micro-partition model retains the old versions of those rows in Time Travel and Fail-safe storage rather than…

Storage and Data Protection

Question

Options

ATABLES
BTABLE_STORAGE_METRICS
CSTORAGE_DAILY_HISTORY
DSTORAGE USAGE

How the community answered

(61 responses)

A
2% (1)
B
90% (55)
C
2% (1)
D
7% (4)

Explanation

The TABLE_STORAGE_METRICS view is the correct view for identifying tables with frequent row updates or deletes. When rows are updated or deleted, Snowflake's immutable micro-partition model retains the old versions of those rows in Time Travel and Fail-safe storage rather than overwriting them. Tables with heavy DML activity will show disproportionately high TIME_TRAVEL_BYTES and FAILSAFE_BYTES relative to ACTIVE_BYTES in this view, signaling frequent churn. The TABLES view (A) shows basic metadata without this storage breakdown. STORAGE_DAILY_HISTORY (C) tracks account-level daily storage trends. STORAGE_USAGE (D) provides aggregate storage consumption, not per-table DML indicators.

Topics

#System views#Storage monitoring#Table metrics#DML operations

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice