SnowPro Core Certification — Question 1249

What is a fundamental characteristic of Snowflake micro-partitions?

Answer options

• A. They can be read directly as files.
• B. They serve as an index for Snowflake tables.
• C. They are sized based on Time Travel requirements.
• D. Once established, they cannot be changed.

Correct answer: D

Explanation

The correct answer is D, as once micro-partitions are created in Snowflake, their structure cannot be altered. Option A is incorrect because micro-partitions are not directly accessible as files, they are managed by Snowflake. Option B is misleading since micro-partitions are used to optimize data retrieval but do not function as a traditional index. Option C is incorrect because the size of micro-partitions is not dependent on Time Travel, but rather on the data distribution and optimization for query performance.