SnowPro Core Certification — Question 564

How does Snowflake store a table's underlying data? (Choose two.)

Answer options

• A. Columnar file format
• B. Micro-partitions
• C. Text file format
• D. Uncompressed
• E. User-defined partitions

Correct answer: A, B

Explanation

Snowflake utilizes a columnar file format which optimizes storage and query performance, and it employs micro-partitions to manage the data efficiently and improve retrieval speeds. The other options, such as text file format, uncompressed, and user-defined partitions, do not align with Snowflake's architectural design for data storage.