Answer-first summary for fast verification
Answer: Dedicate a separate warehouse for loading data.
Snowflake recommends dedicating a separate warehouse for loading data to optimize performance. This approach prevents data loading operations from interfering with query performance, as loading large datasets can consume significant resources. Option B is directly supported by Snowflake documentation and community consensus with 100% agreement. Option A (loading few large files) is inefficient due to Snowflake's micro-partitioning architecture. Option C (increasing warehouse size) may help but doesn't address the fundamental separation of concerns. Option D (using several single-cluster warehouses) is suboptimal as it doesn't specifically address the load vs query separation that Snowflake recommends.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What is Snowflake's recommended approach for planning virtual warehouse usage during a data load?
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.
No comments yet.