exam questions

Exam DP-200 All Questions

View all questions & answers for the DP-200 exam

Exam DP-200 topic 15 question 1 discussion

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

You need to ensure that phone-based poling data can be analyzed in the PollingData database.
How should you configure Azure Data Factory?

  • A. Use a tumbling schedule trigger
  • B. Use an event-based trigger
  • C. Use a schedule trigger
  • D. Use manual execution
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
When creating a schedule trigger, you specify a schedule (start date, recurrence, end date etc.) for the trigger, and associate with a Data Factory pipeline.
Scenario:
All data migration processes must use Azure Data Factory
All data migrations must run automatically during non-business hours
References:
https://docs.microsoft.com/en-us/azure/data-factory/how-to-create-schedule-trigger

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
Randy478
Highly Voted 4 years, 11 months ago
Asked for Retry when needed but not automatic retry. Tumbling window trigger retry automatically after the number of minutes configured. So Scheduling Trigger might be correct answer.
upvoted 20 times
...
Siva_s
Highly Voted 5 years ago
Scheduled trigger does not support retry https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipeline-execution-triggers#trigger-type-comparison
upvoted 8 times
MLCL
4 years, 10 months ago
It does, when creating a schedule trigger, you specify a schedule (start date, recurrence, end date etc.) https://docs.microsoft.com/en-us/azure/data-factory/how-to-create-schedule-trigger
upvoted 2 times
...
...
dumpsm42
Most Recent 4 years, 5 months ago
hi to all, answer A why ? because the text says "...retry..." so this link says it all: https://docs.microsoft.com/pt-pt/azure/data-factory/how-to-create-tumbling-window-trigger umbling window triggers are a type of trigger that fires at a periodic time interval from a specified start time, while retaining state. Tumbling windows are a series of fixed-sized, non-overlapping, and contiguous time intervals. A tumbling window trigger has a one-to-one relationship with a pipeline and can only reference a singular pipeline. Tumbling window trigger is a more heavy weight alternative for schedule trigger offering a suite of features for complex scenarios(dependency on other tumbling window triggers, rerunning a failed job and set user retry for pipelines). only with this type we can retry in case of failure, with just a scheduled trigger nope. thats it. regards
upvoted 2 times
...
syu31svc
4 years, 5 months ago
When you create a schedule trigger, you specify scheduling and recurrence by using a JSON definition. Answer is C
upvoted 2 times
...
anurag1p
4 years, 6 months ago
With Tumbling window trigger, you have to define the run in the intervals of Minutes & Hours and no way you can schedule it at a specific time. That's the basic requirement to run it in non business hours.
upvoted 1 times
...
apandey
4 years, 10 months ago
The option is Tumbling "schedule" trigger and not tumbling "window" trigger, so schedule trigger might be best fit in this case.
upvoted 3 times
...
RajdeepRoy
4 years, 10 months ago
Answer: C. Use a schedule trigger
upvoted 5 times
...
Dileep1
5 years ago
However, All data migrations must run automatically during non-business hours is also mentioned so I got confused now and help me understand the right answer.
upvoted 1 times
...
Dileep1
5 years ago
Data migrations must be reliable and retry when needed. This is mentioned in question so I think Tumbling Window trigger is the answer.
upvoted 7 times
drdean
5 years ago
As "Use a tumbling schedule trigger" is not a real possibility, schedule trigger is the best option (unless the options have been recorded incorrectly)
upvoted 6 times
...
Luke97
4 years, 11 months ago
I think Tumbling Window is more useful for time-based data. The requirement said "retry when needed" but not "automatically retry".
upvoted 3 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 ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago