
Answer-first summary for fast verification
Answer: COPY INTO [location]
The COPY INTO [location] command is the correct choice for unloading data from a table into an external stage in Snowflake. This command is specifically designed for exporting data from tables to external locations (stages), supporting various file formats and compression options. PUT is used for uploading files from a local system to a stage, not for unloading table data. INSERT is for adding data to tables, not exporting. GET is for downloading files from a stage to a local system. The community discussion confirms this with 100% consensus on option C and upvoted comments stating 'C correct', aligning with Snowflake best practices for data unloading operations.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.