A timestamp-watermark pipeline uses modification time but misses deleted rows and some equal-timestamp updates. What is the best next step?

Choose the single best answer.

A.Increase destination compute and leave change detection unchanged
B.Replace the watermark with an untracked wall clock and skip checkpoints
C.Design correct watermark boundaries and deletion handling or use supported CDC, then reconcile business totals
D.Use only pipeline activity success as proof every source change arrived

Show the answer and explanation

✓ Correct answer

Design correct watermark boundaries and deletion handling or use supported CDC, then reconcile business totals

The fault is incomplete change capture. Robust boundaries/deletion handling or supported CDC addresses it; reconciliation proves effects. Faster destination compute and activity success do not correct missing changes, and losing tracked progress worsens recovery. Source guide: PDF page 32.

Read the source reference

This item is flagged for content review.

Read and review here, or open the app to practise and save your results on this device.

Practise in the app

Unofficial study aid; not affiliated with or endorsed by Microsoft. Original practice questions are not real examination questions and do not guarantee an exam result.