SnowPro Core Certification — Question 296

Which of the following are benefits of micro-partitioning? (Choose two.)

Answer options

• A. Micro-partitions cannot overlap in their range of values.
• B. Micro-partitions are immutable objects that support the use of Time Travel.
• C. Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses.
• D. Rows are automatically stored in sorted order within micro-partitions.
• E. Micro-partitions can be defined on a schema-by-schema basis.

Correct answer: B, C

Explanation

The correct answers, B and C, highlight that micro-partitions are immutable and enable Time Travel, while also minimizing I/O operations between object storage and virtual warehouses. Options A, D, and E do not represent benefits of micro-partitioning, as they pertain to characteristics or restrictions rather than advantages.