COF-C02 · Question #622
Which actions can be performed using a resource monitor in Snowflake? (Select TWO).
The correct answer is D. Suspend a virtual warehouse when its credit usage reaches a defined limit. E. Trigger a notification to account administrators when credit usage reaches a specified threshold. Resource monitors in Snowflake track credit consumption by virtual warehouses and can take two types of automated actions when a credit threshold is reached: (D) suspend the virtual warehouse to stop further credit usage, and (E) send email notifications to account…
Question
Which actions can be performed using a resource monitor in Snowflake? (Select TWO).
Options
- AMonitor the performance of individual queries in real-time
- BAutomatically allocate more storage space to a virtual warehouse
- CModify the queries being executed within a virtual warehouse.
- DSuspend a virtual warehouse when its credit usage reaches a defined limit.
- ETrigger a notification to account administrators when credit usage reaches a specified threshold
How the community answered
(25 responses)- B4% (1)
- C4% (1)
- D92% (23)
Explanation
Resource monitors in Snowflake track credit consumption by virtual warehouses and can take two types of automated actions when a credit threshold is reached: (D) suspend the virtual warehouse to stop further credit usage, and (E) send email notifications to account administrators as an alert. Resource monitors do not have the ability to inspect individual query performance in real time, allocate additional storage, or modify the SQL of executing queries. They are purely a cost-control and alerting mechanism tied to credit thresholds.
Topics
Community Discussion
No community discussion yet for this question.