Snowflake
COF-R02 · Question #199
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…
The correct answer is B. Increase the value for the parameter MAX_CONCURRENCY_LEVEL. See the full explanation below for the reasoning.
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.
How the community answered
(24 responses)- A4% (1)
- B75% (18)
- C13% (3)
- D8% (2)
Community Discussion
No community discussion yet for this question.