What happens when a virtual warehouse is resized?
What happens when a virtual warehouse is resized?
When reducing the size of a warehouse, the compute resources are removed only when they are no longer being used to execute any current statements. This means that the warehouse will not be immediately suspended or cause errors for users, ensuring that ongoing queries can complete without interruption.
https://docs.snowflake.com/en/user-guide/warehouses-tasks.html#:~:text=Resizing%20a%20running%20warehouse%20adds,each%20cluster%20in%20the%20warehouse.
B. When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.
Correct
B. When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.
B. When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.
I think answer is D, Warehouse Restart: Depending on the resizing operation, Snowflake may need to restart the virtual warehouse. During this restart, the warehouse is temporarily unavailable for query processing.
B is correct
B is the answer