Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
What command enables data engineers to execute an insert-only merge operation?
A
MERGE INTO ordersUSING new_ordersON orders.orders_id = new_orders.orders_idWHEN MATCHED INSERT *
B
MERGE INTO ordersUSING new_ordersON orders.orders_id = new_orders.orders_idWHEN NOT MATCHED INSERT *WHEN MATCHED IGNORE *
C
MERGE INTO ordersUSING new_ordersON orders.orders_id = new_orders.orders_idWHEN NOT MATCHED INSERT *ELSE IGNORE *
D
MERGE INTO ordersUSING new_ordersON orders.orders_id = new_orders.orders_idWHEN NOT MATCHED INSERT *
E
MERGE INTO ordersUSING new_ordersON orders.orders_id = new_orders.orders_idWHEN MATCHED INSERT *WHEN NOT MATCHED IGNORE *
