SnowPro Core Certification — Question 1160

A single cluster virtual warehouse has no free resources.

What will happen to new queries that are run against this warehouse?

Answer options

• A. The queries will be assigned to another virtual warehouse.
• B. The queries will be skipped.
• C. The queries will be placed in a queue.
• D. The warehouse will automatically resize and execute the queries.

Correct answer: C

Explanation

The correct answer is C because when a virtual warehouse runs out of resources, new queries are queued until resources become available. Option A is incorrect as queries cannot be redirected to another warehouse if they belong to a specific one. Option B is not right since the queries are not skipped; they are queued instead. Option D is false because the warehouse does not resize automatically in this scenario.