ExamTopics Logo
Mail Us[email protected]
Menu
Snowflake Discussions
exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam
Go to Exam

Exam SnowPro Core topic 1 question 932 discussion

Actual exam question from Snowflake's SnowPro Core
Question #: 932
Topic #: 1
[All SnowPro Core Questions]

Which command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?

  • A. CREATE STAGE
  • B. COPY INTO [table]
  • C. COPY INTO [location]
  • D. CREATE PIPE
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by DR369 at Jan. 8, 2024, 7:32 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Lematthew31
6 months, 3 weeks ago
Selected Answer: C
It's C - https://docs.snowflake.com/en/sql-reference/sql/copy-into-location COPY INTO <location> Unloads data from a table (or query) into one or more files in one of the following locations: Named internal stage (or table/user stage). The files can then be downloaded from the stage/location using the GET command. Named external stage that references an external location (Amazon S3, Google Cloud Storage, or Microsoft Azure). External location (Amazon S3, Google Cloud Storage, or Microsoft Azure).
upvoted 1 times
...
tidz
10 months, 1 week ago
copy into command
upvoted 2 times
...
DR369
10 months, 3 weeks ago
answer B,C
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel