Answer: AUTO_SUSPEND = 0

The question asks for a warehouse configuration that eliminates execution lag for a steady, continuous workload. AUTO_SUSPEND = 0 (option B) is the correct choice because it prevents the warehouse from automatically suspending, ensuring it remains active and ready to execute queries without the lag associated with resuming from a suspended state. This is supported by the community discussion, where B has 88% consensus and comments highlight that restarting suspended warehouses creates lags, and Snowflake docs recommend AUTO_SUSPEND = 0 for continuous workloads. Other options are less suitable: AUTO_RESUME = FALSE (A) would prevent automatic resumption, increasing lag; STATEMENT_TIMEOUT_IN_SECONDS (C) controls query duration, not warehouse availability; and MIN/MAX_CLUSTER_COUNT (D) manages multi-cluster scaling, which does not directly address execution lag from suspension.

Author: LeetQuiz Editorial Team