SnowPro Core Certification — Question 574

What command should be used to move data from a Snowflake database table into one or more files in an external stage?

Answer options

• A. GET
• B. COPY INTO
• C. PUT
• D. SHOW

Correct answer: B

Explanation

The correct command is 'COPY INTO', which is specifically designed to export data from a table to an external location. The 'GET' command is used for downloading files from an external stage to Snowflake, 'PUT' is for uploading files to an external stage, and 'SHOW' is used to list objects without moving data.