Exam DP-203 All Questions

View all questions & answers for the DP-203 exam

Exam DP-203 topic 2 question 45 discussion

Actual exam question from Microsoft's DP-203

Question #: 45
Topic #: 2

You have the following Azure Data Factory pipelines:
✑ Ingest Data from System1
✑ Ingest Data from System2
✑ Populate Dimensions
✑ Populate Facts
Ingest Data from System1 and Ingest Data from System2 have no dependencies. Populate Dimensions must execute after Ingest Data from System1 and Ingest
Data from System2. Populate Facts must execute after Populate Dimensions pipeline. All the pipelines must execute every eight hours.
What should you do to schedule the pipelines for execution?

A. Add an event trigger to all four pipelines.
B. Add a schedule trigger to all four pipelines.
C. Create a patient pipeline that contains the four pipelines and use a schedule trigger.
D. Create a patient pipeline that contains the four pipelines and use an event trigger.

Show Suggested Answer

Suggested Answer: C 🗳️

by dpBBC at Dec. 14, 2021, 6:51 p.m.

Comments

Submit Cancel

onyerleft

Highly Voted 3 years, 5 months ago

Selected Answer: C

C is correct, but with poor wording. Should be 'parent pipeline' with a schedule trigger. The parent pipeline has 4 execute pipeline activities. Ingest 1 and Ingest 2 have no dependencies. Dimension pipeline has two dependencies from 'on completion' outputs of both Ingest 1 and Ingest 2 pipelines. Fact pipeline has one 'on completion' dependency on the Dimension pipeline. Absolutely nothing to do with a tumbling window trigger

upvoted 63 times

dsp17

2 years, 11 months ago

Big thanks onyerleft :)

upvoted 2 times

...

Remedios79

2 years, 11 months ago

Thank you. I was wondering about "patient" and related it on my poor english!

upvoted 3 times

...

lukeonline

3 years, 5 months ago

Lol, I searched in the internet for the "patient pipeline".... should have read the comments first :)

upvoted 20 times

...

Vanq69

1 year, 8 months ago

Also looked up "patient pipeline" and was confused xD

upvoted 1 times

...

evangelist

Most Recent 11 months, 1 week ago

Selected Answer: C

patient=>parent

upvoted 2 times

...

phydev

1 year, 7 months ago

Selected Answer: C

Was on my exam today (31.10.2023).

upvoted 2 times

...

kkk5566

1 year, 9 months ago

Selected Answer: C

c is correct

upvoted 1 times

...

steveo123

1 year, 12 months ago

C is correct

upvoted 1 times

...

vigilante89

2 years, 5 months ago

Selected Answer: C

Its not patient pipeline, it should be parent pipeline. Since there are 3 types of triggers in ADF: 1) Schedule Trigger - trigger a pipeline at a fixed hour/minute of the day. 2) Tumbling Window Trigger - trigger a pipeline which usually works for real time data 3) Event-based Trigger - trigger a pipeline incase of an event i.e. new file coming to blob/adls etc. Since the 4 pipelines must be triggered every 8 hrs, then it should be schedule trigger.

upvoted 4 times

...

Deeksha1234

2 years, 10 months ago

right C

upvoted 1 times

...

DrTaz

3 years, 5 months ago

what the hk is a patient pipeline?

upvoted 2 times

anto69

3 years, 4 months ago

lol I think they mean "parent"

upvoted 1 times

...

jv2120

3 years, 5 months ago

It should be tumbling window since 2 dependent pipelines on run state. from given option only schedule event fits but its not correct.

upvoted 3 times

AzureJobsTillRetire

2 years, 6 months ago

If those pipelines finish quickly, schedule trigger should be fine. If there is possibility that those pipelines may run for close to or more than 8 hours, definitely tumbling window should be used instead

upvoted 1 times

...

VJPR

3 years, 6 months ago

Shouldn't the answer be A/D?

upvoted 1 times

TashaP

2 years, 9 months ago

So the question tries to trick you, they don't want to ask about individual pipeline configurations where you need to account for dependencies, they literally want to know how you will schedule the pipelines for execution. The additional information is there to confuse you and make you overthink, focus on the question. In this case, it is C.

upvoted 1 times

...

dpBBC

3 years, 6 months ago

I think it should be Tumbling window

upvoted 2 times

corebit

3 years, 5 months ago

The question or answers do not mention Tumbling Window. What is the basis for the response? Any more context?

upvoted 2 times

...