Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Go to Exam

Question 459

What happens when the size of a virtual warehouse is changed?

Queries that are running on the current warehouse configuration are not impacted.

Queries that are running on the current warehouse configuration are aborted and have to be resubmitted by the user.

Queries that are running on the current warehouse configuration are aborted and are automatically resubmitted.

Queries that are running on the current warehouse configuration are moved to the new configuration and finished there.

Correct Answer: A

When the size of a virtual warehouse is changed, queries that are currently running on the existing warehouse configuration are not impacted. They continue to run with the existing resources until completion. The additional compute resources, once fully provisioned, are utilized for new and queued queries.

Discussion

AravindhTNOption: A

Answer is correct Resizing a running warehouse does not impact queries that are already being processed by the warehouse; the additional compute resources, once fully provisioned, are only used for queued and new queries.

SV1122Option: A

A. Queries that are running on the current warehouse configuration are not impacted.

_yyuktaOption: A

A. Queries that are running on the current warehouse configuration are not impacted.

MultiCloudIronManOption: A

correct

dmitriypoOption: A

A is correct