SnowPro Core Certification — Question 398

Which file format is MOST performant in Snowflake for data loading?

Answer options

• A. Parquet
• B. CSV
• C. ORC
• D. Avro

Correct answer: B

Explanation

CSV is the most performant format for data loading in Snowflake due to its simplicity and efficiency in handling structured data. Other formats like Parquet, ORC, and Avro, while useful for different scenarios, introduce additional complexity and overhead that can slow down the loading process.