SnowPro Core Exam QuestionsBrowse all questions from this exam

SnowPro Core Exam - Question 1265


While preparing to unload data in Snowflake, the file format option can be specified in which commands? (Choose two.)

Show Answer
Correct Answer:

Discussion

1 comment
Sign in to comment
JRayanOptions: BD
Feb 9, 2025

The correct answers are B. CREATE STAGE and D. COPY INTO [location]. Explanation: CREATE STAGE: When creating a stage in Snowflake, you can define the file format options that will be used when data is unloaded to that stage. COPY INTO [location]: The COPY INTO command is used to unload data from a table to a stage. You can specify the file format directly within the COPY INTO command if you don't want to use the pre-defined format on the stage