SnowPro Core Certification — Question 669

How does Snowflake reorganize data when it is loaded? (Choose two.)

Answer options

• A. Binary format
• B. Columnar format
• C. Compressed format
• D. Raw format
• E. Zipped format

Correct answer: B, C

Explanation

Snowflake reorganizes data into a Columnar format for efficient querying and storage, which allows for better compression and faster access to the data. Compressed format is also utilized to reduce the storage footprint and improve performance. The other options, such as Binary format, Raw format, and Zipped format, do not accurately describe how Snowflake structures its data during loading.