Exam SnowPro Core All QuestionsBrowse all questions from this exam
Go to Exam
Question 292

When can a newly configured virtual warehouse start running SQL queries?

    Correct Answer: C

    A newly configured virtual warehouse can start running SQL queries when the warehouse provisioning is completed. This is because Snowflake requires all compute resources to be successfully provisioned before executing SQL statements. If there is any failure in provisioning, the system will attempt to repair those resources; however, this scenario doesn't apply to a newly configured virtual warehouse.

Discussion
isolated_sniperOption: C

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.

EmiBOption: A

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.

romega2Option: C

C is my answer

BobCuiOption: C

C is correct

_yyuktaOption: C

C is correct

0e504b5Option: C

C is correct

Marge23Option: C

correct

chaitanya_132Option: C

BOTH R CORRECT first we preferred to go option d like complete provisioned

MultiCloudIronManOption: C

Correct

DaloOption: C

the point is "newly" configured virtual warehouse. so answer is C

learner2023Option: A

During the repair process, the warehouse starts processing SQL statements once 50% or more of the requested compute resources are successfully provisioned.