Black Friday Reward - Upto 75% off - Ends in 0d 00h 00m 00s - Coupon code: CFsave75

Snowflake SnowPro Advanced: Administrator ADA-C02 Question # 2 Topic 1 Discussion

Snowflake SnowPro Advanced: Administrator ADA-C02 Question # 2 Topic 1 Discussion

ADA-C02 Exam Topic 1 Question 2 Discussion:
Question #: 2
Topic #: 1

An Administrator must configure a Snowflake virtual warehouse for a new use case with these details:

B. etween 50 and 100 concurrent users will run reports.

C. osts must be minimized according to the number of users active at a particular time.

The virtual warehouse must automatically suspend and resume based on user activity.

Which configuration meets these requirements?


A.

CREATE OR REPLACE WAREHOUSE reporting_wh

WAREHOUSE_SIZE = MEDIUM

AUTO_SUSPEND = 600

AUTO_RESUME = TRUE;


B.

CREATE OR REPLACE WAREHOUSE reporting_wh

WAREHOUSE_SIZE = XXXLARGE

MAX_CLUSTER_COUNT = 10

SCALING_POLICY = STANDARD

AUTO_SUSPEND = 600

AUTO_RESUME = FALSE;


C.

CREATE OR REPLACE WAREHOUSE reporting_wh

WAREHOUSE_SIZE = XXXLARGE

AUTO_SUSPEND = 60

AUTO_RESUME = TRUE;


D.

CREATE OR REPLACE WAREHOUSE reporting_wh

WAREHOUSE_SIZE = MEDIUM

MAX_CLUSTER_COUNT = 10

SCALING_POLICY = STANDARD

AUTO_SUSPEND = 600

AUTO_RESUME = TRUE;


Get Premium ADA-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.