COF-C03 practice question 6 of 10

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

Full set: 1,126 questions
Answer options
A: True
B: False Correct answer
Correct Answer:
B. False
Explanation

The statement is False. Snowflake does not impose a requirement that source data files be no larger than 16MB. While there are performance best practices for file sizing to optimize parallel loading, these are recommendations, not hard limits. Snowflake recommends splitting larger data files into smaller chunks, typically between 10MB and 250MB compressed. This allows Snowflake to distribute the load across multiple servers in a warehouse. Files larger than this can still be loaded, but it may not be as efficient.

Why Incorrect

This is a True/False question. The statement is false because the 16MB figure is not a requirement; it's a misstatement of a general performance guideline for which the recommended range is much broader.

References

1. Snowflake Documentation. (n.d.). Data Loading Considerations. Retrieved from https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare.html. In the section "File Sizing Best Practices and Performance," it states, "For the best performance... we recommend aiming for compressed file sizes between 100 MB and 250 MB." It also mentions that smaller files (e.g., 10MB) can be suitable. It never mentions a 16MB maximum requirement.

Scroll to Top