Snowflake
SOL-C01 · Question #142
You have a virtual warehouse named `REPORTING that you want to resize from 'MEDIUM' to 'LARGE. You execute the following SQL command: ALTER WAREHOUSE REPORTING WH SET WAREHOUSE SIZE - LARGE WAIT FOR C
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #142. The question stem and answer options stay visible for context.
Virtual Warehouses
Question
You have a virtual warehouse named `REPORTING that you want to resize from 'MEDIUM' to 'LARGE. You execute the following SQL command: ALTER WAREHOUSE REPORTING WH SET WAREHOUSE SIZE - LARGE WAIT FOR COMPLETION = TRUE; After executing this command, what will be the state of the warehouse and running queries?
Options
- AThe warehouse will be resized to LARGE immediately, and all running queries will be terminated.
- BThe warehouse will be resized to LARGE, and all running queries will continue to run on the
- CThe warehouse will be resized to LARGE after all running queries complete on the MEDIUM
- DThe command will fail because = TRUE is not a valid option for ALTER WAREHOUSE.
- EThe warehouse will be resized to LARGE, and all running queries will automatically migrate to the
Unlock SOL-C01 to see the answer
You've previewed enough free SOL-C01 questions. Unlock SOL-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Warehouse resize#WAIT_FOR_COMPLETION#ALTER WAREHOUSE#query suspension