ADA-C01 Question 356
Single answer4.3 Given a scenario, implement resource monitors.A Snowflake administrator needs to control monthly warehouse credit consumption for a finance reporting environment. The requirement is to notify administrators when usage reaches 75% of the monthly budget, suspend only the warehouse that exceeds its limit at 100%, and ensure the budget resets automatically at the start of each month. Which implementation best meets these requirements?
- A
Create a resource monitor with a monthly frequency, set a 75% NOTIFY trigger and a 100% SUSPEND trigger, and assign the monitor to the specific warehouse.
- B
Create a resource monitor at the account level with a monthly frequency, set a 75% NOTIFY trigger and a 100% SUSPEND_IMMEDIATE trigger, and do not assign it to any warehouse.
- C
Create a warehouse quota using ALTER WAREHOUSE, set a monthly credit limit, and configure an alert at 75% usage.
- D
Create a resource monitor with no frequency, set a 75% NOTIFY trigger and a 100% SUSPEND trigger, and manually reset the used credits each month.
Show answer and explanation
Correct answer: A
Explanation
The best solution is to use a warehouse-level resource monitor configured with a monthly frequency and appropriate triggers. In Snowflake, resource monitors are designed to track credit usage and can take actions at specified percentage thresholds. Common actions include NOTIFY, SUSPEND, and SUSPEND_IMMEDIATE. For this scenario, assigning the monitor directly to the finance reporting warehouse ensures the control is scoped correctly. Setting FREQUENCY = MONTHLY provides automatic reset each month, which aligns with a recurring budget. According to Snowflake best practices, resource monitors are the correct administrative control for enforcing warehouse consumption limits and budget notifications. Account-level monitors are broader in scope and are not appropriate when the requirement is to affect only a particular warehouse.
- A. Correct.
Correct. A resource monitor can be assigned to a specific warehouse, which allows credit usage controls to apply only to that warehouse rather than the entire account. Setting a monthly frequency causes the monitor to reset automatically each month. A 75% NOTIFY trigger meets the warning requirement, and a 100% SUSPEND trigger suspends the warehouse when the threshold is reached. This is the standard Snowflake mechanism for warehouse credit governance.
- B. Incorrect.
Incorrect. An account-level resource monitor applies to all warehouses in the account that are not explicitly assigned to another monitor, so it does not meet the requirement to suspend only the warehouse that exceeds its limit in the finance environment. In addition, SUSPEND_IMMEDIATE stops running queries immediately, which is more disruptive than required. The scenario asks to suspend only the warehouse at 100%, not necessarily terminate in-progress work instantly across the account.
- C. Incorrect.
Incorrect. Snowflake does not provide warehouse credit quotas through ALTER WAREHOUSE in the way described here. Resource monitors are the native feature used to track and control credit consumption with thresholds and actions such as NOTIFY, SUSPEND, and SUSPEND_IMMEDIATE. This option reflects a common misconception that warehouses have built-in standalone budget properties.
- D. Incorrect.
Incorrect. A resource monitor without a frequency does not automatically reset on a monthly schedule, so it would not satisfy the requirement for automatic monthly budget reset. While manual reset is possible, it adds operational overhead and contradicts the requirement. The monitor should use a monthly frequency to align with the budget cycle.