SOL-C01 Question #143: Real Exam Question with Answer & Explanation

Question

A Snowflake account has a virtual warehouse named `ANALYTICS WH' configured with multi- clustering. The MIN CLUSTER COUNT is set to 1, and the MAX CLUSTER COUNT is set to 3. During a period of heavy query load, all three clusters are active. However, after the peak period, the query load decreases significantly. Which of the following statements are TRUE regarding the automatic scaling behavior of this virtual warehouse? (Select TWO)

Options

• ASnowflake will automatically suspend all clusters when the query load drops below a certain
• BSnowflake will automatically reduce the number of active clusters down to the
• CSnowflake will immediately suspend all idle clusters to minimize credit consumption.
• DSnowflake will maintain all three clusters indefinitely, regardless of the query load, until the
• EThe time it takes for Snowflake to reduce the number of clusters depends on the `SCALING

Explanation

Snowflake automatically scales down the number of active clusters in a multi-cluster warehouse when the query load decreases, eventually reducing it to the MIN_CLUSTER_COUNT (1) (B). The 'SCALING_POLICY determines how aggressively Snowflake scales the warehouse up and down. 'ECONOMY' scales down more aggressively than 'STANDARD' to minimize credit consumption (E). Snowflake will not suspend all clusters entirely if MIN_CLUSTER_COUNT is set to 1 . The clusters are not suspended immediately (C). (D) is incorrect as Snowflake does automatically scale down.

No community discussion yet for this question.