Discuss Snowflake SOL-C01 Exam Topic 4 Question 9

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.

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.

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

Get Premium SOL-C01 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

21 comments · newest first

Chantay 1 month ago

C makes the most sense for efficiency.

Willodean 1 month ago

D is not really true. Costs can still vary.

Taryn 2 months ago

A is misleading. Size doesn't change automatically.

Stephane 2 months ago

B sounds tempting, but dropping isn't ideal.

Kallie 2 months ago

Agreed! Stopping the warehouse cuts costs.

Cherri 2 months ago

I think C is the best answer. It saves money.

Lucy 2 months ago

C is clear. Inactivity means savings!

Gladys 2 months ago

D seems unlikely. Costs can fluctuate.

Kattie 3 months ago

A is misleading. Size doesn't change automatically.

Lovetta 3 months ago

B sounds tempting, but dropping it isn't ideal.

Mozell 3 months ago

Agreed! Stopping the warehouse cuts costs.

Joanna 3 months ago

I think C is the best choice. It saves money!

Delmy 3 months ago

B is misleading; it just stops, not drops!

Marcos 3 months ago

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

Arlette 4 months ago

Totally agree with C! Saves money for sure.

Herman 5 months ago

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

Tyisha 5 months ago

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

Shanice 6 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.

Aretha 6 months ago

I practiced a similar question, and I believe auto-suspend is definitely about stopping the warehouse to cut down on expenses.

Kati 6 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?

Tennie 6 months ago

I think enabling auto-suspend means the warehouse stops after a while of not being used, which should help save costs.

Snowflake SOL-C01 Exam - Topic 4 Question 9 Discussion