exam questions

Exam DP-203 All Questions

View all questions & answers for the DP-203 exam

Exam DP-203 topic 1 question 93 discussion

Actual exam question from Microsoft's DP-203
Question #: 93
Topic #: 1
[All DP-203 Questions]

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?

  • A. schedule
  • B. tumbling
  • C. storage event
  • D. custom event
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
yassine70
Highly Voted 1 year, 9 months ago
Answer is Tumbling : Link : https://learn.microsoft.com/en-us/azure/data-factory/concepts-pipeline-execution-triggers#trigger-type-comparison "Retry capability Supported. Failed pipeline runs have a default retry policy of 0, or a policy that's specified by the user in the trigger definition. Automatically retries when the pipeline runs fail due to concurrency/server/throttling limits (that is, status codes 400: User Error, 429: Too many requests, and 500: Internal Server error)" Retry capability is not supported on Schedule trigger
upvoted 10 times
p_mks
1 year, 9 months ago
I don't see 'Retry' as a requirement, they mentioned only about the next pipeline execution. 'A' seems to be more appropriate.
upvoted 4 times
...
...
17lan
Most Recent 6 months ago
Selected Answer: B
Tumbling because "following a restart of the trigger." Schedule does not support restart capability https://learn.microsoft.com/en-us/azure/data-factory/concepts-pipeline-execution-triggers#trigger-type-comparison
upvoted 1 times
...
EmnCours
6 months, 1 week ago
Selected Answer: B
B. tumbling
upvoted 1 times
...
Harteko
7 months, 3 weeks ago
Selected Answer: B
A tumbling window trigger runs at a specified interval, and if the trigger stops, it maintains its schedule when restarted. This ensures the pipeline executes exactly at 2 AM daily, even after a trigger restart. Tumbling windows are useful for consistent execution without overlap or gaps, which makes them ideal for daily fixed scheduling like in this scenario.
upvoted 1 times
...
Harteko
7 months, 3 weeks ago
A tumbling window trigger runs at a specified interval, and if the trigger stops, it maintains its schedule when restarted. This ensures the pipeline executes exactly at 2 AM daily, even after a trigger restart. Tumbling windows are useful for consistent execution without overlap or gaps, which makes them ideal for daily fixed scheduling like in your scenario.
upvoted 1 times
...
This question is not clear enough. "If a pipeline stops" can mean many different things.
upvoted 2 times
...
Dusica
1 year, 1 month ago
Schedule at 1 , repeat once, delay 60 minutes
upvoted 1 times
...
lcss27
1 year, 2 months ago
Selected Answer: A
I'll go for A based on the use cases provided Microsoft Data Platform MVP: https://www.cathrinewilhelmsen.net/triggers-azure-data-factory/
upvoted 1 times
...
Azure_2023
1 year, 3 months ago
Selected Answer: B
You set up a tumbling window trigger with a window size of 1 hour and a start time of 2 AM. The trigger fires automatically at 2 AM every hour. If the trigger encounters an outage and misses a window (e.g., cannot execute at 2 AM), it automatically resumes at the beginning of the next window (i.e., at 3 AM). This ensures that the pipeline executes at 2 AM after the restart, effectively catching up for the missed execution.
upvoted 1 times
...
Khadija10
1 year, 4 months ago
Selected Answer: A
in this scenario, the requirement is to execute the pipeline at a specific time every day (2 AM) and ensure that if the trigger stops, the next pipeline execution occurs at 2 AM following a restart of the trigger. A tumbling window trigger might not guarantee that the pipeline always runs at exactly 2 AM daily, especially if the trigger stops and restarts at different times. https://learn.microsoft.com/en-us/azure/data-factory/concepts-pipeline-execution-triggers#tumbling-window-trigger https://learn.microsoft.com/en-us/azure/data-factory/concepts-pipeline-execution-triggers#schedule-trigger-with-json
upvoted 1 times
...
moneytime
1 year, 4 months ago
The answer is B Tumbling window trigger is more specific .The pipeline is trigger every 24hrs which is how a tumbling window funtion works. Scheduler is general . One can say that a schedule trigger is called Tumbling trigger when it works at non overlapping equal intervals of time just as in the pipeline case study
upvoted 1 times
...
moneytime
1 year, 4 months ago
A Tumbling widow trigger is more specific. Scheduler is general . I can say this Schedule trigger is called Tumbling trigger..
upvoted 1 times
...
jongert
1 year, 5 months ago
Selected Answer: A
The tumbling window trigger run waits for the triggered pipeline run to finish. Its run state reflects the state of the triggered pipeline run. For example, if a triggered pipeline run is cancelled, the corresponding tumbling window trigger run is marked cancelled. This is different from the "fire and forget" behavior of the schedule trigger, which is marked successful as long as a pipeline run started. https://learn.microsoft.com/en-us/azure/data-factory/concepts-pipeline-execution-triggers#trigger-type-comparison
upvoted 3 times
...
mav2000
1 year, 5 months ago
I believe it's tumbling, It doesn't say that if the trigger fails from the get-go, but if it stops, and in schedule, the state of a pipe is successful if the pipeline ran at first "The tumbling window trigger run waits for the triggered pipeline run to finish. Its run state reflects the state of the triggered pipeline run. For example, if a triggered pipeline run is cancelled, the corresponding tumbling window trigger run is marked cancelled. This is different from the "fire and forget" behavior of the schedule trigger, which is marked successful as long as a pipeline run started." https://learn.microsoft.com/en-us/azure/data-factory/concepts-pipeline-execution-triggers#trigger-type-comparison
upvoted 1 times
...
jsdsadfsad
1 year, 6 months ago
Selected Answer: D
Looks to me like Tumbling
upvoted 3 times
...
madhubanti123
1 year, 8 months ago
Selected Answer: A
Schedule triggers allow you to schedule pipelines to run at specific times and intervals. They are also idempotent, which means that if a pipeline execution fails due to a trigger failure, the next pipeline execution will still occur at the scheduled time.
upvoted 4 times
...
Vanq69
1 year, 8 months ago
"following a restart of the trigger" sounds a lot like a "retry" and only tumbling would offer a retry not schedule.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...