Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Go to Exam

Question 625

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

The average number of micro-partitions stored in Time Travel.

The average number of partitions physically stored in the same location.

The average number of micro-partitions which contain overlapping value ranges.

The average number of micro-partitions in the table associated with cloned objects.

Correct Answer: C

The average_overlaps in the output of SYSTEM$CLUSTERING_INFORMATION refers to the average number of micro-partitions which contain overlapping value ranges.

Discussion

MultiCloudIronManOption: C

Correct

Kvk117Option: C

Verified

chuks_charleyOption: C

https://docs.snowflake.com/en/sql-reference/functions/system_clustering_information

HeetecOption: C

C correct