Exam SnowPro Core All QuestionsBrowse all questions from this exam
Question 439

When unloading data from Snowflake, the user executes a COPY INTO command into an internal stage.

What additional command is required to load the file onto the local file system?

    Correct Answer: A

    To load the file from an internal stage onto the local file system in Snowflake, the GET command is used. The GET command retrieves data files from a Snowflake stage to a local directory on the client machine.

Discussion
EmiBOption: A

A - GET (stage to file system) C - PUT (file system to stage)

miadieselOption: A

Downloads data files from one of the following Snowflake stages to a local directory/folder on a client machine https://docs.snowflake.com/en/sql-reference/sql/get.html#get

Rob__COption: A

https://docs.snowflake.com/en/user-guide/data-unload-overview.html#bulk-unloading-process

yogenOption: A

A - GET

MultiCloudIronManOption: A

Verified