Answer - C.
Snowflake does not begin executing SQL statements submitted to a warehouse until all of the compute resources for the warehouse are successfully provisioned, unless any of the resources fail to provision.
Ref: https://docs.snowflake.com/en/user-guide/warehouses-tasks#
A would be correct for a warehouse that is repaired.
During the repair process, the warehouse starts processing SQL statements once 50% or more of the requested compute resources are successfully provisioned.
It's a tricky question - both A&C could be correct.
Snowflake does not begin executing SQL statements submitted to a warehouse until all of the compute resources for the warehouse are successfully provisioned, unless any of the resources fail to provision:
- If any of the compute resources for the warehouse fail to provision during start-up, Snowflake attempts to repair the failed resources.
- During the repair process, the warehouse starts processing SQL statements once 50% or more of the requested compute resources are successfully provisioned.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
_yyukta
8 months, 2 weeks ago0e504b5
9 months, 2 weeks agoromega2
1 year, 1 month agoMarge23
1 year, 1 month agochaitanya_132
1 year, 3 months agoMultiCloudIronMan
1 year, 4 months agoDalo
1 year, 5 months agoisolated_sniper
1 year, 6 months agolearner2023
1 year, 7 months agoEmiB
1 year, 8 months agoBobCui
1 year, 9 months ago