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

Tennie

3 days 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

...