SOL-C01 Question #142: Real Exam Question with Answer & Explanation

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

Explanation

When resizing a virtual warehouse with = TRUE , Snowflake will wait for all currently running queries to finish on the old warehouse size before resizing to the new size. New queries will be blocked until the resize is finished. This ensures a clean transition without interrupting existing

No community discussion yet for this question.