Answer-first summary for fast verification
Answer: A user can specify the maximum and minimum number of cluster(s).
The correct answer is D because multi-cluster warehouses in Snowflake automatically scale by adding or removing clusters based on workload demand, allowing users to specify minimum and maximum cluster counts. This provides automatic elasticity without manual intervention, which is a key advantage over single-cluster warehouses that require manual resizing. Options A, B, and C describe capabilities that apply to both single-cluster and multi-cluster warehouses equally, not unique advantages of multi-cluster warehouses. The community discussion shows strong consensus (100% of answers) for D, with comments emphasizing that multi-cluster warehouses eliminate the need for manual resizing to handle fluctuating workloads.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
What is an advantage of using a multi-cluster warehouse compared to a single-cluster warehouse in Snowflake?
A
A user can auto-suspend a running warehouse due to inactivity.
B
A user can specify a warehouse size while configuring it for use.
C
A user can resize a warehouse at any time whether running or not.
D
A user can specify the maximum and minimum number of cluster(s).