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?
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.
To answer the question the maximum credit assigned to WAREHOUSE 2 is 5000-2500-1000=1500.
B is correct answer.
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.
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.
B correct - 5000 - 1000 - 2500=1500
https://docs.snowflake.com/en/user-guide/resource-monitors
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Shipra123
1 week, 2 days agoLematthew31
6 months, 3 weeks agoSSahar
8 months, 2 weeks agogizzamo
10 months, 3 weeks agoIsio05
1 year agokayuhanbiduk
1 year, 1 month agoHeetec
1 year, 1 month ago