SnowPro Core Certification — Question 457

How is table data compressed in Snowflake?

Answer options

• A. Each column is compressed as it is stored in a micro-partition.
• B. Each micro-partition is compressed as it is written into cloud storage using GZIP.
• C. The micro-partitions are stored in compressed cloud storage and the cloud storage handles compression.
• D. The text data in a micro-partition is compressed with GZIP but other types are not compressed.

Correct answer: A

Explanation

The correct answer is A because Snowflake compresses each column individually as it is stored in a micro-partition, optimizing storage efficiency. Options B and C are incorrect as they suggest different levels of compression that do not accurately reflect Snowflake’s method, while option D incorrectly states that only text data is compressed.