DAA-C01 · Question #13
DAA-C01 Question #13: Real Exam Question with Answer & Explanation
The correct answer is B: Updating existing 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
Question
What actions are involved in performing general DML (Data Manipulation Language) operations in Snowflake? (Select all that apply)
Options
- AMerging data from multiple tables
- BUpdating existing data
- CDeleting data entirely
- DInserting new data
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
Community Discussion
No community discussion yet for this question.