What is the MOST performant file format for loading data in Snowflake?
A . CSV (Unzipped)
B . Parquet
C . CSV (Gzipped)
D . ORC
Answer: B
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.
Reference: [COF-C02] SnowPro Core Certification Exam Study Guide
Snowflake Documentation on Data Loading1
Latest COF-C02 Dumps Valid Version with 254 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund