Snowflake SnowPro Core

Get started today

Ultimate access to all questions.

Quick Answer

Answer-first summary for fast verification

Answer: COPY INTO @stage

The correct answer is A because the COPY INTO command with a stage is the proper Snowflake syntax for unloading/exporting data from tables to external stages. Option B (EXPORT TO) is not a valid Snowflake command. Option C (INSERT INTO) is used for loading data into tables, not unloading. Option D (EXPORT_TO_STAGE) is not a valid Snowflake function. The community discussion shows 100% consensus on answer A with multiple users confirming it's correct and upvoted explanations.

Author: LeetQuiz Editorial Team

Quick Answer

Answer-first summary for fast verification

Answer: COPY INTO @stage

Author: LeetQuiz Editorial Team

Comments (0)

No comments yet.

Which of the following commands is used to unload data from Snowflake?

Exam-Like

COPY INTO @stage

100.0%

EXPORT TO @stage

0.0%

INSERT INTO @stage

EXPORT_TO_STAGE(stage => @stage, select => 'select * from t1');