SnowPro Core Certification — Question 247

Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

Answer options

• 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

Correct answer: D

Explanation

The recommended file size of 100-250 MB compressed allows for better optimization of parallel operations in Snowflake, leading to improved performance during data loading. Options A, B, and C do not address the benefits of parallel processing, which is crucial for efficiency in data ingestion.