Answer-first summary for fast verification
Answer: Queries that are running on the current warehouse configuration are not impacted.
According to Snowflake documentation and the community consensus (with multiple upvoted comments confirming this behavior), when a virtual warehouse size is modified, queries that are currently executing continue running on the original warehouse configuration without interruption. The resize operation only affects queued queries and new queries submitted after the resize, which will use the new warehouse size once it's fully provisioned. Options B and C are incorrect because running queries are not aborted, and option D is incorrect because queries are not moved to the new configuration mid-execution.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
When a virtual warehouse size is modified, what is the immediate impact on the queries that are currently executing on that warehouse?
A
Queries that are running on the current warehouse configuration are not impacted.
B
Queries that are running on the current warehouse configuration are aborted and have to be resubmitted by the user.
C
Queries that are running on the current warehouse configuration are aborted and are automatically resubmitted.
D
Queries that are running on the current warehouse configuration are moved to the new configuration and finished there.