Snowflake
COF-R02 · Question #199
COF-R02 Question #199: Real Exam Question with Answer & Explanation
Sign in or unlock COF-R02 to reveal the answer and full explanation for question #199. The question stem and answer options stay visible for context.
Question
A virtual warehouse is created using the following command: Create warehouse my_WH with warehouse_size = MEDIUM min_cluster_count = 1 max_cluster_count = 1 auto_suspend = 60 auto_resume = true; The image below is a graphical representation of the warehouse utilization across two days. What action should be taken to address this situation?
Exhibit
Options
- AIncrease the warehouse size from Medium to 2XL.
- BIncrease the value for the parameter MAX_CONCURRENCY_LEVEL.
- CConfigure the warehouse to a multi-cluster warehouse.
- DLower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.
Unlock COF-R02 to see the answer
You've previewed enough free COF-R02 questions. Unlock COF-R02 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.