COF-C02 practice question 31 of 35
What does Snowflake attempt to do if any of the compute resources for a virtual warehouse fail to provision during start-up?
Full set: 778 questionsWhen a virtual warehouse is started or resumed, Snowflake provisions compute resources from the cloud provider. If any of these resources fail to provision successfully, Snowflake's control plane automatically initiates a recovery process. This process involves attempting to restart the warehouse. A restart effectively retries the provisioning of the required compute nodes. This automated retry mechanism is designed to handle transient issues with the underlying cloud infrastructure, ensuring the warehouse becomes available without manual intervention.
A. Repair the failed resources. Snowflake uses ephemeral, stateless compute instances from the cloud provider. It does not repair individual failed instances; it replaces them by retrying the provisioning process.
C. Queue the failed resources. Queuing the failed resources would delay the warehouse's availability. The goal is to bring the warehouse online, so Snowflake actively retries provisioning, it doesn't queue the request.
D. Provision the failed resources. While Snowflake does attempt to provision resources again, "restart" is the more accurate and specific term used in the documentation to describe the automated recovery action for a failed start-up.
1. Snowflake Documentation: Troubleshooting Virtual Warehouses.
Reference Section: Under the topic "Warehouse Fails to Start or Resume"
the documentation states: "If a warehouse fails to start
Snowflake will attempt to restart the warehouse automatically." This directly supports the concept of restarting as the recovery action.
Keep practicing
Take the free COF-C02 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other COF-C02 practice questions
- Question 1What does Snowflake recommend regarding database object ownership? (Select TWO).
- Question 2What kind of value does a User-Defined Function (UDF) return? (Select TWO).
- Question 3How do Snowflake data providers share data that resides in different databases?
- Question 4What are supported file formats for unloading data from Snowflake? (Choose three.)
- Question 5A marketing co-worker has requested the ability to change a warehouse size on their mediu…
- Question 6What service is provided as an integrated Snowflake feature to enhance Multi-Factor Authe…
