COF-C02 practice question 26 of 35

True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.

Full set: 778 questions
Answer options
A: True
B: False Correct answer
Correct Answer:
B. False
Explanation

Snowflake does not have a requirement that source data files be no larger than 16MB. In fact, for optimal loading performance using parallel operations, Snowflake's best practice recommendation is to split larger files into chunks of roughly 100 MB to 250 MB compressed. The 16MB figure is not a documented limit or requirement for data loading; it is a misconception. Smaller files can lead to inefficient processing queues.

Why Incorrect

True: This is incorrect. The official recommendation is for much larger file sizes (100-250MB) to optimize parallel loading, not a restrictive 16MB maximum.

References

- Snowflake Documentation: "Data Loading Considerations", section "File Sizing Recommendations and Limitations". It states, "For the best performance with COPY INTO, we recommend aiming for compressed data files that are roughly 100-250 MB in size."

Scroll to Top