Snowpro Core · Free Practice Question Medium

Question 50

Which of the following statement describe micro-partitions correctly?
  • A Micro-partitions are mutable and can be updated.
  • B Data in micro-partitions is organized in a columnar format.
  • C Data in micro-partitions is organized in a row storage format.
  • D Micro-partitions are immutable.
Reveal correct answers

Correct answers: B, D

Explanation

Snowflake partitions are immutable, which means they cannot be changed once created. Table data is mapped to individual micro-partitions and is further organized using a columnar format. https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html

Discussion

Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.

You must be logged in to post a comment.

Preparing For

Your Certification?

255+ certifications
Detailed explanations
Free PDF samples

Has All The Questions You Need