SnowflakeSnowflake
COF-C02 · Question #668
COF-C02 Question #668: Real Exam Question with Answer & Explanation
The correct answer is D: Allows optimization of parallel operations. Snowflake recommends file sizes between 100-250 MB compressed when loading data to optimize parallel processing. Smaller, compressed files can be loaded in parallel, which maximizes the efficiency of the virtual warehouses and speeds up the data loading process.
Data Loading and Unloading
Question
Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?
Options
- AOptimizes the virtual warehouse size and multi-cluster setting to economy mode
- BAllows a user to import the files in a sequential order
- CIncreases the latency staging and accuracy when loading the data
- DAllows optimization of parallel operations
Explanation
Snowflake recommends file sizes between 100-250 MB compressed when loading data to optimize parallel processing. Smaller, compressed files can be loaded in parallel, which maximizes the efficiency of the virtual warehouses and speeds up the data loading process.
Topics
#Data Loading#Best Practices#Performance Optimization#Parallel Processing
Community Discussion
No community discussion yet for this question.