Which statement correctly describes Snowflake micro-partitions?

• A. Micro partitions are derived automatically.
• B. Micro partitions must be defined up-front.
• C. Micro-partitions are uncompressed.
• D. Micro partitions are always larger than 1 GB.

Answer: (A)

Micro-partitions in Snowflake are created automatically by the system as data is loaded, forming small, contiguous blocks stored in a columnar format. Snowflake derives these partitions behind the scenes and maintains metadata (like min and max values) to enable fast pruning during queries, so you don’t have to define them yourself.

They aren’t defined up front, they aren’t uncompressed, and their size isn’t fixed to be larger than a gigabyte—the size varies with the data and is managed automatically by Snowflake.