SnowPro Core Certification — Question 772

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

Answer options

• A. A named internal stage
• B. A Snowpipe REST endpoint
• C. A network share on a client machine
• D. A local directory or folder on a client machine
• E. A named external stage that references an external cloud location

Correct answer: A, E

Explanation

The COPY INTO [location] command can unload data to a named internal stage and a named external stage that references an external cloud location, which are both valid targets for data unloading. Options B, C, and D are incorrect because Snowpipe endpoints, client machine network shares, and local directories are not supported for the COPY INTO command.