A data platform team creates two multi-cluster virtual warehouses with the AUTO_SUSPEND value set to NULL on one. and '0' on the other. What would be the execution behavior of these virtual…

Question

Options

• ASetting a '0' or NULL value means the warehouses will never suspend.
• BSetting a '0' or NULL value means the warehouses will suspend immediately.
• CSetting a '0' or NULL value means the warehouses will suspend after the default of 600 seconds.
• DSetting a '0' value means the warehouses will suspend immediately, and NULL means the

• A
  8% (3)
• B
  3% (1)
• C
  3% (1)
• D
  86% (32)

Explanation

The AUTO_SUSPEND parameter controls the amount of time, in seconds, of inactivity after which a warehouse is automatically suspended. If the parameter is set to NULL, the warehouse never suspends. If the parameter is set to '0', the warehouse suspends immediately after executing a query. Therefore, the execution behavior of the two virtual warehouses will be different depending on the AUTO_SUSPEND value. The warehouse with NULL value will keep running until it is manually suspended or the resource monitor limits are reached. The warehouse with '0' value will suspend as soon as it finishes a query and release the compute resources.

No community discussion yet for this question.