COF-C02 · Question #613
Which Query Profile operator is considered a DML operator?
The correct answer is C. Merge. In Snowflake's Query Profile, DML (Data Manipulation Language) operators are those that write or modify data. MERGE is a DML operation that combines INSERT, UPDATE, and DELETE into a single statement to synchronize a target table with a source. ExternalScan reads data from…
Question
Which Query Profile operator is considered a DML operator?
Options
- AExternalScan
- BFlatten
- CMerge
- DSort
How the community answered
(34 responses)- B3% (1)
- C94% (32)
- D3% (1)
Explanation
In Snowflake's Query Profile, DML (Data Manipulation Language) operators are those that write or modify data. MERGE is a DML operation that combines INSERT, UPDATE, and DELETE into a single statement to synchronize a target table with a source. ExternalScan reads data from external tables/stages (a scan operator). Flatten expands semi-structured data like arrays (a transformation operator). Sort orders result sets (a processing operator). Only Merge among the choices performs data modification, making it the DML operator.
Topics
Community Discussion
No community discussion yet for this question.