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 1287 discussion

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

If a query is being used to unload a 1 TB table into a stage, which DML operator will be shown in the Query Profile?

  • A. INSERT
  • B. UNLOAD
  • C. COPY
  • D. UPDATE
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by MultiCloudIronMan at Jan. 10, 2025, 8:19 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
srihdar
1 month ago
Selected Answer: C
Answer is C. When unloading data from a Snowflake table into a stage (internal or external), the operation is performed using the COPY INTO <location> command. In the Query Profile, this is represented by the COPY operator. Even though you're not inserting or updating data, COPY INTO is classified as a Data Manipulation Language (DML) operation in Snowflake and appears as such in query profiles.
upvoted 1 times
...
37ceea2
3 months, 1 week ago
Selected Answer: D
COPY is not a DML. It can be INSERT or UPDATE.
upvoted 1 times
37ceea2
2 months, 2 weeks ago
Change my mind: indeed, there is a "COPY" DML indicator in Query Profile. My answer is C
upvoted 1 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago