Snowflake SnowPro Core Certification Exam COF-C02 Question # 50 Topic 6 Discussion

Snowflake SnowPro Core Certification Exam COF-C02 Question # 50 Topic 6 Discussion

COF-C02 Exam Topic 6 Question 50 Discussion:
Question #: 50
Topic #: 6

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.

COF-C02 Question 50

What action should be taken to address this situation?


A.

Increase the warehouse size from Medium to 2XL.


B.

Increase the value for the parameter MAX_CONCURRENCY_LEVEL.


C.

Configure the warehouse to a multi-cluster warehouse.


D.

Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.


Get Premium COF-C02 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.