Databricks Certified Data Engineer - Professional

Get started today

Ultimate access to all questions.

Explanation:

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.

Explanation:

Comments (0)

No comments yet.

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 *

9.5%

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

8.3%

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

6.0%

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 *

66.7%

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.5%