SnowPro Advanced: Architect — Question 48

A company’s daily Snowflake workload consists of a huge number of concurrent queries triggered between 9pm and 11pm. At the individual level, these queries are smaller statements that get completed within a short time period.
What configuration can the company’s Architect implement to enhance the performance of this workload? (Choose two.)

Answer options

• A. Enable a multi-clustered virtual warehouse in maximized mode during the workload duration.
• B. Set the MAX_CONCURRENCY_LEVEL to a higher value than its default value of 8 at the virtual warehouse level.
• C. Increase the size of the virtual warehouse to size X-Large.
• D. Reduce the amount of data that is being processed through this workload.
• E. Set the connection timeout to a higher value than its default.

Correct answer: A, B

Explanation

Enabling a multi-clustered virtual warehouse in maximized mode allows Snowflake to scale out resources dynamically to handle a high volume of concurrent queries. Adjusting the MAX_CONCURRENCY_LEVEL increases the number of queries that can run simultaneously. Increasing the virtual warehouse size may help but is less efficient than the other options, while reducing data processed may not address concurrency issues directly.