ADA-C01 Question 469
Single answerCreate resource monitorsA Snowflake administrator needs to prevent a non-production analytics warehouse from consuming more than 2,000 credits per month. The business wants users to receive a warning when 75% of the budget is reached, and for any currently running statements to finish but no new statements to start once 100% of the budget is consumed. Which configuration best meets these requirements?
- A
Create a resource monitor with a monthly frequency, set a trigger at 75 PERCENT DO NOTIFY, set a trigger at 100 PERCENT SUSPEND, and assign the monitor to the warehouse.
- B
Create a resource monitor with a monthly frequency, set a trigger at 75 PERCENT NOTIFY, set a trigger at 100 PERCENT SUSPEND_IMMEDIATE, and assign the monitor to the warehouse.
- C
Create a resource monitor with a monthly frequency and a credit quota of 2,000, set a trigger at 75 PERCENT NOTIFY, set a trigger at 100 PERCENT SUSPEND, and assign the monitor to the warehouse.
- D
Create a resource monitor with a monthly frequency and a credit quota of 2,000, set a trigger at 75 CREDITS NOTIFY, set a trigger at 100 CREDITS SUSPEND, and assign the monitor to the warehouse.
Show answer and explanation
Correct answer: C
Explanation
The best answer is to create a resource monitor with a 2,000-credit quota and monthly frequency, then define triggers at 75 PERCENT NOTIFY and 100 PERCENT SUSPEND before assigning it to the warehouse. In Snowflake, resource monitors control credit usage and can be set at the account or warehouse level. A monitor must include a credit quota, and trigger actions include NOTIFY, SUSPEND, and SUSPEND_IMMEDIATE. SUSPEND prevents new statements from starting after the threshold is reached but allows in-flight statements to complete, whereas SUSPEND_IMMEDIATE aborts running work. This question tests practical understanding of how to create resource monitors that align budget controls with business expectations, which is a common administrative task. See Snowflake documentation for CREATE RESOURCE MONITOR, ALTER RESOURCE MONITOR, and resource monitor trigger actions and frequencies.
- A. Incorrect.
Incorrect. A resource monitor must have a credit quota to enforce a spending limit. Also, the trigger action syntax is NOTIFY, not DO NOTIFY. Although SUSPEND would allow running statements to complete and prevent new statements, this option is invalid because it omits the required quota and uses incorrect trigger terminology.
- B. Incorrect.
Incorrect. This option includes a valid warning trigger at 75% using NOTIFY, but SUSPEND_IMMEDIATE does not meet the requirement that currently running statements should be allowed to finish. SUSPEND_IMMEDIATE aborts running statements and suspends the assigned warehouse as soon as the threshold is reached. It also omits the required 2,000-credit quota.
- C. Correct.
Correct. A resource monitor requires a credit quota, and a monthly frequency aligns with the monthly budget requirement. A 75 PERCENT NOTIFY trigger sends a warning when 75% of the 2,000-credit quota is reached. A 100 PERCENT SUSPEND trigger allows currently executing statements to finish while preventing the warehouse from starting new statements after the threshold is hit, which matches the business requirement.
- D. Incorrect.
Incorrect. The business requirement is based on a 2,000-credit monthly budget with a warning at 75% and suspension at 100%. Setting triggers at 75 credits and 100 credits would enforce thresholds far below the intended budget. This reflects a common mistake of confusing percentage-based thresholds with raw credit values. While resource monitor triggers can be defined in percentage terms relative to the quota, these values do not satisfy the scenario.