DP-203 Certification Practice Question #139

Question

You have an Azure Data Factory pipeline that performs an incremental load of source data to an Azure Data Lake Storage Gen2 account.
Data to be loaded is identified by a column named LastUpdatedDate in the source table.
You plan to execute the pipeline every four hours.
You need to ensure that the pipeline execution meets the following requirements:
âœ‘ Automatically retries the execution when the pipeline run fails due to concurrency or throttling limits.
âœ‘ Supports backfilling existing data in the table.
Which type of trigger should you use?

Accepted Answer

The key words in the requirement are retry on concurrency or throttling failures and support for backfilling existing data. Microsoft Learn’s trigger comparison maps both of those directly to tumbling window triggers. A schedule trigger can run every four hours, but it does not offer the same built-in backfill and retry semantics, so D is the clear answer.

More DP-203 practice questions