Snowpro Core · Free Practice Question Medium
Question 25
What is the primary benefit of using clustering keys in Snowflake?
-
A
Increases storage capacity
-
B
Automatically compresses data in all tables
-
C
Reduces the number of micro partitions needed
-
D
Improves query performance through effective partition pruning
Reveal correct answer
Correct answer: D
A.
Clustering keys do not influence storage capacity but optimize how data is accessed.
B.
While clustering may improve compression indirectly, it is not the primary function. Clustering keys are mainly for performance optimization.
C.
Clustering keys do not reduce the number of micro partitions; they improve how the data is organized within them.
D.
Clustering keys in Snowflake are used to optimize how data is distributed across micro partitions, which helps in partition pruning. This improves query performance by skipping irrelevant partitions during query execution.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
