COF-C02 · Question #25
COF-C02 Question #25: Real Exam Question with Answer & Explanation
The correct answer is B: Parquet. Parquet is a columnar storage file format that is optimized for performance in Snowflake. It is designed to be efficient for both storage and query performance, particularly for complex queries on large datasets. Parquet files support efficient compression and encoding schemes, w
Question
What is the MOST performant file format for loading data in Snowflake?
Options
- ACSV (Unzipped)
- BParquet
- CCSV (Gzipped)
- DORC
Explanation
Parquet is a columnar storage file format that is optimized for performance in Snowflake. It is designed to be efficient for both storage and query performance, particularly for complex queries on large datasets. Parquet files support efficient compression and encoding schemes, which can lead to significant savings in storage and speed in query processing, making it the most performant file format for loading data into Snowflake.
Topics
Community Discussion
No community discussion yet for this question.