DP-300 Certification Practice Question #188

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

Tumbling window triggers in Azure Data Factory support: (1) automatic retry of failed runs (with configurable retry policy for concurrency/throttling issues), and (2) backfilling historical data by allowing triggers to be activated for past time windows. Schedule triggers do not natively support backfilling or automatic retry for failed runs. This is the standard ADF pattern for incremental loads with retry requirements. (Note: this question is from DP-203 territory but appears in DP-300 exam.)

More DP-300 practice questions