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 questionsSnowflake 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.
True: This is incorrect. The official recommendation is for much larger file sizes (100-250MB) to optimize parallel loading, not a restrictive 16MB maximum.
- 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."
Keep practicing
Take the free COF-C02 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other COF-C02 practice questions
- Question 1What does Snowflake recommend regarding database object ownership? (Select TWO).
- Question 2What kind of value does a User-Defined Function (UDF) return? (Select TWO).
- Question 3How do Snowflake data providers share data that resides in different databases?
- Question 4What are supported file formats for unloading data from Snowflake? (Choose three.)
- Question 5A marketing co-worker has requested the ability to change a warehouse size on their mediu…
- Question 6What service is provided as an integrated Snowflake feature to enhance Multi-Factor Authe…
