Question

A BI team complains that their scheduled morning dashboard refresh sometimes fails with an error indicating the warehouse is not running. The warehouse was configured with AUTO_SUSPEND set to 300 seconds but had AUTO_RESUME disabled by a previous administrator to control costs. The team does not want to manually start the warehouse each morning, but they still want it to shut down when idle. Which single configuration change best resolves the issue?

Accepted Answer

Enable AUTO_RESUME on the warehouse so it automatically starts when a query is submitted.

Answer

Increase AUTO_SUSPEND to a larger value so the warehouse never fully suspends overnight.

Answer

Scale the warehouse up to a larger size so it can handle the morning refresh queue.

Answer

Convert the warehouse to a multi-cluster warehouse with a minimum of two clusters.