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 questionsThe 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.
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.
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.
Keep practicing
Take the free COF-C03 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other COF-C03 practice questions
- Question 1What is the primary purpose for configuring multiple Identity Providers, or IdPs, in Snow…
- Question 2At what level is the MIN_DATA_RETENTION_TIME_IN_DAYS parameter set?
- Question 3Which commands are restricted in owner's rights stored procedures? (Select TWO).
- Question 4Which views are included in the DATA SHARING USAGE schema? (Select TWO).
- Question 5Snowflake's access control framework combines which models for securing data? (Select TWO…
- Question 7True or False: Fail-safe can be disabled within a Snowflake account.
