Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?
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
The Answer Is:
D
This question includes an explanation.
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
COF-C03 PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 65% Discount on All Products,
Use Coupon: "ac4s65"