SnowPro Core Certification — Question 597

What does the average_overlaps in the output of SYSTEM$CLUSTERING_INFORMATION refer to?

Answer options

• 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.

Correct answer: C

Explanation

The correct answer, C, explains that average_overlaps represents the average number of micro-partitions with overlapping value ranges, which is crucial for understanding data distribution. Options A and B address different aspects of partitioning and storage that are not relevant to overlaps, while D relates to cloned objects, which does not pertain to the concept of overlapping value ranges.