Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
SnowPro Core Certification · Snowflake
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
Micro-partitions are immutable
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.
A.True