Answer-first summary for fast verification
Answer: ```sql MERGE INTO orders USING new_orders ON orders.orders_id = new_orders.orders_id WHEN NOT MATCHED INSERT *
The correct syntax for an insert-only merge operation is to use the `MERGE INTO` command with only the `WHEN NOT MATCHED` clause, which inserts a row when a source row does not match any target row based on the merge condition. Records with keys matching existing records in the target table are ignored. Reference: [Databricks Documentation](https://docs.databricks.com/sql/language-manual/delta-merge-into.html).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What command enables data engineers to execute an insert-only merge operation?
A
MERGE INTO orders
USING new_orders
ON orders.orders_id = new_orders.orders_id
WHEN MATCHED
INSERT *
MERGE INTO orders
USING new_orders
ON orders.orders_id = new_orders.orders_id
WHEN MATCHED
INSERT *
B
MERGE INTO orders
USING new_orders
ON orders.orders_id = new_orders.orders_id
WHEN NOT MATCHED
INSERT *
WHEN MATCHED
IGNORE
MERGE INTO orders
USING new_orders
ON orders.orders_id = new_orders.orders_id
WHEN NOT MATCHED
INSERT *
WHEN MATCHED
IGNORE
C
MERGE INTO orders
USING new_orders
ON orders.orders_id = new_orders.orders_id
WHEN NOT MATCHED
INSERT *
ELSE
IGNORE
MERGE INTO orders
USING new_orders
ON orders.orders_id = new_orders.orders_id
WHEN NOT MATCHED
INSERT *
ELSE
IGNORE
D
MERGE INTO orders
USING new_orders
ON orders.orders_id = new_orders.orders_id
WHEN NOT MATCHED
INSERT *
MERGE INTO orders
USING new_orders
ON orders.orders_id = new_orders.orders_id
WHEN NOT MATCHED
INSERT *
E
MERGE INTO orders
USING new_orders
ON orders.orders_id = new_orders.orders_id
WHEN MATCHED
INSERT *
WHEN NOT MATCHED
IGNORE
MERGE INTO orders
USING new_orders
ON orders.orders_id = new_orders.orders_id
WHEN MATCHED
INSERT *
WHEN NOT MATCHED
IGNORE
No comments yet.