
Ultimate access to all questions.
Which Snowflake feature allows customers to override the natural clustering of data in a table?
A
Micro-partitions
B
Clustering keys
C
Key partitions
D
Clustered partitions
Explanation:
The question asks which Snowflake feature allows customers to override the natural clustering of data in a table. Based on Snowflake documentation and the community discussion consensus (90% of users selected B, with multiple comments providing detailed reasoning and upvotes), clustering keys are the correct answer. Clustering keys allow users to specify one or more columns to reorganize data within micro-partitions, overriding Snowflake's natural clustering algorithms to optimize query performance through efficient micro-partition pruning. Option A (Micro-partitions) is incorrect as these are Snowflake's default storage units, not a user-override mechanism. Options C (Key partitions) and D (Clustered partitions) are not valid Snowflake terminology and do not represent the feature described.