Question 600
A CDC table supplies changes and a target needs to handle matched records differently from new keys in one command. Which SQL operation is intended?
Explanation
Correct Answer
Correct for MERGE: MERGE supports matched/unmatched branching for incremental synchronization.
Incorrect Answers
Not the right operation for MERGE: UPDATE changes column values of selected existing rows.
Not the right operation for MERGE: DELETE removes rows matching an eligible condition.
Not the right operation for MERGE: INSERT INTO ... SELECT appends rows produced by a SELECT to a target.