SnowPro Core Certification — Question 443

What is the MOST performant file format for loading data in Snowflake?

Answer options

• A. CSV (Unzipped)
• B. Parquet
• C. CSV (Gzipped)
• D. ORC

Correct answer: C

Explanation

CSV (Gzipped) is considered the most performant file format for loading data in Snowflake because it compresses the data, reducing the amount of data transferred and improving load times. In contrast, unzipped CSV files are larger and slower to load, while Parquet and ORC formats, although efficient for storage and querying, do not always match the performance of gzipped CSVs for loading operations.