Answer-first summary for fast verification
Answer: A named internal stage, A named external stage that references an external cloud location
The COPY INTO <location> command is used to unload data from Snowflake tables to external locations. According to Snowflake documentation and the community consensus with 100% agreement, this command supports unloading to: (A) Named internal stages, which are Snowflake-managed storage locations, and (E) Named external stages that reference external cloud storage locations (S3, GCS, or Azure Blob Storage). Option B (Snowpipe REST endpoint) is incorrect as Snowpipe is for data loading, not unloading. Options C (network share) and D (local directory) are incorrect because COPY INTO cannot write directly to client-side file systems or network shares; it only unloads to Snowflake-managed stages or external cloud storage.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
The COPY INTO <location> command can unload data from a table directly into which locations? (Choose two.)
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
No comments yet.