
Ultimate access to all questions.
Deep dive into the quiz with AI chat providers.
We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.
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.