Snowflake COF-R02 Question Answer
Which of the following are benefits of micro-partitioning? (Select TWO)
Micro-partitions cannot overlap in their range of values
Micro-partitions are immutable objects that support the use of Time Travel.
Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses
Rows are automatically stored in sorted order within micro-partitions
Micro-partitions can be defined on a schema-by-schema basis
https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html
TESTED 02 Aug 2025
Copyright © 2014-2025 ACE4Sure. All Rights Reserved