Snowflake
ADA-C01 · Question #12
ADA-C01 Question #12: Real Exam Question with Answer & Explanation
Sign in or unlock ADA-C01 to reveal the answer and full explanation for question #12. The question stem and answer options stay visible for context.
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
Unlock ADA-C01 to see the answer
You've previewed enough free ADA-C01 questions. Unlock ADA-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.