SnowPro Core Exam QuestionsBrowse all questions from this exam

SnowPro Core Exam - Question 99


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

Show Answer
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

5 comments
Sign in to comment
jtm22Option: A
Feb 2, 2023

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

learnazureportal
Apr 17, 2022

Answer is correct

Mayuri917233Option: A
May 11, 2023

A is correct

ka2456Option: B
Jan 30, 2023

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
Jan 31, 2023

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

Hopefan
May 12, 2023

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

Mallikharjuna452Option: A
Jul 19, 2024

A Is correct