Which of the following are benefits of micro-partitioning? (Select TWO)

The correct answer is A. Micro-partitions cannot overlap in their range of values D. Rows are automatically stored in sorted order within micro-partitions. https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html

Snowflake Overview and Architecture

Question

Options

AMicro-partitions cannot overlap in their range of values
BMicro-partitions are immutable objects that support the use of Time Travel.
CMicro-partitions can reduce the amount of I/O from object storage to virtual warehouses
DRows are automatically stored in sorted order within micro-partitions
EMicro-partitions can be defined on a schema-by-schema basis

How the community answered

(23 responses)

A
83% (19)
B
4% (1)
C
4% (1)
E
9% (2)

Explanation

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

Topics

#micro-partitioning#storage optimization#pruning

Community Discussion

No community discussion yet for this question.

Full COF-R02 Practice