Snowpro Core · Free Practice Question Easy
Question 48
When should a clustering key typically be avoided in Snowflake?
-
A
When the table has only one or two micro partitions
-
B
When the table contains timestamp data
-
C
When queries frequently use SELECT * statements
-
D
When the table has more than 10 columns
Reveal correct answer
Correct answer: A
A.
Clustering keys are less effective on tables with only one or two micro partitions because there isn't enough data to benefit from partition pruning.
B.
Timestamp data can be clustered effectively, especially if a function (e.g., extracting date) is used to reduce cardinality.
C.
Clustering keys optimize specific query patterns, such as selective queries using filters. SELECT * queries do not specifically benefit from clustering.
D.
The number of columns alone does not determine the need for a clustering key; it depends more on the size and usage of the table.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
