A Snowflake account administrator has set the resource monitors as shown in the diagram, with actions defined for each resource monitor as “Notify & Suspend Immediately”.
What is the MAXIMUM limit of credits that Warehouse 2 can consume?
A Snowflake account administrator has set the resource monitors as shown in the diagram, with actions defined for each resource monitor as “Notify & Suspend Immediately”.
What is the MAXIMUM limit of credits that Warehouse 2 can consume?
Warehouse 2 is controlled by Resource Monitor 1, which has a credit quota set for the entire account at 5000 credits. Since Warehouse 2 is part of the account and there are no specific limitations imposed directly on it other than the overall account limit, the maximum possible credits it can consume would be the entire account limit of 5000 credits. This is under the assumption that other warehouses do not consume any credits, allowing Warehouse 2 to potentially use the full quota.
Warehouse 2 is controlled by policy on the account level and all five warehouses usage count toward this limit. Having limit on another warehouses (in this example: 3, 4, 5) just means that warehouse 3, 4, 5 can be suspended earlier when reaching their limits. The question ask for the MAXIMUM, so the best case scenario for warehouse 2 is that other warehouses doesn't consume ANY resources and in such case warehouse 2 can burn whole 5000 limit. Eventually: answer D
D : warehouses 2 controlled by Resource Monitor 1 with credit quota for the entire account is 5000. the actual credits consumed by warehouses 2 may be less if the quota for the account is reached first.
Based on this diagram: The credit quota for the entire account is 5000 for the interval (month, week, etc.), as controlled by Resource Monitor 1; if this quota is reached within the interval, the actions defined for the resource monitor (Suspend, Suspend Immediate, etc. ) are enforced for all five warehouses. Warehouse 3 can consume a maximum of 1000 credits within the interval. Warehouse 4 and 5 can consume a maximum combined total of 2500 credits within the interval. Note that the actual credits consumed by Warehouses 3, 4, and 5 may be less than their quotas if the quota for the account is reached first.
D is correct ! if no other warehouse is running, the maximum limit is 5000
It's 5,000
B correct - 5000 - 1000 - 2500=1500 https://docs.snowflake.com/en/user-guide/resource-monitors