Question 670
A database team wants evidence that it fixed this issue: A change-capture pipeline restarts after a network outage and silently skips a period of source commits. Which result would verify success?
Explanation
Correct Answer
The target contains all changes across the interrupted interval with no unexplained gaps. The result directly checks whether the remedy worked: Restore a valid checkpoint or perform supported resynchronization with reconciliation. The cause was the connector resumes from an incorrect log offset rather than the last safely applied position.
Incorrect Answers
Even if this observation were recorded, it would support a case where a continuous replication stream reports success but deletes on the source remain visible at the target. It would not verify that the target contains all changes across the interrupted interval with no unexplained gaps.
This finding relates to a situation in which a parallel-run comparison flags mismatches because the same transaction is captured at different times in source and target snapshots. The current remediation must instead show that the target contains all changes across the interrupted interval with no unexplained gaps.
This finding relates to a situation in which a managed destination database is provisioned with less storage than the source's live tables and planned index overhead. The current remediation must instead show that the target contains all changes across the interrupted interval with no unexplained gaps.