nerdexam
MicrosoftMicrosoft

DP-203 · Question #354

DP-203 Question #354: Real Exam Question with Answer & Explanation

The correct answer is A: schedule. A Schedule trigger fires at a specific wall-clock time on a recurring basis - exactly what "2 AM every day" describes - and when restarted after a stop, it simply waits for the next scheduled time (2 AM) rather than trying to catch up on missed runs. Why the distractors are wrong

Submitted by tunde_lagos· Mar 30, 2026Develop data processing

Question

You have an Azure Data Factory pipeline named pipeline1. You need to execute pipeline1 at 2 AM every day. The solution must ensure that if the trigger for pipeline1 stops, the next pipeline execution will occur at 2 AM, following a restart of the trigger. Which type of trigger should you create?

Options

  • Aschedule
  • Btumbling
  • Cstorage event
  • Dcustom event

Explanation

A Schedule trigger fires at a specific wall-clock time on a recurring basis - exactly what "2 AM every day" describes - and when restarted after a stop, it simply waits for the next scheduled time (2 AM) rather than trying to catch up on missed runs.

Why the distractors are wrong:

  • B. Tumbling window triggers are time-based but are designed for processing data in non-overlapping, sequential windows; they will backfill missed intervals when restarted, which violates the requirement that the next run simply occurs at 2 AM.
  • C. Storage event triggers fire in response to blob storage events (e.g., file created/deleted), not on a time schedule.
  • D. Custom event triggers fire based on Azure Event Grid events published by external systems, also unrelated to time-based scheduling.

Memory tip: Think "Schedule = calendar appointment" - it runs at the time on the clock, no backfilling. If you need to reprocess missed time slots, that's when you'd reach for Tumbling Window instead.

Topics

#Azure Data Factory#ADF Triggers#Schedule Trigger#Pipeline Orchestration

Community Discussion

No community discussion yet for this question.

Full DP-203 PracticeBrowse All DP-203 Questions