SnowPro Core Certification — Question 453

How are micro-partitions typically generated in Snowflake?

Answer options

• A. Automatically
• B. ORDER BY [];
• C. PARTITION BY [];
• D. GROUP BY [];

Correct answer: A

Explanation

Micro-partitions in Snowflake are generated automatically by the system to optimize storage and performance. The other options, such as ORDER BY, PARTITION BY, and GROUP BY, are SQL clauses used for organizing query results but do not control the creation of micro-partitions.