Which statements are true of micro-partitions? (Choose two.)
Which statements are true of micro-partitions? (Choose two.)
Micro-partitions in Snowflake are approximately 16MB in size after compression, which makes them highly efficient for storage and processing. They are immutable, meaning once data is written to a micro-partition, it cannot be altered. This immutability ensures data integrity and allows for efficient data retrieval and queries.
- micro-partitions are small in size (50 to 500 MB, before compression) - 16 MB must comes from old version/question - COMPRESSION = NONE is the right
Your answer was a little unclear to me. Uncompressed the data of a micro partition would be around 50-500 MB, while compressed it is around 16 MB. Second answer is that these micro partitions are immutable
Answer is correct
The size of 50-500MB is for uncompressed data and micropartition itself holds around 16MB(after compression). https://stackoverflow.com/questions/67945427/clarification-on-the-snowflake-micro-partition-size
16 MB compressed
AC correct
A and C. They are approximately 16MB in size and also immutable.
AC are correct
I believe A and C are correct.
AC are correct
A and C are correct
A and C are Correct.after loading into the table the data would be compressed.