Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Go to Exam

Question 1039

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

Use COPY INTO followed by a GET command to download the file.

Use COPY INTO followed by a PUT command to download the file.

Use COPY INTO with SINGLE = TRUE followed by a GET command to download the file.

Use COPY INTO with SINGLE = TRUE followed by a PUT command to download the file.

Correct Answer: C

To unload the result of a query to a single file in Snowflake, you should use the COPY INTO command with the SINGLE = TRUE option, followed by a GET command to download the file. The internal stage is part of Snowflake's cloud storage, and the GET command allows you to retrieve the file. The SINGLE = TRUE option ensures that the result is saved in a single file.

Discussion

nexerSnowOption: C

https://docs.snowflake.com/en/user-guide/data-unload-considerations