Exam SOL-C01 Topic 1 Question 180 Discussion

Actual exam question for Snowflake's SOL-C01 exam
Question #: 180
Topic #: 1
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?

Suggested Answer: D Vote an answer

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.

by Werner at Jan 14, 2026, 07:15 PM

Limited Time Offer

15%

Off

Get Premium SOL-C01 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10