For a multi-cluster warehouse, auto-resume only applies when the entire warehouse is suspended (i.e., no clusters are running).

• A. Auto-resume applies only when at least one cluster is running
• B. Auto-resume applies during maintenance
• C. Auto-resume applies automatically when any activity is detected
• D. Auto-resume applies only when the entire warehouse is suspended (correct)

Answer: (D)

Auto-resume wakes a warehouse only from a fully suspended state. In a multi-cluster setup, if any cluster is running, the warehouse is active and there’s compute available, so nothing needs to resume. Auto-resume kicks in when all clusters are suspended and a new workload arrives, prompting Snowflake to start clusters to handle the query. It isn’t triggered just because maintenance is happening or because some activity is detected while there are still active clusters. That’s why the statement that auto-resume applies only when the entire warehouse is suspended is the correct description.