SnowPro Core Certification — Question 124

Which of the following statements is true of Snowflake micro-partitioning?

Answer options

• 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

Correct answer: C

Explanation

The correct answer is C because Snowflake's micro-partitioning automatically organizes data based on the order of insertion, optimizing storage without requiring user intervention. Options A and D are incorrect as they misrepresent the behavior of micro-partitioning, and B is wrong since it does not need a predefined schema.