SOL-C01 Question #151: Real Exam Question with Answer & Explanation

Question

You have a Snowflake virtual warehouse named 'REPORTING that is consistently experiencing performance issues during peak hours. You suspect that resource contention is the primary cause. Which of the following actions, when performed together , would be the MOST effective in mitigating these performance issues and ensuring consistent query performance for reporting?

Options

• AIncrease the size of from Small to Medium and enable auto-suspend after 5 minutes of inactivity.
• BEnable multi-cluster warehouse for 'REPORTING with a minimum of 2 clusters and a maximum of
• CEnable multi-cluster warehouse for with a minimum of 2 clusters and a maximum of 4 clusters. Set
• DEnable auto-suspend after 5 minutes of inactivity and implement query tagging to identify long-
• EMonitor warehouse load using Snowsight and manually increase the warehouse size when

Explanation

Option C is the most effective solution. Enabling a multi-cluster warehouse allows Snowflake to automatically scale out by adding more compute resources when the load increases. Setting the scaling policy to 'Standard' prioritizes performance over cost, ensuring that new clusters are started quickly when needed. Increasing the warehouse size to 'Large' provides more resources to each individual cluster. Option A only increases the warehouse size but doesn't address concurrency. Option B uses the 'Economy' scaling policy, which might delay the creation of new clusters, thus not solving the performance issue. Option D only addresses inactivity and identifies long-running queries but doesn't resolve the resource contention. Option E relies on manual intervention, which is not ideal for consistently addressing peak hour performance issues.

No community discussion yet for this question.