SnowPro Core Certification — Question 903

Which command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?

Answer options

• A. CREATE STAGE
• B. COPY INTO [table]
• C. COPY INTO [location]
• D. CREATE PIPE

Correct answer: C

Explanation

The correct command for unloading data from a Snowflake table to a stage is 'COPY INTO [location]'. The other options are not relevant for this operation; 'CREATE STAGE' is used to create a stage, 'COPY INTO [table]' is used to load data into a table, and 'CREATE PIPE' is for creating a data ingestion pipeline.