
Answer-first summary for fast verification
Answer: It will automatically start and stop additional clusters as needed.
The question asks for one benefit of using a multi-cluster virtual warehouse. Option D is correct because multi-cluster warehouses automatically start and stop additional clusters to handle concurrent queries and varying workloads, which is a primary feature documented in Snowflake's official documentation. The community discussion confirms this with 100% consensus on D, and referenced documentation supports that multi-cluster warehouses scale out by adding clusters as needed. Option A is incorrect because data loading speed is not directly tied to multi-cluster configuration. Option B is misleading; while multi-cluster can optimize costs by scaling appropriately, it does not inherently reduce costs—improper use could increase them. Option C is incorrect because multi-cluster warehouses add clusters, not increase the size (compute resources) of individual warehouses.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What is a benefit of utilizing a multi-cluster warehouse?
A
It will speed up data loading.
B
It will reduce the cost of running the warehouse.
C
It will automatically increase the warehouse size as needed.
D
It will automatically start and stop additional clusters as needed.
No comments yet.