exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 879 discussion

Actual exam question from Snowflake's SnowPro Core
Question #: 879
Topic #: 1
[All SnowPro Core Questions]

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. 0
  • B. 1500
  • C. 3500
  • D. 5000
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Shipra123
1 month, 2 weeks ago
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.
upvoted 1 times
...
Lematthew31
7 months, 3 weeks ago
Selected Answer: D
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.
upvoted 1 times
...
SSahar
9 months, 3 weeks ago
Selected Answer: D
D is correct ! if no other warehouse is running, the maximum limit is 5000
upvoted 1 times
...
gizzamo
12 months ago
Selected Answer: D
It's 5,000
upvoted 1 times
...
Isio05
1 year, 1 month ago
Selected Answer: D
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
upvoted 3 times
...
kayuhanbiduk
1 year, 2 months ago
Selected 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.
upvoted 2 times
...
Heetec
1 year, 2 months ago
B correct - 5000 - 1000 - 2500=1500 https://docs.snowflake.com/en/user-guide/resource-monitors
upvoted 1 times
...
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.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago