SnowPro Core Certification — Question 1311

Which statements are true of micro-partitions? (Choose two.)

Answer options

• A. They are approximately 16MB in size
• B. They are stored compressed only if COMPRESS=TRUE on Table
• C. They are immutable
• D. They are only encrypted in the Enterprise edition and above

Correct answer: A, C

Explanation

The correct answers, A and C, indicate that micro-partitions are designed to be approximately 16MB in size and are immutable, meaning they cannot be altered once created. Options B and D are incorrect because micro-partitions can be compressed regardless of the COMPRESS parameter, and encryption is not limited to the Enterprise edition.