
Explanation:
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.
Ultimate access to all questions.
No comments yet.
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.