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

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

Which of the following DML commands isn't supported by Snowflake?

  • A. UPSERT
  • B. MERGE
  • C. UPDATE
  • D. TRUNCATE TABLE
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by moon2351 at Jan. 2, 2022, 11:11 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
arpit_dataguy
Highly Voted 3 years ago
Selected Answer: A
There is nothing called UPSERT in snowflake. MERGE = UPDATE+INSERT+DELETE. Also, unlike other databases TRUNCATE is considered DML in snowflake.
upvoted 5 times
...
jeny12138
Most Recent 4 months, 1 week ago
Selected Answer: A
there is no upsert
upvoted 1 times
...
_yyukta
12 months ago
Selected Answer: A
A.UPSERT
upvoted 1 times
...
Marge23
1 year, 5 months ago
A. correct
upvoted 1 times
...
v1tjkee
1 year, 6 months ago
TRUNCATE TABLE is DDL operation, as far as I know it drops tables and recreates it.
upvoted 2 times
...
Mayuri917233
1 year, 9 months ago
Selected Answer: A
A is correct
upvoted 2 times
...
Tapasgup007
2 years, 2 months ago
Selected Answer: A
A is correct
upvoted 1 times
...
Ccastan1
2 years, 9 months ago
What is the correct answer if not UPSERT?
upvoted 1 times
...
arpit_dataguy
3 years ago
Selected Answer: A
There is nothing called UPSERT in snowflake. MERGE = UPDATE+INSERT.
upvoted 1 times
...
moon2351
3 years, 1 month ago
Selected Answer: A
Commands for inserting, deleting, updating, and merging data in Snowflake tables: INSERT INSERT (multi-table) MERGE UPDATE DELETE TRUNCATE TABLE
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