SnowPro Core Certification — Question 818

What strategies can be used to optimize the performance of a virtual warehouse? (Choose two.)

Answer options

• A. Reduce queuing.
• B. Allow memory spillage.
• C. Increase the MAX_CONCURRENCY_LEVEL parameter.
• D. Increase the warehouse size.
• E. Suspend the warehouse frequently.

Correct answer: A, D

Explanation

Reducing queuing helps to streamline processes and improve performance by minimizing delays in task execution. Increasing the warehouse size also allows for more resources to be utilized, which can enhance performance. Conversely, allowing memory spillage and suspending the warehouse frequently would lead to inefficiencies and degraded performance.