Answer: Merge

The correct answer is C (Merge) because it is explicitly classified as a DML (Data Manipulation Language) operator in Snowflake documentation. DML operations modify data in tables and include INSERT, UPDATE, DELETE, and MERGE. The community discussion confirms this with references to Snowflake documentation showing MERGE as a DML operator, and the consensus shows 100% agreement on option C. Option A (ExternalScan) is related to external table scanning, not data modification. Option B (Flatten) is a table function for semi-structured data processing. Option D (Sort) is a data processing operation but not specifically a DML operator.

Author: LeetQuiz Editorial Team