SnowPro Core Certification — Question 176

When loading data into Snowflake, how should the data be organized?

Answer options

• A. Into single files with 100-250 MB of compressed data per file
• B. Into single files with 1-100 MB of compressed data per file
• C. Into files of maximum size of 1 GB of compressed data per file
• D. Into files of maximum size of 4 GB of compressed data per file

Correct answer: A

Explanation

The correct answer is A because Snowflake recommends loading data in single files that are between 100-250 MB in compressed size to optimize performance. Options B, C, and D are not ideal as they either fall below the recommended size range or exceed the optimal file size for efficient data loading.