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

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

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

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

A company has many users assigned to the ANALYST role who regularly query Snowflake through a reporting tool. The Administrator observes that the ANALYST users continuously keep two small clusters busy and occasionally require three or four clusters of that same size.

B. ased on this scenario, how should the Administrator configure a virtual warehouse to MOST efficiently support this user group?


A.

Create a multi-cluster warehouse with MIN_CLUSTERS set to 1. Give MANAGE privileges to the ANALYST role so this group can start and stop the warehouse, and increase the number of clusters as needed.


B.

Create a multi-cluster warehouse with MIN_CLUSTERS set to 2. Set the warehouse to auto-resume and auto-suspend, and give USAGE privileges to the ANALYST role. Allow the warehouse to auto-scale.


C.

Create a standard X-Large warehouse, which is equivalent to four small clusters. Set the warehouse to auto-resume and auto-suspend, and give USAGE privileges to the ANALYST role.


D.

Create four virtual warehouses (sized Small through XL) and set them to auto-suspend and auto-resume. Have users in the ANALYST role select the appropriate warehouse based on how many queries are being run.


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.