
Answer-first summary for fast verification
Answer: CREATE STAGE, COPY INTO [location]
The question asks which commands allow specifying file format options when unloading data in Snowflake. According to Snowflake documentation and the community discussion with 100% consensus, CREATE STAGE (B) allows defining file format options that will be used when unloading data to that stage. COPY INTO [location] (D) also allows specifying file format directly within the command when unloading data from a table to a stage. GET (A) is for downloading files from a stage, not unloading data. PUT (C) is for uploading files to a stage. CREATE PIPE (E) is for loading data continuously, not unloading.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.