
Answer-first summary for fast verification
Answer: Columnar format, Compressed format
Snowflake automatically reorganizes data into a columnar format and compresses it when loaded. The columnar format optimizes query performance by storing data by columns rather than rows, allowing efficient scanning of specific columns. Compression reduces storage costs and improves I/O efficiency. The community discussion with 100% consensus on BC confirms this, and Snowflake's documentation states data is stored in an 'optimized, compressed, columnar format.' Options A (Binary), D (Raw), and E (Zipped) are incorrect as they do not describe Snowflake's internal reorganization process; Snowflake uses its proprietary format, not generic binary, raw, or zipped formats.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.