SnowPro Advanced Administrator ADA-C02

By Snowflake · Question Mode

QuestionQ30

Manage and maintain database objects and virtual warehouses

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

  1. Between 50 and 100 concurrent users will run reports.
  2. Costs must be minimized according to the number of users active at a particular time.
  3. The virtual warehouse must automatically suspend and resume based on user activity.

Which configuration meets these requirements?

Explanation

A multi-cluster warehouse with MAX_CLUSTER_COUNT = 10 can add clusters as concurrent reporting demand grows, while its default MIN_CLUSTER_COUNT of 1 allows it to use fewer clusters when demand is lower. AUTO_SUSPEND = 600 suspends the warehouse after 600 seconds of inactivity, and AUTO_RESUME = true restarts it when work is submitted. Snowflake documents that a warehouse runs in auto-scale mode when the minimum cluster count is lower than the maximum, and that AUTO_SUSPEND and AUTO_RESUME control these activity-based behaviors.

Learn more

Community Discussion

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