Answer-first summary for fast verification
Answer: A unique identifier or primary key must be defined for matching records between the source and target.
For the APPLY CHANGES INTO statement to function correctly, it's essential to have a unique identifier or primary key. This key is used to match records between the source and target datasets, ensuring accurate updates or inserts. This mechanism guarantees that changes in the source data are precisely synchronized with the target table, avoiding duplicates or mismatches.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What is a crucial requirement for the effective use of the APPLY CHANGES INTO statement in Change Data Capture (CDC) with Delta Live Tables?
A
The source data must be in CSV format for the statement to process changes.
B
A unique identifier or primary key must be defined for matching records between the source and target.
C
All source data must be timestamped to identify the latest changes.
D
The source and target tables must reside in the same Delta Lake.
No comments yet.