
Answer-first summary for fast verification
Answer: Micro-partitioning is transparently completed using the ordering that occurs when the data is inserted/loaded
Option C is correct because Snowflake's micro-partitioning is automatically and transparently applied based on the natural ordering of data as it's inserted or loaded, without requiring manual partitioning schema definition. This is a fundamental characteristic of Snowflake's architecture. Option A is incorrect because micro-partitioning is designed to minimize data skew, not introduce it. Option B is incorrect because no upfront partitioning schema is required - Snowflake handles partitioning automatically. Option D is incorrect because micro-partitioning is a core architectural feature that cannot be disabled; it's fundamental to Snowflake's performance and storage optimization.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which of the following statements is true regarding Snowflake micro-partitions?
A
Micro-partitioning has been known to introduce data skew
B
Micro-partitioning: requires a partitioning schema to be defined up front
C
Micro-partitioning is transparently completed using the ordering that occurs when the data is inserted/loaded
D
Micro-partitioning can be disabled within a Snowflake account
No comments yet.