DP-203 Develop data processing Practice Question
You need to incrementally load new and updated records from a source SQL Server database to Azure Synapse Dedicated SQL Pool. The source table has a LastModifiedDate column. Which Azure Data Factory feature should you use to implement incremental loading efficiently?
⚠ Common exam trap
It's easy for candidates to confuse a scheduling mechanism (Schedule trigger) with the actual data processing logic required for incremental loads, or they mistakenly think a single activity like Lookup or Alter Row can handle the entire incremental copy workflow without understanding the need for a watermark pattern.
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
✓
Incremental copy (watermark) pattern using a Lookup activity and a Copy activity
The incremental copy (watermark) pattern using a Lookup activity and a Copy activity is the correct approach because it allows you to query the source table for the maximum LastModifiedDate value (the watermark), store it in a control table or variable, and then use a Copy activity with a WHERE clause to load only rows where LastModifiedDate is greater than the last run's watermark. This pattern is purpose-built for efficiently handling new and updated records in Azure Data Factory without reprocessing the entire dataset.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Alter Row transformation
Why it's wrong here
Alter Row is a mapping data flow transformation for upserts, not for incremental copy scheduling.
- ✓
Incremental copy (watermark) pattern using a Lookup activity and a Copy activity
Why this is correct
The watermark pattern uses a lookup to get the last watermark value and a copy activity to copy data changed after that watermark.
- ✗
Schedule trigger
Why it's wrong here
Schedule trigger starts the pipeline at a scheduled time but does not implement incremental logic.
- ✗
Lookup activity alone
Why it's wrong here
Lookup activity only retrieves data; it cannot perform the copy.
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.