Drag steps to the numbered slots on the right, or tap a step then tap a slot.
Steps
Order
1Step 1
2Step 2
3Step 3
4Step 4
5Step 5
mediumDrag & DropObjective-mapped
DP-203 Practice Question: Drag and drop the steps to implement incremental…
Drag and drop the steps to implement incremental data loading using Azure Data Factory into the correct order.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Lookup the last watermark value from control table, then copy data from source where timestamp > watermark, then update watermark with max timestamp from copied data.
Incremental loading requires a watermark column. The pipeline retrieves the last watermark, copies data changed since then, then updates the watermark for next run.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Lookup the last watermark value from control table, then copy data from source where timestamp > watermark, then update watermark with max timestamp from copied data.
Why this is correct
This order ensures that the pipeline retrieves the previous watermark before copying new data, and updates the watermark after the copy completes, allowing the next run to pick up only new changes.
- ✗
Copy data from source, then lookup the last watermark value, then update watermark.
Why it's wrong here
Copying data before knowing the watermark would result in copying all data every time, defeating the purpose of incremental loading.
- ✗
Update watermark with max timestamp from source, then lookup the last watermark, then copy data.
Why it's wrong here
Updating the watermark before copying would set it to a future value, causing the copy to miss records that haven't been copied yet.
- ✗
Lookup the last watermark value, then update watermark with max timestamp, then copy data.
Why it's wrong here
Updating the watermark before copying would advance the watermark too early, skipping records that should be copied.
Go deeper
Related to this question
About these practice questions
One of 760 original DP-203 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DP-203 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-203 exam.