Snowflake ADA-C01 Exam - Topic 8 Question 40 Discussion

Actual exam question for Snowflake's ADA-C01 exam

Question #: 40
Topic #: 8

A resource monitor named MONTHLY_FINANCE_LIMIT has been created and applied to two virtual warehouses (fin_wh1 and fin_wh2) using the following SQL:

Given that the combined total of credits consumed by fin_wh1 and fin_wh2 (including cloud services) has reached 800 credits and both warehouses are suspended, what should the ACCOUNTADMIN execute to allow both warehouses to be resumed? (Select TWO).

AALTER WAREHOUSE fin_wh1 RESUME;

BALTER WAREHOUSE fin_wh2 RESUME;

CALTER WAREHOUSE fin_wh1 UNSET RESOURCE_MONITOR MONTHLY_FINANCE_LIMIT;

DALTER WAREHOUSE fin_wh2 UNSET RESOURCE_MONITOR MONTHLY_FINANCE_LIMIT;

EALTER RESOURCE MONITOR MONTHLY_FINANCE_LIMIT SET CREDIT_QUOTA = 1500;

FALTER RESOURCE MONITOR MONTHLY_FINANCE_LIMIT RESET;

GALTER WAREHOUSE fin_wh1 UNSET RESOURCE_MONITORS;

Show Suggested Answer

Suggested Answer: E, F

Scenario:

Resource Monitor MONTHLY_FINANCE_LIMIT has a credit quota of 1000.

800 credits have been used and warehouses are already suspended.

According to monitor configuration:

At 80%, warehouses are suspended.

At 100%, warehouses would be suspended immediately.

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

E. SET CREDIT_QUOTA = 1500

Increases the monthly credit limit to 1500.

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

This allows resumption of warehouses.

F. RESET

sql

CopyEdit

ALTER RESOURCE MONITOR MONTHLY_FINANCE_LIMIT RESET;

Resets usage to zero for 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

You can't remove a resource monitor from a warehouse while it is currently suspended by that same monitor.

You must first reset or adjust the monitor.

G . UNSET RESOURCE_MONITORS

Invalid syntax --- there's no RESOURCE_MONITORS plural keyword.

SnowPro Administrator Reference:

Resource Monitors Overview

ALTER RESOURCE MONITOR

Best Practices for Controlling Warehouse Credit Usage

by Clay at Jul 14, 2025, 10:39 AM

Limited Time Offer

25%

Off

Get Premium ADA-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Laurel

5 months ago

I thought you couldn't resume if the limit was hit.

upvoted 0 times

...

Johnna

5 months ago

E is also a good choice, increasing the credit quota makes sense.

upvoted 0 times

...

Oretha

6 months ago

Wait, can you really just reset the monitor? Sounds risky.

upvoted 0 times

...

Elli

6 months ago

You need to unset the resource monitor to resume the warehouses.

upvoted 0 times

...

Natalya

6 months ago

Totally agree, option C is a must!

upvoted 0 times

...

Hubert

6 months ago

I think option E might be the right choice to increase the credit quota, but I can't recall if we need to unset the monitor too.

upvoted 0 times

...

Rikki

6 months ago

I feel like just resuming the warehouses won't work since they hit the limit. We definitely need to modify the resource monitor somehow.

upvoted 0 times

...

Monte

7 months ago

I remember a similar question where we had to adjust the credit quota. Maybe we should set it higher to allow both warehouses to resume?

upvoted 0 times

...

Alison

7 months ago

I think we need to unset the resource monitor for at least one of the warehouses to resume them, but I'm not sure if it's fin_wh1 or fin_wh2.

upvoted 0 times

...

Naomi

7 months ago

I'm not entirely sure about this one. I'll need to double-check the details and make sure I'm selecting the correct actions to resume the warehouses.

upvoted 0 times

...

Scot

7 months ago

This seems straightforward. The warehouses are suspended due to the credit limit, so we need to either remove the resource monitor or increase the quota to get them back up and running.

upvoted 0 times

...

Margret

7 months ago

Okay, I think I've got this. The key is to either remove the resource monitor from the warehouses or increase the credit quota to allow them to resume. I'll select the two most appropriate options.

upvoted 0 times

...

Alton

8 months ago

Hmm, I'm a bit confused about the resource monitor and how it's applied to the warehouses. I'll need to review the details to make sure I understand the right approach.

upvoted 0 times

...