SnowPro Core Certification — Question 596

Which property needs to be added to the ALTER WAREHOUSE command to verify the additional compute resources for a virtual warehouse have been fully provisioned?

Answer options

• A. QUERY_ACCELERATION_MAX_SCALE_FACTOR
• B. RESOURCE_MONITOR
• C. SCALING_POLICY
• D. WAIT_FOR_COMPLETION

Correct answer: D

Explanation

The correct answer is D, WAIT_FOR_COMPLETION, as it ensures that the command waits until the provisioning of additional resources is fully completed. The other options are related to different configurations or monitoring aspects of a warehouse but do not specifically address the completion status of resource provisioning.