nerdexam
Microsoft

DP-203 · Question #186

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…

The correct answer is D. tumbling window. In case of pipeline failures, tumbling window trigger can retry the execution of the referenced pipeline automatically, using the same input parameters, without the user intervention. This can be specified using the property "retryPolicy" in the trigger definition…

Submitted by helene.fr· Mar 30, 2026Develop data processing

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?

Options

  • Aevent
  • Bon-demand
  • Cschedule
  • Dtumbling window

How the community answered

(36 responses)
  • A
    8% (3)
  • B
    3% (1)
  • C
    14% (5)
  • D
    75% (27)

Explanation

In case of pipeline failures, tumbling window trigger can retry the execution of the referenced pipeline automatically, using the same input parameters, without the user intervention. This can be specified using the property "retryPolicy" in the trigger definition. https://docs.microsoft.com/en-us/azure/data-factory/how-to-create-tumbling-window-trigger

Topics

#Azure Data Factory#tumbling window trigger#incremental load#backfilling

Community Discussion

No community discussion yet for this question.

Full DP-203 Practice