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

Which command should be used to unload all the rows from a table into one or more files in a named stage?

    Correct Answer: A

    To unload all the rows from a table into one or more files in a named stage, the correct command to use is 'COPY INTO'. This command copies the contents of a table into files within a specified stage. It does not insert data into a table (which is what 'INSERT INTO' does), retrieve data from a stage to the local machine (as 'GET' would), or upload files to a stage (which is the function of 'PUT'). Therefore, 'COPY INTO' is the appropriate command for unloading data from a table to a stage.

Discussion
singhksOption: A

A: Unload from Table to Named Stage : https://docs.snowflake.com/en/user-guide/data-unload-overview.

MultiCloudIronManOption: A

Correct

MultiCloudIronManOption: D

I assume a table is on local file system

jestem_student

damn, tell me why?