SnowPro Core Certification — Question 711
Which command is used to unload data from a table or move a query result to a stage?
Answer options
- A. COPY INTO
- B. GET
- C. MERGE
- D. PUT
Correct answer: A
Explanation
The correct command to unload data from a table or move query results is COPY INTO, as it specifically facilitates exporting data to a specified location. GET is used for loading data into Snowflake, MERGE is for combining data from two tables, and PUT is for uploading files to a stage, making them unsuitable for unloading data.