Answer-first summary for fast verification
Answer: Each column is compressed as it is stored in a micro-partition.
The correct answer is A because Snowflake automatically compresses each column as it is stored in micro-partitions, using the most efficient compression algorithm determined automatically for each column. This is confirmed by the official Snowflake documentation and supported by the community discussion where option A has the highest upvotes (88% community selection and multiple comments with upvotes referencing the documentation). Option B is incorrect because Snowflake doesn't use just GZIP - it automatically selects the best compression algorithm. Option C is incorrect because Snowflake handles the compression itself, not the cloud storage provider. Option D is incorrect because Snowflake compresses all data types, not just text data.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How is data in a table compressed within Snowflake?
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.
No comments yet.