SnowPro Core Certification — Question 710

Which command should be used to unload all the rows from a table into one or more files in a named stage?

Answer options

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

Correct answer: A

Explanation

The correct answer is A, COPY INTO, as this command is specifically designed to unload data from a table to files in a stage. The other options do not serve this purpose: B, GET is used to download files from a stage, C, INSERT INTO is for adding data to a table, and D, PUT is used to upload files to a stage.