SnowPro Core Certification — Question 1018

Which Snowflake command can be used to unload the result of a query to a single file?

Answer options

• A. Use COPY INTO [external stage] followed by a GET command to download the file.
• B. Use COPY INTO [internal stage] followed by a PUT command to download the file.
• C. Use COPY INTO [internal stage] with SINGLE = TRUE followed by a GET command to download the file.
• D. Use COPY INTO [external stage] with SINGLE = TRUE followed by a PUT command to download the file.

Correct answer: C

Explanation

The correct answer is C because using COPY INTO with SINGLE = TRUE ensures the query result is unloaded into a single file, and the GET command is used to download that file. Options A and B do not specify the SINGLE = TRUE setting, which is required for a single file output, and option D incorrectly mentions a PUT command, which is not used for downloading files.