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-partitioning is a key feature of Snowflake’s architecture, providing several benefits:

Micro-partitions are immutable objects that support the use of Time Travel. Each time data is loaded or modified, new micro-partitions are created, preserving the previous versions of data to enable Time Travel and historical data querying.

Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses. Snowflake’s query optimizer leverages metadata about micro-partitions, such as the range of values within them, to prune unnecessary micro-partitions from query scans. This reduces the amount of data read and improves query performance.