SnowPro Core Exam QuestionsBrowse all questions from this exam

SnowPro Core Exam - Question 1283


When cloning tables, which INFORMATION_SCHEMA view will show different columns for owned storage and referenced storage?

Show Answer
Correct Answer:

Discussion

2 comments
Sign in to comment
37ceea2Option: C
Jan 31, 2025

A and B refer to Databases and stages. D - It seems that STORAGE_USAGE is Account Usage schema, only. C - this is what remains

BillhardyOption: C
Apr 20, 2025

Among the Information Schema views that expose storage usage, TABLE_STORAGE_METRICS is the only one that breaks out owned versus referenced storage bytes when tables are cloned. Cloned tables share underlying micro‑partitions; Snowflake tracks which bytes are “owned” by the active table versus those “referenced” (retained because another clone still needs them). The TABLE_STORAGE_METRICS view surfaces distinct columns for these categories, whereas the other views do not.