Snowpro Core · Free Practice Question Medium
Question 9
The COPY command can unload data from a table into which of the following locations? Select all that apply.
- A Named Internal Stage
- B External Stage
- C Local NAS
- D On-premises system
Reveal correct answers
Correct answers: A, B
Explanation
Similar to how data warehouses use staging, Snowflake uses a Stage object. Snowflake uses stages to aid in the loading and unloading of data. The data must first be available in a Snowflake stage to load data into a Snowflake table. COPY command can be used to load data into a table after the data is loaded in a stage. Data unloading or exporting is also performed via a Stage object; the data can only be extracted to a stage, internal or external. https://docs.snowflake.com/en/user-guide/data-load-overviewDiscussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
