SOL-C01 · Question #151
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
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #151. The question stem and answer options stay visible for context.
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
Unlock SOL-C01 to see the answer
You've previewed enough free SOL-C01 questions. Unlock SOL-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.