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

The COPY INTO command can unload data from a table directly into which locations? (Choose two.)

    Correct Answer: A, E

    The COPY INTO <location> command in Snowflake can unload data from a table directly into either a named internal stage or a named external stage that references an external cloud location. An internal stage holds data within the Snowflake ecosystem while an external stage can reference an external storage location such as Amazon S3, Google Cloud Storage, or Microsoft Azure.

Discussion
BobFarOptions: AE

AE is correct Copy into is possible for 1) Named internal stage (or table/user stage). 2) Named external stage that references an external location (Amazon S3, Google Cloud Storage, or Microsoft Azure). 3) External location https://docs.snowflake.com/en/sql-reference/sql/copy-into-location

romega2Options: AE

AE correct

HeetecOptions: AE

AE correct - https://docs.snowflake.com/en/sql-reference/sql/copy-into-location