Databricks Certified Data Engineer - Professional

Ultimate access to all questions.

What command enables data engineers to execute an insert-only merge operation?

Real Exam

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 *

8.3%

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

7.6%

Loading comments...

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

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 *

68.8%

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

9.6%