COF-C02 · Question #49
COF-C02 Question #49: Real Exam Question with Answer & Explanation
The correct answer is A: When increasing the size of an active warehouse the compute resource for all running and queued. When a virtual warehouse in Snowflake is resized, specifically when it is increased in size, the additional compute resources become immediately available to all running and queued queries. This means that the performance of these queries can improve due to the increased resource
Question
What happens when a virtual warehouse is resized?
Options
- AWhen increasing the size of an active warehouse the compute resource for all running and queued
- BWhen reducing the size of a warehouse the compute resources are removed only when they are
- CThe warehouse will be suspended while the new compute resource is provisioned and will resume
- DUsers who are trying to use the warehouse will receive an error message until the resizing is
Explanation
When a virtual warehouse in Snowflake is resized, specifically when it is increased in size, the additional compute resources become immediately available to all running and queued queries. This means that the performance of these queries can improve due to the increased resources. Conversely, when the size of a warehouse is reduced, the compute resources are not removed until they are no longer being used by any current operations.
Topics
Community Discussion
No community discussion yet for this question.