SnowPro Core Certification — Question 1285

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

Answer options

• A. GET
• B. CREATE STAGE
• C. PUT
• D. COPY INTO [location]
• E. CREATE PIPE

Correct answer: B, D

Explanation

The correct answers are B and D because the CREATE STAGE command allows you to define a file format when creating a stage, and the COPY INTO command also allows the specification of the file format for unloading data. The GET and PUT commands are used for file transfer and do not involve file formats, while CREATE PIPE is related to data ingestion and not unloading.