Exam SnowPro Core All QuestionsBrowse all questions from this exam
Go to Exam
Question 532

What command is used to export or unload data from Snowflake?

    Correct Answer: C

    To export or unload data from Snowflake to an external location, the command used is 'COPY INTO <location>'. This command allows data to be copied from a Snowflake table into a specified location, such as an external stage or cloud storage. Other options such as GET are related to manipulating staged files, not directly unloading data from Snowflake tables.

Discussion
SimbajagnoleOption: C

COPY INTO <location> https://docs.snowflake.com/en/sql-reference/sql/copy-into-location

ShagunMittalOption: C

GET is used to download files

MultiCloudIronManOption: B

Am not sure why I chose C the answer is B

bibisaOption: C

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

Aravan123sOption: C

C COPY INTO <location>

FranzozOption: B

Unloading is 2 step process 1. From table(COPY) 2. From Snowflake(GET), and Quesions is referring to the second step.

AmitsnowflakeOption: C

I assume unloading into snowflake statement means unloading into stage. Ans should be C in that case

MultiCloudIronManOption: C

Verified again sorry for the confusion.

MultiCloudIronManOption: C

Verified

MultiCloudIronMan

Sorry its C because it says @mystage whicj means its not to on premise file system