SnowPro Core Certification — Question 802

What can be done to reduce queueing on a virtual warehouse?

Answer options

• A. Increase the AUTO_SUSPEND setting for the warehouse.
• B. Change the warehouse to a multi-cluster warehouse.
• C. Increase the warehouse size.
• D. Lower the MAX_CONCURRENCY_LEVEL setting for the warehouse.

Correct answer: B

Explanation

Changing the warehouse to a multi-cluster warehouse allows for handling more concurrent queries, thereby reducing queueing. Increasing the warehouse size (Option C) may help but does not directly address concurrency issues. Raising the AUTO_SUSPEND setting (Option A) and lowering the MAX_CONCURRENCY_LEVEL (Option D) would likely exacerbate queueing rather than alleviate it.