Snowpro Advanced Architect · Free Practice Question Medium
Question 13
- A Resource Monitor
- B SYSTEM$GET_EMAIL_NOTIFICATIONS_HISTORY
- C QUERY_HISTORY view
- D ALERT (SQL command)
- E EVENT_TABLE
Reveal correct answer
Correct answer: A
Explanation
✅ Resource Monitor
Explanation:
Snowflake's Resource Monitor is specifically designed to track credit consumption for virtual warehouses and trigger automated alerts when predefined thresholds are exceeded. It allows administrators to set credit limits, monitor usage, and even suspend warehouses to prevent excessive costs.
❌ Why the other options are incorrect?
ALERT (SQL command) → Incorrect, because Snowflake does not have a built-in ALERT SQL command for monitoring warehouse credit usage.
SYSTEM$GET_EMAIL_NOTIFICATIONS_HISTORY → Incorrect, as this function retrieves historical email notifications, but does not actively monitor or trigger alerts for credit consumption.
EVENT_TABLE → Incorrect, because EVENT_TABLE is used for tracking Snowflake events, but does not provide automated credit monitoring.
QUERY_HISTORY view → Incorrect, since QUERY_HISTORY logs query execution details but does not track warehouse credit consumption or trigger alerts.
For more details on Resource Monitors, you can check the official Snowflake documentation.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
