SnowPro Core Certification — Question 493

If all virtual warehouse resources are maximized while processing a query workload, what will happen to new queries that are submitted to the warehouse?

Answer options

• A. All queries will terminate when the resources are maximized.
• B. The warehouse will scale out automatically
• C. The warehouse will move to a suspended state.
• D. New queries will be queued and executed when capacity is available.

Correct answer: D

Explanation

The correct answer is D because when all resources are consumed, any additional queries are queued until capacity becomes available. Options A, B, and C are incorrect as they do not accurately describe the behavior of the virtual warehouse under these conditions.