Snowpro Core · Free Practice Question Easy
Question 36
Which of the following illustration represents the least well-clustered table?
- A 2
- B 1
- C 3
- D 4
Reveal correct answer
Correct answer: D
Explanation
For a populated table, the clustering depth is the average depth of overlapping micro-partitions for specific columns. The clustering depth starts at 1 (for a well-clustered table) and can be a larger number. If the average depth is smaller, the data for the specified columns are better clustered. https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions#label-clustering-depthDiscussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
