What actions are involved in performing general DML (Data Manipulation Language) operations in Snowflake? (Select all that apply)

The correct answer is B. Updating existing data C. Deleting data entirely D. Inserting new data. General DML (Data Manipulation Language) operations refer to the core actions used to manipulate data within database tables: INSERT (adding new rows), UPDATE (modifying existing rows), and DELETE (removing rows) - making B, C, and D correct. These three operations form the found

Data Modeling and Transformation

Question

Options

AMerging data from multiple tables
BUpdating existing data
CDeleting data entirely
DInserting new data

How the community answered

(48 responses)

A
8% (4)
B
92% (44)

Explanation

General DML (Data Manipulation Language) operations refer to the core actions used to manipulate data within database tables: INSERT (adding new rows), UPDATE (modifying existing rows), and DELETE (removing rows) - making B, C, and D correct. These three operations form the foundation of DML in Snowflake and virtually all SQL-based systems.

Option A is the distractor: while MERGE is a valid Snowflake DML command, it is a compound operation that combines INSERT, UPDATE, and DELETE into one statement - it is not itself one of the general DML primitives, which is what the question targets.

Memory tip: Think of the acronym UID - Update, Insert, Delete - the three building blocks of data manipulation. MERGE is just those three operations stitched together, so it doesn't count as a standalone "general" DML action.

Topics

#DML#SQL#Data Manipulation#Snowflake

Community Discussion

No community discussion yet for this question.

Full DAA-C01 Practice