Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
Comments
Loading comments...
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*