
Answer-first summary for fast verification
Answer: True
The correct answer is A (True) because micro-partitions in Snowflake are immutable by design. Once created, the data within a micro-partition cannot be modified. When updates occur, Snowflake creates new micro-partitions with the updated data rather than modifying existing ones. This immutability supports features like Time Travel and maintains data consistency. The community discussion strongly supports this with 93% choosing A, and detailed explanations from multiple users confirm that while data can be updated at the table level through new micro-partitions, individual micro-partitions themselves remain unchanged once written. The comment suggesting B (False) misunderstands that clustering operations create new micro-partitions rather than modifying existing ones.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.