Snowflake
ADA-C01 · Question #12
An Administrator has a warehouse which is intended to have a credit quota set for 3000 for each calendar year. The Administrator needs to create a resource monitor that will perform the following…
The correct answer is B. create or replace resource monitor RM1 with credit_quota=3000 frequency = yearly. Option B is the correct SQL command to create a resource monitor that meets the requirements. It sets the credit quota to 3000, the frequency to yearly, the start timestamp to January 1, 2022, and the triggers to notify and suspend the warehouse at the specified thresholds.
Resource Management and Cost Optimization
Question
An Administrator has a warehouse which is intended to have a credit quota set for 3000 for each calendar year. The Administrator needs to create a resource monitor that will perform the following tasks: 1. At 80% usage notify the account Administrators. 2. At 100% usage suspend the warehouse and notify the account Administrators. 3. At 120% stop all running executions, suspend the warehouse, and notify the account Administrators. Which SQL command will meet these requirements?
Options
- Acreate or replace resource monitor RM1 with credit_quota=3000 start_timestamp = '2022-01-01
- Bcreate or replace resource monitor RM1 with credit_quota=3000 frequency = yearly
- Ccreate or replace resource monitor RM1 with credit_quota=3000 start_timestamp = '2022-01-01
- Dcreate or replace resource monitor RM1 with credit_quota=3000 frequency = yearly
How the community answered
(38 responses)- A11% (4)
- B71% (27)
- C16% (6)
- D3% (1)
Explanation
Option B is the correct SQL command to create a resource monitor that meets the requirements. It sets the credit quota to 3000, the frequency to yearly, the start timestamp to January 1, 2022, and the triggers to notify and suspend the warehouse at the specified thresholds.
Topics
#resource monitor#credit quota#trigger configuration#warehouse suspension
Community Discussion
No community discussion yet for this question.