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

What command is used to download data from a Snowflake stage?

    Correct Answer: C

    The correct command to download data files from a Snowflake stage to a local directory is 'GET'. The GET command retrieves data from a Snowflake stage, whereas other commands like PUT, INSERT, and COPY serve different purposes. PUT uploads data to a stage, INSERT inserts data into a table, and COPY copies data into a table from a stage. Therefore, the proper command for downloading data files from a Snowflake stage is GET.

Discussion
MultiCloudIronManOption: C

GET Downloads data files from one of the following Snowflake stages to a local directory/folder on a client machine: Named internal stage. Internal stage for a specified table. Internal stage for the current user. Typically, this command is executed after using the COPY INTO <location> command to unload data from a table into a Snowflake stage.

dementorOption: C

GET COMMAND

muks86Option: C

GET COMMAND FROM SNOWFLAKE DOCUMENTATION.

RajivnbOption: C

Why GET and why not COPY. If the questions is about Unloading and Uploading the data, then its COPY. Again, they did not tell Data Files in the question. If its Data Files then GET is the answer. But they used the word DOWNLOAD. so let us assume the DATA meant here is DATA FILES. so its GET

examtopics_strataOption: C

Verified

KnightVictorOption: C

for sure GET. its from documentation