Question 120
A legacy SQL extraction lacks a trustworthy change timestamp and a scheduled job wants true incremental loading. What should the engineer verify before declaring success?
Explanation
Correct Answer
This outcome directly verifies the scenario's required behavior: an unreliable watermark can miss changes; alternative reconciliation or change capture is required.
Incorrect Answers
Connectivity says nothing about missing updates.
ID watermarks do not capture UPDATE or DELETE on older keys.
Clock values without source-maintained change markers are not a change feed.