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

Answer: A,D

Explanation:

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

Latest COF-C02 Dumps Valid Version with 254 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments