A. True
Once a micro-partition is created in Snowflake, it cannot be modified. Micro-partitions are immutable, meaning that after data is written to them, they cannot be altered or updated directly. However, Snowflake automatically manages data storage and optimization. If data in a micro-partition needs to be updated, the system will create new micro-partitions with the updated data, and older partitions will eventually be marked for deletion during data maintenance operations like vacuuming.
This immutability helps Snowflake maintain its performance and data consistency over time.
How can we say a micro-partition can't be changed if using clustering keys we're literally changing how micro-partitions are organized? I think it's B, can't find these "immutable" references from the other answers anywhere. https://community.snowflake.com/s/article/understanding-micro-partitions-and-data-clustering
In reclustering context, reorganizing doesn't mean that anything changes in existing micro-partitions' structure - instead the new micro-partitions are created with the same keys as in old micro-partitions before reclustering but reorganized to fit the clustering requirements. Check this article for a reference:
https://docs.snowflake.com/en/user-guide/tables-clustering-keys#reclustering
Check the diagram from a provided example. New micro-partitions are called "new" for a reason, also the new numbering (micro-partition 5, 6, 7, 8) should give you a clue.
The immutability of micro partition it means that there could be changes in relation to the status of the data in micro partition, so it could be updated or deleted but this is kept as information. But the data itself cannot be changed.Even if update with the clustering key it will add new micropartitions with the changes
The answer is correct as
How did they do this? Let’s break down how Snowflake stores data: in Snowflake, all data is stored in micro-partitions, which are contiguous units of storage that are immutable.
Immutability means that once a micro-partition is written, it will never be changed
While True, it is important to note new micro-partitions are created when new data is uploaded or data is transformed. Additional old micro-paritions are stored for time-travel support purposes
Correct, it can never be changed. They are immutable.
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
vhvhkkk
6 days, 8 hours agoMallikharjuna452
4 months ago[Removed]
1 year agoThaiya
1 year, 2 months agoifmateus
1 year, 2 months agorogerek077
7 months, 3 weeks agoMayuri917233
1 year, 6 months agojurges
1 year, 10 months agokjdfsafc87456
2 years, 2 months agolhstudylh
2 years, 8 months agoSid460545
2 years, 9 months ago