Answer: TABLE_STORAGE_METRICS

The correct answer is C (TABLE_STORAGE_METRICS) because it is the only INFORMATION_SCHEMA view that distinguishes between owned and referenced storage bytes for cloned tables. When tables are cloned in Snowflake, they share underlying micro-partitions, and TABLE_STORAGE_METRICS provides separate columns to track storage that is 'owned' by the active table versus storage that is 'referenced' (retained because another clone depends on it). Option A (DATABASE_STORAGE_USAGE_HISTORY) and B (STAGE_STORAGE_USAGE_HISTORY) are incorrect as they pertain to database and stage storage, not table-level cloning details. Option D (STORAGE_USAGE) is also incorrect because it is part of the ACCOUNT_USAGE schema, not INFORMATION_SCHEMA, and does not break down owned versus referenced storage for clones. The community discussion confirms this, with 100% consensus on C and explanations highlighting its unique capability to show these storage distinctions.

Author: LeetQuiz Editorial Team