Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
Which of the following are benefits of Snowflake's micro-partitioning? (Choose 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.