SnowPro Core Certification — Question 708

How can the COPY command be used to unload data from a table to an internal stage?

Answer options

• A. COPY INTO [location]
• B. COPY INTO [table]
• C. COPY INTO [location] with single-true
• D. COPY INTO S3://[bucket]

Correct answer: A, B

Explanation

The correct answers, A and B, are valid usages of the COPY command for unloading data to an internal stage. Option C is incorrect because 'single-true' is not a valid parameter in this context, and option D specifies a location outside the internal stage by using S3, which does not meet the requirement of unloading to an internal stage.