
Answer-first summary for fast verification
Answer: COPY INTO [location], COPY INTO [table]
The correct answers are A and B because the COPY command in Snowflake can unload data to both named internal stages (using the stage name) and table stages (using the table name). Option A 'COPY INTO [location]' refers to unloading to a named internal stage, while option B 'COPY INTO [table]' refers to unloading to the table's internal stage. Option C is incorrect because 'single-true' is not a valid parameter for the COPY command. Option D is incorrect because S3://[bucket] refers to an external Amazon S3 stage, not an internal stage, which is confirmed by the community discussion noting that 'internal stage is not in S3'.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.