
Answer-first summary for fast verification
Answer: Depth
The correct answer is B (Depth) because clustering depth is the specific metric that measures how well a table is clustered with respect to specified columns. According to Snowflake documentation and the community discussion, clustering depth represents the average depth of overlapping micro-partitions for specified columns, where a smaller depth indicates better clustering. This metric is explicitly designed to monitor clustering 'health' and determine whether a large table would benefit from defining an explicit clustering key. The other options are incorrect: Percentage, Ratio, and Total partition count are not standard clustering indicators used for this specific purpose in Snowflake.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.