SnowPro Core Certification — Question 1001

How are micro-partitions enabled on Snowflake tables?

Answer options

• A. Micro-partitioning requires a cluster key on a table.
• B. Micro-partitioning is automatically performed on a table.
• C. Micro-partitioning requires the use of the search optimization service.
• D. Micro-partitioning is defined by the user when a table is created.

Correct answer: B

Explanation

The correct answer is B because micro-partitioning in Snowflake occurs automatically without any manual intervention. Options A, C, and D are incorrect as they imply additional requirements or steps that are not necessary for enabling micro-partitions.