Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Snowflake COF-R02 Exam - Topic 1 Question 74 Discussion

A virtual warehouse is created using the following command:Create warehouse my_WH withwarehouse_size = MEDIUMmin_cluster_count = 1max_cluster_count = 1auto_suspend = 60auto_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?
B) Increase the value for the parameter MAX_CONCURRENCY_LEVEL.
A) Increase the warehouse size from Medium to 2XL.
C) Configure the warehouse to a multi-cluster warehouse.
D) Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.

Snowflake COF-R02 Exam - Topic 1 Question 74 Discussion

Actual exam question for Snowflake's COF-R02 exam
Question #: 74
Topic #: 1
[All COF-R02 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: B

by Scarlet at Jul 19, 2026, 06:56 PM

Limited Time Offer

25%

Off

Get Premium COF-R02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Melvin
3 days ago
I thought MEDIUM was already enough for most cases!
upvoted 0 times
...
Joana
8 days ago
Increasing the warehouse size could be overkill, though.
upvoted 0 times
...
Audria
14 days ago
Wait, why would we lower the timeout? That seems risky.
upvoted 0 times
...
Erinn
19 days ago
Definitely agree with C, multi-cluster can help a lot!
upvoted 0 times
...
Kanisha
24 days ago
I think option C is the best choice here.
upvoted 0 times
...
Cassie
29 days ago
Lowering the STATEMENT_QUEUED_TIMEOUT_IN_SECONDS could help, but I feel like that might just be a temporary fix.
upvoted 0 times
...
Amalia
1 month ago
Increasing the warehouse size seems like a straightforward option, but I wonder if it’s really necessary in this case.
upvoted 0 times
...
Oren
1 month ago
I remember practicing a question about adjusting concurrency levels, but I can't recall if that was the right approach here.
upvoted 0 times
...
Mertie
1 month ago
I think we might need to configure the warehouse to a multi-cluster setup if the utilization is high, but I'm not entirely sure.
upvoted 0 times
...

Save Cancel