Answer-first summary for fast verification
Answer: 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.
Based on the community discussion and Snowflake documentation, options B and C are correct. B is correct because micro-partitions are immutable objects that support Time Travel functionality, allowing data recovery and historical queries. C is correct because micro-partitions enable fine-grained pruning, where only relevant partitions are scanned during queries, significantly reducing I/O from object storage to virtual warehouses. Option A is incorrect as micro-partitions can overlap in their range of values to prevent data skew. Option D is incorrect because rows are not automatically sorted within micro-partitions; the order depends on how data is inserted. Option E is incorrect since micro-partitions are automatically derived from data and not defined on a schema-by-schema basis.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
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.