Answer-first summary for fast verification
Answer: Allows optimization of parallel operations
Snowflake recommends compressed file sizes between 100-250 MB because this size range allows for optimal parallel operations during data loading. Larger files enable better utilization of Snowflake's distributed architecture, where multiple nodes can process different parts of the data simultaneously. This improves loading performance and efficiency. Option D directly addresses this parallel processing benefit. Option A is incorrect because file size doesn't directly optimize warehouse settings. Option B is wrong as sequential loading contradicts Snowflake's parallel processing model. Option C is incorrect because larger files typically reduce latency issues rather than increase them, and accuracy is not dependent on file size.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Why does Snowflake recommend compressed file sizes between 100 MB and 250 MB for data loading?
A
Optimizes the virtual warehouse size and multi-cluster setting to economy mode
B
Allows a user to import the files in a sequential order
C
Increases the latency staging and accuracy when loading the data
D
Allows optimization of parallel operations