Snowflake
ADA-C01 · Question #58
A resource monitor named MONTHLY_FINANCE_LIMIT has been created and applied to two virtual warehouses (fin_wh1 and fin_wh2) using the following SQL: Given that the combined total of credits consumed…
The correct answer is E. ALTER RESOURCE MONITOR MONTHLY_FINANCE_LIMIT SET CREDIT_QUOTA = 1500; F. ALTER RESOURCE MONITOR MONTHLY_FINANCE_LIMIT RESET. See the full explanation below for the reasoning.
Question
A resource monitor named MONTHLY_FINANCE_LIMIT has been created and applied to two virtual warehouses (fin_wh1 and fin_wh2) using the following SQL:
Given that the combined total of credits consumed by fin_wh1 and fin_wh2 (including cloud services) has reached 800 credits and both warehouses are suspended, what should the ACCOUNTADMIN execute to allow both warehouses to be resumed? (Choose two.)
Exhibit
Options
- AALTER WAREHOUSE fin_wh1 RESUME;
- BALTER WAREHOUSE fin_wh2 RESUME;
- CALTER WAREHOUSE fin_wh1 UNSET RESOURCE_MONITOR MONTHLY_FINANCE_LIMIT;
- DALTER WAREHOUSE fin_wh2 UNSET RESOURCE_MONITOR MONTHLY_FINANCE_LIMIT;
- EALTER RESOURCE MONITOR MONTHLY_FINANCE_LIMIT SET CREDIT_QUOTA = 1500;
- FALTER RESOURCE MONITOR MONTHLY_FINANCE_LIMIT RESET;
- GALTER WAREHOUSE fin_wh1 UNSET RESOURCE_MONITORS;
How the community answered
(29 responses)- B7% (2)
- C7% (2)
- E83% (24)
- G3% (1)
Community Discussion
No community discussion yet for this question.