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

- Free Preparation Discussions

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?

AThe size of the warehouse will adjust automatically, improving query performance.

BThe warehouse will be dropped after a specified period of inactivity.

CThe warehouse will be stopped after a specified period of inactivity, reducing costs.

DThe warehouse costs will stabilize from month-to-month.

Show Suggested 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:

Submit Cancel

Delmy

23 hours ago

B is misleading; it just stops, not drops!

upvoted 0 times

...

Marcos

6 days ago

Wait, does it really stabilize costs? That sounds too good to be true.

upvoted 0 times

...

Arlette

11 days ago

Totally agree with C! Saves money for sure.

upvoted 0 times

...

Herman

2 months ago

I thought it would drop the warehouse entirely, not just stop it.

upvoted 0 times

...

Tyisha

2 months ago

C is correct! It stops after inactivity to save costs.

upvoted 0 times

...

Shanice

3 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

3 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

3 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

3 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

...