SnowPro Core Certification — Question 963

A virtual warehouse initially suffers from poor performance as a result of queries from multiple concurrent processes that are queuing. Over time, the problem resolved.

What action can be taken to prevent this from happening again?

Answer options

• A. Increase the size of the virtual warehouse.
• B. Add a cluster key to the most used JOIN key.
• C. Change the multi-cluster settings to add additional clusters.
• D. Enable the search optimization service for the underlying tables.

Correct answer: C

Explanation

Changing the multi-cluster settings to add additional clusters (option C) allows the virtual warehouse to handle more concurrent queries and improve performance. Increasing the size of the virtual warehouse (option A) may help but doesn't specifically address concurrency. Adding a cluster key (option B) and enabling the search optimization service (option D) focus on query efficiency rather than scaling to handle more simultaneous processes.