
Answer-first summary for fast verification
Answer: Automatic Clustering
The question asks which feature allows users to control the organization of data within micro-partitions. Automatic Clustering (C) is the correct answer because it enables users to define clustering keys that determine how data is physically organized and grouped within micro-partitions, optimizing query performance by co-locating similar data. This is supported by the community consensus (75% selected C), upvoted comments referencing Snowflake documentation, and explanations that clustering keys directly control micro-partition organization. Search Optimization Service (B) is incorrect as it creates optimized search access paths but does not control the physical organization of data in micro-partitions. Range Partitioning (A) and Horizontal Partitioning (D) are not Snowflake features; Snowflake uses automatic micro-partitioning instead.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.