SnowPro Core Certification — Question 1200

When creating a virtual warehouse, what setting should be used to avoid both over-provisioning resources and auto-scaling when there is increased concurrency?

Answer options

• A. WAREHOUSE_SIZE = LARGE
• B. WAREHOUSE_TYPE = SNOWPARK-OPTIMIZED
• C. MAX_CLUSTER_COUNT =10
• D. ENABLE_QUERY_ACCELERATION = TRUE

Correct answer: C

Explanation

The correct answer is C because setting MAX_CLUSTER_COUNT to 10 limits the number of clusters that can be spawned, thus preventing auto-scaling. The other options either increase resource allocation or enable features that do not directly control scaling behavior.