Snowpro Core · Free Practice Question Medium
Question 99
Which of the following statements accurately describe Snowflake's micro-partitioning architecture? (Choose two.)
-
A
Snowflake automatically manages the distribution of data across micro-partitions without user intervention.
-
B
Micro-partitions are dynamically resized based on query performance feedback.
-
C
Each micro-partition is immutable once created, ensuring consistent data retrieval.
-
D
Micro-partitions store data in a row-based format to optimize transaction processing.
-
E
Users can manually merge or split micro-partitions to optimize storage utilization.
Reveal correct answers
Correct answers: A, C
A.
Snowflake's architecture automatically handles the distribution and organization of data across micro-partitions. Users do not need to manually manage how data is partitioned, as Snowflake optimizes this process to ensure efficient storage and fast query performance.
B.
Snowflake's micro-partitions are not dynamically resized based on query performance. Instead, Snowflake automatically manages the size and distribution of micro-partitions during data loading and maintenance operations to optimize performance and storage efficiency.
C.
Micro-partitions in Snowflake are immutable, meaning that once they are created during the data loading process, their data cannot be altered. This immutability ensures consistent and reliable data retrieval, as the data structure remains stable over time.
D.
Snowflake stores data within micro-partitions in a columnar format, not row-based. Columnar storage enhances query performance and compression efficiency, which are key benefits of Snowflake's architecture.
E.
Snowflake does not provide users with the ability to manually merge or split micro-partitions. The management of micro-partition sizes and distributions is handled internally by Snowflake to maintain optimal performance and storage efficiency.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
