SnowPro Core Certification — Question 1017

What does Snowflake recommend when planning virtual warehouse usage for a data load?

Answer options

• A. Load the fewest possible number of large files.
• B. Dedicate a separate warehouse for loading data.
• C. Increase the size of the warehouse used.
• D. Use several single-cluster warehouses.

Correct answer: B

Explanation

The correct answer, B, suggests allocating a separate warehouse for loading data, which helps isolate the loading process from other operations, ensuring performance is not impacted. Options A and C are less effective as they focus on file size and warehouse size rather than optimizing the loading process. Option D, while useful in some scenarios, does not specifically target the efficiency of loading data.