ExamGecko
Question list
Search
Search

Question 25 - COF-C02 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: B, C

Explanation:

Micro-partitions in Snowflake are immutable objects, which means once they are written, they cannot be modified. This immutability supports the use of Time Travel, allowing users to access historical data within a defined period. Additionally, micro-partitions can significantly reduce the amount of I/O from object storage to virtual warehouses. This is because Snowflake's query optimizer can skip over micro-partitions that do not contain relevant data for a query, thus reducing the amount of data that needs to be scanned and transferred.

References: [COF-C02] SnowPro Core Certification Exam Study Guide

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

asked 23/09/2024
Laura G
57 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first