
Answer-first summary for fast verification
Answer: Clustering keys
The question asks about a feature that physically reorganizes a very large table based on one or more columns. In Snowflake, clustering keys are specifically designed for this purpose—they define the order in which data is physically stored in micro-partitions to optimize query performance by co-locating related data. The community discussion shows a 100% consensus on option B, with multiple users confirming it as correct and referencing the official Snowflake documentation on clustering keys. Options A (Micro-partitions) are the underlying storage units but not the feature used for reorganization; options C (Key partitions) and D (Clustered partitions) are not standard Snowflake terminology and do not align with the platform's features.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.