Exam SnowPro Core All QuestionsBrowse all questions from this exam
Question 99

True or False: You can resize a Virtual Warehouse while queries are running.

    Correct Answer: A

    In Snowflake, you can indeed resize a Virtual Warehouse while queries are running. The resize operation can be done at any time and does not require stopping or pausing the running queries. Existing queries will continue to use the resources that were allocated before the resize operation, and new queries will benefit from the updated resources.

Discussion
jtm22Option: A

A warehouse can be resized up or down at any time, including while it is running and processing statements.

learnazureportal

Answer is correct

Mayuri917233Option: A

A is correct

Mallikharjuna452Option: A

A Is correct

ka2456Option: B

False. You cannot resize a Virtual Warehouse in Snowflake while queries are running. You must first pause or terminate any running queries before resizing the Virtual Warehouse.

SalihAlic

Not correct, you can resize Warehouse anytime, it just won't use new resources for the already running queries.

Hopefan

no you can resize it but it won't affect the current query. so changes apply for next ones