Which property helps Snowflake group rows into the same micro-partition?

• A. Large enough number of distinct values to enable effective pruning on the table
• B. Small enough number of distinct values to allow Snowflake to effectively group rows in the same micro-partition
• C. The clustering key must have a single distinct value
• D. The clustering key values must be completely uniform

Answer: (B)

Grouping rows into the same micro-partition depends on the clustering key’s cardinality. When there are only a few distinct values (low cardinality) in the clustering key, Snowflake can place many rows that share the same value into the same micro-partition. This makes pruning more effective during queries, because scans can skip partitions that don’t match the clustering key predicates. If there are many distinct values (high cardinality), rows spread across more micro-partitions, reducing pruning efficiency. The clustering key doesn’t need to have a single value or uniform values; the important factor is having a small number of distinct values to group related rows together.