SnowPro Advanced Architect

By Snowflake · Question Mode

QuestionQ29

Performance, Cost, and Resource Optimization

A Snowflake account has three warehouses with the following monitoring configured for the next 30 days:

  1. Warehouse1 has resource_monitor1 configured with a credit quota of 2000.
  2. Warehouse2 has resource_monitor2 configured with a credit quota of 3000.
  3. Warehouse3 has resource_monitor3 configured with a credit quota of 1000.

At the account level, resource_monitor4 is configured with a quota of 5000 for the next 30 days.

What happens when Warehouse1 is at 1000, Warehouse2 is at 3000, and Warehouse3 is at 1000?

Explanation

An account-level resource monitor tracks credit usage across all warehouses it controls. At 1000 + 3000 + 1000 credits, account usage reaches the 5000-credit quota. When its suspend trigger is reached, the account-level monitor enforces the suspension action for every warehouse in the account, including Warehouse1 even though its individual 2000-credit quota has not been reached. Warehouse2 and Warehouse3 have also reached their own warehouse-level quotas.

Learn more

Community Discussion

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