ExamGecko
Question list
Search
Search

Question 145 - COF-R02 discussion

Report
Export

What happens when a virtual warehouse is resized?

A.
When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected
Answers
A.
When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected
B.
When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.
Answers
B.
When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.
C.
The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.
Answers
C.
The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.
D.
Users who are trying to use the warehouse will receive an error message until the resizing is complete
Answers
D.
Users who are trying to use the warehouse will receive an error message until the resizing is complete
Suggested answer: B
asked 23/09/2024
Solange Castro
32 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first