SOL-C01 · Question #71
SOL-C01 Question #71: Real Exam Question with Answer & Explanation
The correct answer is D: Option D. The correct syntax for creating a resource monitor with triggers is to use the 'TRIGGERS' clause with the 'DO' keyword followed by the action. 'SUSPEND_IMMEDIATELY ensures the warehouse stops immediately when the limit is reached, preventing further credit consumption. Other opti
Question
A Snowflake account administrator needs to configure a resource monitor to limit the credit consumption of a specific virtual warehouse named 'ANALYTICS WH'. The resource monitor should trigger a notification when the warehouse consumes 80% of its allocated credits within a calendar month and should suspend the warehouse when it reaches 100%. Which of the following SQL statements, executed in the correct order, would achieve this?
Options
- AOption A
- BOption B
- COption C
- DOption D
- EOption E
Explanation
The correct syntax for creating a resource monitor with triggers is to use the 'TRIGGERS' clause with the 'DO' keyword followed by the action. 'SUSPEND_IMMEDIATELY ensures the warehouse stops immediately when the limit is reached, preventing further credit consumption. Other options have incorrect syntax or trigger wrong action.
Topics
Community Discussion
No community discussion yet for this question.