SnowPro Core Certification — Question 1198

Which command can be used to unload data into an external named stage in Snowflake?

Answer options

• A. PUT
• B. CREATE [object]
• C. COPY INTO [table]
• D. COPY INTO [location]

Correct answer: D

Explanation

The correct answer is D, as the COPY INTO [location] command is specifically designed to unload data from Snowflake into an external stage. Options A, B, and C do not serve the purpose of exporting data to an external location; A is for uploading files, B is for creating objects, and C is for copying data into a table.