SnowPro Core Certification — Question 375

What is a characteristic of data micro-partitioning in Snowflake?

Answer options

• A. Micro-partitioning may introduce data skew
• B. Micro-partitioning requires the definition of a partitioning schema
• C. Micro-partitioning happens when the data is loaded
• D. Micro-partitioning can be disabled within a Snowflake account

Correct answer: C

Explanation

The correct answer is C because micro-partitioning occurs automatically when data is loaded into Snowflake, optimizing storage and query performance. Option A is incorrect as data skew is not an inherent characteristic of micro-partitioning, B is wrong because no predefined schema is needed, and D is misleading since micro-partitioning cannot be disabled as it is a fundamental feature of Snowflake.