
Answer-first summary for fast verification
Answer: COPY INTO [location]
The question asks which command can be used to unload data into an external named stage in Snowflake. The provided SQL example uses `COPY INTO @my_stage FROM my_table`, which matches option D. `COPY INTO [location]` is specifically designed for unloading data from tables to stages (internal or external), making it the correct choice. Option C (`COPY INTO [table]`) is for loading data into tables, not unloading, so it is incorrect. Options A (`PUT`) and B (`CREATE [object]`) are not used for unloading table data to stages; `PUT` is for uploading local files to stages, and `CREATE` is for creating objects. The community discussion shows 80% support for D alone, with some (20%) suggesting CD, but C is clearly incorrect for unloading, so only D is correct.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.