SnowPro Core Certification — Question 115

Which of the following statements would be used to export/unload data from Snowflake?

Answer options

• A. COPY INTO @stage
• B. EXPORT TO @stage
• C. INSERT INTO @stage
• D. EXPORT_TO_STAGE(stage => @stage, select => 'select * from t1');

Correct answer: A

Explanation

The correct command to export or unload data from Snowflake is 'COPY INTO @stage', which is designed for this purpose. The other options either do not exist in Snowflake's syntax or serve different functions, such as inserting data rather than exporting it.