Answer: TABLE_STORAGE_METRICS

The TABLE_STORAGE_METRICS view is specifically designed to provide storage metrics for tables, including metrics that help identify tables with frequent UPDATE or DELETE operations. As confirmed by the community discussion with 100% consensus and upvoted comments referencing Snowflake documentation, this view contains columns like FAILSAFE_BYTES and ACTIVE_BYTES. A high ratio of FAILSAFE_BYTES to ACTIVE_BYTES indicates significant data churn from frequent updates or deletes, as failsafe storage retains historical versions of modified or deleted data. The other options are incorrect: TABLES is an INFORMATION_SCHEMA view showing table metadata but not storage metrics; STORAGE_DAILY_HISTORY and STORAGE_USAGE provide account-level or general storage usage data, not table-specific churn indicators.

Author: LeetQuiz Editorial Team