ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-203 All Questions

View all questions & answers for the DP-203 exam
Go to Exam

Exam DP-203 topic 2 question 115 discussion

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

You have an Azure data factory named ADF1 that contains a pipeline named Pipeline1.

Pipeline1 must execute every 30 minutes with a 15-minute offset.

You need to create a trigger for Pipeline1. The trigger must meet the following requirements:

• Backfill data from the beginning of the day to the current time.
• If Pipeline1 fails, ensure that the pipeline can re-execute within the same 30-minute period.
• Ensure that only one concurrent pipeline execution can occur.
• Minimize development and configuration effort.

Which type of trigger should you create?

  • A. schedule
  • B. event-based
  • C. manual
  • D. tumbling window
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by Paulkuzzio at Aug. 25, 2023, 3:41 a.m.

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
Submit Cancel
nadavw
5 days, 21 hours ago
Selected Answer: D
comparison between schedule and tumbling
upvoted 1 times
...
swathi_rs
3 months, 4 weeks ago
almost always it's tumbling window
upvoted 1 times
...
[Removed]
7 months, 3 weeks ago
Selected Answer: D
Tumbling window because of the backfill
upvoted 2 times
...
Lucasmh
8 months, 2 weeks ago
Selected Answer: C
data is expected to arrive at regular intervals, and you want to trigger a pipeline with a fixed window size. For the specific requirements mentioned, especially the need to execute every 30 minutes with a 15-minute offset and backfill data from the beginning of the day to the current time, a schedule trigger is more suitable. The tumbling window trigger is generally used for scenarios where you want to process data in fixed windows based on its arrival time.
upvoted 1 times
...
msb
11 months, 1 week ago
Tumbling window is correct. Backfill scenario: https://learn.microsoft.com/en-us/azure/data-factory/how-to-create-tumbling-window-trigger?tabs=data-factory%2Cazure-powershell#execution-order-of-windows-in-a-backfill-scenario offset, concurrency, ... : https://learn.microsoft.com/en-us/azure/data-factory/how-to-create-tumbling-window-trigger?tabs=data-factory%2Cazure-powershell#tumbling-window-trigger-type-properties
upvoted 3 times
...
DataEngDP
11 months, 2 weeks ago
schedule because it occurs every 30 minutes
upvoted 2 times
...
kkk5566
11 months, 4 weeks ago
Selected Answer: D
seem to correct
upvoted 2 times
...
Paulkuzzio
12 months ago
It seems correct but the 15mins offset is throwing me off. Somebody please explain. Thanks
upvoted 4 times
Lewiasskick
7 months, 2 weeks ago
offset refers to the delay of start of the trigger : A timespan value that must be negative in a self-dependency. If no value specified, the window is the same as the trigger itself.
upvoted 1 times
...
g2000
10 months ago
Ensure that only one concurrent pipeline execution can occur <--- this suggests the tumbling window
upvoted 2 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago