SnowPro Core Certification — Question 30

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

Answer options

• A. UPSERT
• B. MERGE
• C. UPDATE
• D. TRUNCATE TABLE

Correct answer: A

Explanation

The correct answer is A, as Snowflake does not support the UPSERT command. Instead, users can achieve similar functionality through the MERGE command, while UPDATE and TRUNCATE TABLE are supported DML operations in Snowflake.