Answer: Set the Minimum Clusters and Maximum Clusters settings to the different values

The correct answer is D because Snowflake's auto-scale mode for multi-cluster warehouses is specifically enabled by setting different values for Minimum Clusters and Maximum Clusters. This configuration allows Snowflake to dynamically scale clusters up and down based on workload demands, starting additional clusters when queries queue due to insufficient resources (up to the maximum) and shutting down clusters when load decreases. Option A is incorrect as 'Auto-Scale' is not a setting name; option B is wrong because 'Auto' refers to warehouse size, not multi-cluster scaling; option C is incorrect because setting Minimum and Maximum Clusters to the same value enables maximized mode (fixed number of clusters), not auto-scale mode. The community discussion strongly supports D with 100% consensus and detailed reasoning referencing Snowflake documentation.

Author: LeetQuiz Editorial Team