Which of the following are benefits of micro-partitioning? (Select TWO)

Which of the following are benefits of micro-partitioning? (Select TWO)
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

View Answer

Answer: B, C

Explanation:

Micro-partitions in Snowflake are immutable objects, which means once they are written, they cannot be modified. This immutability supports the use of Time Travel, allowing users to access historical data within a defined period. Additionally, micro-partitions can significantly reduce the amount of I/O from object storage to virtual warehouses. This is because Snowflake’s query optimizer can skip over micro-partitions that do not contain relevant data for a query, thus reducing the amount of data that needs to be scanned and transferred.

Reference: [COF-C02] SnowPro Core Certification Exam Study Guide

https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html