Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Snowflake SOL-C01 Exam - Topic 4 Question 9 Discussion

What is the impact of enabling auto-suspend on a Snowflake virtual warehouse?
C) The warehouse will be stopped after a specified period of inactivity, reducing costs.
A) The size of the warehouse will adjust automatically, improving query performance.
B) The warehouse will be dropped after a specified period of inactivity.
D) The warehouse costs will stabilize from month-to-month.

Snowflake SOL-C01 Exam - Topic 4 Question 9 Discussion

Actual exam question for Snowflake's SOL-C01 exam
Question #: 9
Topic #: 4
[All SOL-C01 Questions]

What is the impact of enabling auto-suspend on a Snowflake virtual warehouse?

Show Suggested Answer Hide Answer
Suggested Answer: C

When auto-suspend is enabled on a virtual warehouse, Snowflake automatically suspends (stops) the warehouse after it has been idle for the configured period of time. Once suspended, the warehouse stops consuming compute credits, thereby reducing costs, since Snowflake bills only for active compute usage. When new queries arrive, auto-resume (if enabled) restarts the warehouse automatically.

Auto-suspend does not change the warehouse size; scaling up or down is a separate configuration. The warehouse is not dropped---its metadata and settings remain intact. Costs may be reduced and made more efficient but are not guaranteed to ''stabilize month-to-month,'' as the bill still depends on actual usage and workload patterns.

==================


by Tom at Apr 09, 2026, 04:53 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Taryn
1 day ago
A is misleading. Size doesn't change automatically.
upvoted 0 times
...
Stephane
6 days ago
B sounds tempting, but dropping isn't ideal.
upvoted 0 times
...
Kallie
11 days ago
Agreed! Stopping the warehouse cuts costs.
upvoted 0 times
...
Cherri
17 days ago
I think C is the best answer. It saves money.
upvoted 0 times
...
Lucy
22 days ago
C is clear. Inactivity means savings!
upvoted 0 times
...
Gladys
27 days ago
D seems unlikely. Costs can fluctuate.
upvoted 0 times
...
Kattie
1 month ago
A is misleading. Size doesn't change automatically.
upvoted 0 times
...
Lovetta
1 month ago
B sounds tempting, but dropping it isn't ideal.
upvoted 0 times
...
Mozell
1 month ago
Agreed! Stopping the warehouse cuts costs.
upvoted 0 times
...
Joanna
2 months ago
I think C is the best choice. It saves money!
upvoted 0 times
...
Delmy
2 months ago
B is misleading; it just stops, not drops!
upvoted 0 times
...
Marcos
2 months ago
Wait, does it really stabilize costs? That sounds too good to be true.
upvoted 0 times
...
Arlette
2 months ago
Totally agree with C! Saves money for sure.
upvoted 0 times
...
Herman
4 months ago
I thought it would drop the warehouse entirely, not just stop it.
upvoted 0 times
...
Tyisha
4 months ago
C is correct! It stops after inactivity to save costs.
upvoted 0 times
...
Shanice
4 months ago
I thought auto-suspend was more about adjusting the size of the warehouse. But now I'm confused if that's the right feature.
upvoted 0 times
...
Aretha
4 months ago
I practiced a similar question, and I believe auto-suspend is definitely about stopping the warehouse to cut down on expenses.
upvoted 0 times
...
Kati
5 months ago
I'm not entirely sure, but I remember something about warehouses being dropped if they're inactive for too long. Is that related?
upvoted 0 times
...
Tennie
5 months ago
I think enabling auto-suspend means the warehouse stops after a while of not being used, which should help save costs.
upvoted 0 times
...

Save Cancel