Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Question 250

What happens when a virtual warehouse is resized?

When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected.

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.

The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.

Users who are trying to use the warehouse will receive an error message until the resizing is complete.

Correct Answer: 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. This means that the warehouse will not be immediately suspended or cause errors for users, ensuring that ongoing queries can complete without interruption.

Discussion

halolOption: B

https://docs.snowflake.com/en/user-guide/warehouses-tasks.html#:~:text=Resizing%20a%20running%20warehouse%20adds,each%20cluster%20in%20the%20warehouse.

Kate0204Option: B

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.

MultiCloudIronManOption: B

Correct

Mallikharjuna452Option: B

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.

_yyuktaOption: B

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.

AfzyOption: D

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.

singhksOption: B

B is correct

NeediumOption: B

B is the answer