Answer-first summary for fast verification
Answer: The average number of micro-partitions which contain overlapping value ranges.
The `average_overlaps` metric in SYSTEM$CLUSTERING_INFORMATION represents the average number of micro-partitions that contain overlapping value ranges for the specified clustering keys. This metric helps assess the effectiveness of clustering by indicating how much data overlap exists between micro-partitions - lower values indicate better clustering. Option C is correct based on Snowflake documentation and community consensus, with all community comments (100%) confirming C as the right answer and providing references to official documentation. Option A is incorrect as it relates to Time Travel storage, not clustering metrics. Option B is incorrect as it refers to physical storage location rather than value range overlap. Option D is incorrect as it involves cloned objects, which is unrelated to the clustering overlap metric.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
What does the average_overlaps metric in the output of the SYSTEM$CLUSTERING_INFORMATION function represent?
A
The average number of micro-partitions stored in Time Travel.
B
The average number of partitions physically stored in the same location.
C
The average number of micro-partitions which contain overlapping value ranges.
D
The average number of micro-partitions in the table associated with cloned objects.