SnowPro Advanced Administrator ADA-C02

By Snowflake · Question Mode

QuestionQ37

Manage and maintain database objects and virtual warehouses

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.

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

Explanation

A multi-cluster warehouse is designed to increase query concurrency. Setting its minimum cluster count to 2 maintains the observed steady-state capacity, while auto-scale can start additional same-sized clusters for the occasional demand of three or four and stop excess capacity as load declines. Auto-suspend and auto-resume prevent idle consumption, and the USAGE privilege allows the ANALYST role to use the warehouse without granting warehouse-management authority.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!