Examice

Exam DP-203 All QuestionsBrowse all questions from this exam

Question 159

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?

Add an event trigger to all four pipelines.

Add a schedule trigger to all four pipelines.

Create a patient pipeline that contains the four pipelines and use a schedule trigger.

Create a patient pipeline that contains the four pipelines and use an event trigger.

Correct Answer: C

To schedule the execution of Azure Data Factory pipelines with dependencies, you should create a parent pipeline that contains the four pipelines and use a schedule trigger. This method allows you to control the order of execution by defining dependencies within the parent pipeline. The 'Ingest Data from System1' and 'Ingest Data from System2' pipelines can run independently, and once they complete, the 'Populate Dimensions' pipeline can execute. Finally, the 'Populate Facts' pipeline will run after the 'Populate Dimensions' pipeline completes. Scheduling the parent pipeline every eight hours ensures that all child pipelines run in the correct order and at the specified interval.

Discussion

onyerleftOption: 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

lukeonline

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

Remedios79

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

dsp17

Big thanks onyerleft :)

Vanq69

Also looked up "patient pipeline" and was confused xD

vigilante89Option: 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.

jv2120Option: B

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

AzureJobsTillRetire

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

phydevOption: C

Was on my exam today (31.10.2023).

DrTaz

what the hk is a patient pipeline?

anto69

lol I think they mean "parent"

dpBBC

I think it should be Tumbling window

corebit

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

evangelistOption: C

patient=>parent

kkk5566Option: C

c is correct

steveo123Option: C

C is correct

Deeksha1234Option: C

right C

VJPR

Shouldn't the answer be A/D?

TashaP

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.