Answer-first summary for fast verification
Answer: When the warehouse provisioning is completed
The correct answer is C based on Snowflake documentation and community consensus. According to Snowflake's official documentation, a newly configured virtual warehouse does not begin executing SQL statements until all compute resources are successfully provisioned. This is distinct from warehouse repair scenarios where execution can begin after 50% provisioning. Option A applies specifically to warehouse repair processes, not initial configuration. Option B is incorrect as ACCOUNTADMIN does not control warehouse availability timing. Option D is irrelevant as warehouse replication is a separate concept from initial provisioning. The community discussion shows strong consensus for C (71% of votes) with multiple users citing the official documentation that confirms warehouses wait for full provisioning before executing queries.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
When is a newly created virtual warehouse available to execute SQL queries?
A
After 50% of the warehouse provisioning has completed
B
During the time slots defined by the ACCOUNTADMIN
C
When the warehouse provisioning is completed
D
After the warehouse replication is completed
No comments yet.