Resource monitors for cost control in Snowflake - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ service_behavior

intermediate

How does a resource monitor behave when the credit usage threshold is reached?

In Snowflake, what happens when a resource monitor reaches its defined credit usage threshold?

A The monitor sends an alert and can optionally suspend warehouses if configured to do so.

B The monitor sends an alert and suspends all warehouses immediately.

C The monitor automatically increases the credit quota to avoid suspension.

D The monitor deletes all query history to free up credits.

💡 Hint

Think about whether the monitor acts automatically or requires configuration to suspend warehouses.

Resource monitors send alerts when thresholds are reached. Suspension of warehouses happens only if the monitor is configured to do so.

❓ Configuration

intermediate

Which SQL command creates a resource monitor with a monthly credit quota of 100 credits?

Select the correct Snowflake SQL command to create a resource monitor named monthly_monitor with a 100 credit monthly quota.

A CREATE RESOURCE MONITOR monthly_monitor WITH CREDIT_QUOTA = 100;

B CREATE RESOURCE MONITOR monthly_monitor WITH CREDIT_QUOTA = 100 TRIGGERS ON 100 PERCENT DO NOTIFY;

C CREATE RESOURCE MONITOR monthly_monitor SET CREDIT_QUOTA = 100 MONTHLY;

D CREATE RESOURCE MONITOR monthly_monitor CREDIT_QUOTA = 100 MONTHLY;

💡 Hint

Check the correct syntax for specifying credit quota and period.

The correct syntax uses WITH CREDIT_QUOTA = value TRIGGERS ON value PERCENT DO NOTIFY; to set quota and notification.

❓ Architecture

advanced

What is the best architecture to monitor and control costs across multiple Snowflake accounts?

You manage multiple Snowflake accounts for different teams. Which architecture allows centralized cost monitoring and control using resource monitors?

A Use a shared Snowflake account with resource monitors assigned to each team’s warehouses via tags.

B Create separate resource monitors in each account and manually aggregate reports externally.

C Create a single resource monitor in one account and link it to warehouses in other accounts.

D Disable resource monitors and rely on billing alerts from the cloud provider.

💡 Hint

Consider how Snowflake resource monitors can be assigned and how to centralize control.

Using a shared account with resource monitors assigned by warehouse tags allows centralized monitoring and control.

❓ security

advanced

Which role is required to create and manage resource monitors in Snowflake?

To securely manage resource monitors, which Snowflake role must a user have?

A SECURITYADMIN role

B SYSADMIN role

C PUBLIC role

D ACCOUNTADMIN role

💡 Hint

Think about which role has the highest privileges related to account-wide settings.

The ACCOUNTADMIN role has privileges to create and manage resource monitors.

✅ Best Practice

expert

How should you configure resource monitors to avoid unexpected warehouse suspensions during business hours?

Which approach best prevents resource monitors from suspending warehouses unexpectedly during critical business hours?

A Do not use resource monitors and manually track credit usage daily.

B Create multiple resource monitors with overlapping quotas and suspend warehouses immediately when thresholds are hit.

C Schedule resource monitors to suspend warehouses only outside business hours using Snowflake tasks and alerts.

D Set a high credit quota and disable automatic suspension, relying only on alerts.

💡 Hint

Consider how to combine scheduling and monitoring to protect business operations.

Scheduling suspensions outside business hours using tasks and alerts allows cost control without disrupting critical workloads.