Answer-first summary for fast verification
Answer: Suspend a virtual warehouse when its credit usage reaches a defined limit., Trigger a notification to account administrators when credit usage reaches a specified threshold.
Resource monitors in Snowflake are designed to track and manage credit usage across virtual warehouses, cloud services, and the account overall. Option D (suspend a virtual warehouse when credit usage reaches a defined limit) is a core function that prevents unexpected costs by stopping warehouse operations. Option E (trigger a notification to account administrators when credit usage reaches a specified threshold) enables proactive monitoring and alerts for cost management. Options A, B, and C are incorrect: A is handled by query profiling tools, not resource monitors; B is managed automatically by Snowflake's storage layer; C involves query modification, which is unrelated to resource monitoring. The community discussion confirms D and E as the correct answers with 100% consensus.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which actions can be performed using a resource monitor in Snowflake? (Choose two.)
A
Monitor the performance of individual queries in real-time.
B
Automatically allocate more storage space to a virtual warehouse.
C
Modify the queries being executed within a virtual warehouse.
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.
No comments yet.