SnowPro Core Certification — Question 386

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

Answer options

• 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.

Correct answer: A

Explanation

The correct answer is A because changing the size of a virtual warehouse does not disrupt ongoing queries; they continue processing as they were. Options B, C, and D incorrectly suggest that active queries are aborted or moved, which is not the case during a size modification.