Snowpro Core · Free Practice Question Medium
Question 83
What is the primary benefit of introducing a clustering key on a table in Snowflake?
-
A
Increases the maximum number of partitions
-
B
Reduces storage costs significantly
-
C
Automatically compresses all data types more effectively
-
D
Improves query performance by enhancing partition pruning
Reveal correct answer
Correct answer: D
A.
Clustering does not change the number of partitions; instead, it optimizes how data is distributed across them.
B.
While clustering can have secondary effects on storage due to better compression, its primary function is not directly aimed at reducing storage costs.
C.
Clustering may improve compression for specific data types by grouping similar rows, but it does not automatically compress all data types more effectively.
D.
The primary purpose of a clustering key is to improve query performance by enhancing partition pruning. It organizes data in a way that allows Snowflake to ignore unnecessary partitions when a query is executed, which leads to faster results.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
