COF-C02 Question #659: Real Exam Question with Answer & Explanation

The correct answer is B: False. Snowflake does not require source data files to be no larger than 16MB. In fact, Snowflake recommends that for optimal load performance, data files should be roughly 100-250 MB in size when compressed. However, it is not recommended to load very large files (e.g., 100 GB or large

Data Loading and Unloading

Question

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

Options

ATrue
BFalse

Explanation

Snowflake does not require source data files to be no larger than 16MB. In fact, Snowflake recommends that for optimal load performance, data files should be roughly 100-250 MB in size when compressed. However, it is not recommended to load very large files (e.g., 100 GB or larger) due to potential delays and wasted credits if errors occur. Smaller files should be aggregated to minimize processing overhead, and larger files should be split to distribute the load among compute resources in an active warehouse.

Topics

#Data Loading#File Size Limits#Ingestion

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice Browse All COF-C02 Questions