Snowflake SnowPro Advanced: Administrator ADA-C01 Question # 15 Topic 2 Discussion

❗Scenario:

Resource Monitor MONTHLY_FINANCE_LIMIT has acredit quota of 1000.

800 credits have been used and warehouses arealready suspended.

According to monitor configuration:

At80%, warehouses aresuspended.

At100%, warehouses would besuspended immediately.

Warehouses cannot resume untilthe monitor is reset or the quota is increased.

✅E. SET CREDIT_QUOTA = 1500

Increases themonthly credit limitto 1500.

Since current usage is 800 < 1500, this puts usage below 80%.

This allowsresumption of warehouses.

✅F. RESET

sql

CopyEdit

ALTER RESOURCE MONITOR MONTHLY_FINANCE_LIMIT RESET;

Resets usage to zerofor the current period.

Allows warehouses to resume immediately — same effect as a fresh cycle.

❌Why Other Options Are Incorrect:

A. / B. ALTER WAREHOUSE ... RESUME

Won’t work while the resource monitor is actively suspending the warehouses due to limits.

C. / D. UNSET RESOURCE_MONITOR

Youcan’t remove a resource monitorfrom a warehouse while it iscurrently suspendedby that same monitor.

You must firstreset or adjust the monitor.

G. UNSET RESOURCE_MONITORS

Invalid syntax — there’s no RESOURCE_MONITORS plural keyword.

????SnowPro Administrator References:

Resource Monitors Overview

ALTER RESOURCE MONITOR

Best Practices for Controlling Warehouse Credit Usage