ExamGecko
Question list
Search
Search

Question 83 - COF-R02 discussion

Report
Export

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

A.
Micro-partitions cannot overlap in their range of values
Answers
A.
Micro-partitions cannot overlap in their range of values
B.
Micro-partitions are immutable objects that support the use of Time Travel.
Answers
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
Answers
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
Answers
D.
Rows are automatically stored in sorted order within micro-partitions
E.
Micro-partitions can be defined on a schema-by-schema basis
Answers
E.
Micro-partitions can be defined on a schema-by-schema basis
Suggested answer: A, D

Explanation:

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

asked 23/09/2024
Sanjay R Khiani
42 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first