SnowPro Advanced: Architect — Question 181

An Architect wants to alter a virtual warehouse for horizontal scaling, but did not find where to configure minimum and maximum clusters in the interface even though they have an ACCOUNTADMIN role.

What is MOST likely the issue?

Answer options

• A. They do not have the necessary CREATE WAREHOUSE privilege.
• B. They are using an incorrect SQL command to alter the warehouse clusters.
• C. They are using Standard Snowflake edition where multi-cluster is not available.
• D. They need to create a ticket with Snowflake Support to fix the issue.

Correct answer: C

Explanation

The correct answer is C because the Standard Snowflake edition does not offer the multi-cluster feature necessary for horizontal scaling. Option A is incorrect since the ACCOUNTADMIN role typically includes the CREATE WAREHOUSE privilege. Option B is not applicable as the issue is related to the edition rather than SQL commands, and option D is not necessary if the edition does not support the feature.