Cyber Monday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam DP-203 Topic 7 Question 83 Discussion

Actual exam question for Microsoft's DP-203 exam
Question #: 83
Topic #: 7
[All DP-203 Questions]

You have an Azure Data Factory pipeline named pipeline1 that is invoked by a tumbling window trigger named Trigger1. Trigger1 has a recurrence of 60 minutes.

You need to ensure that pipeline1 will execute only if the previous execution completes successfully.

How should you configure the self-dependency for Trigger1?

Show Suggested Answer Hide Answer
Suggested Answer: D

Tumbling window self-dependency properties

In scenarios where the trigger shouldn't proceed to the next window until the preceding window is successfully completed, build a self-dependency. A self-dependency trigger that's dependent on the success of earlier runs of itself within the preceding hour will have the properties indicated in the following code.

Example code:

'name': 'DemoSelfDependency',

'properties': {

'runtimeState': 'Started',

'pipeline': {

'pipelineReference': {

'referenceName': 'Demo',

'type': 'PipelineReference'

}

},

'type': 'TumblingWindowTrigger',

'typeProperties': {

'frequency': 'Hour',

'interval': 1,

'startTime': '2018-10-04T00:00:00Z',

'delay': '00:01:00',

'maxConcurrency': 50,

'retryPolicy': {

'intervalInSeconds': 30

},

'dependsOn': [

{

'type': 'SelfDependencyTumblingWindowTriggerReference',

'size': '01:00:00',

'offset': '-01:00:00'

}

]

}

}

}


Contribute your Thoughts:

Jeanice
5 months ago
I also think option D is the correct one, because it ensures the pipeline runs sequentially.
upvoted 0 times
...
Melissa
5 months ago
Yes, I believe offset of -01:00:00 means it waits for the previous execution to finish before starting.
upvoted 0 times
...
Ashlyn
5 months ago
So, do you think option D is the correct configuration for self-dependency?
upvoted 0 times
...
Melissa
5 months ago
I agree, it's important for the pipeline to run smoothly.
upvoted 0 times
...
Ashlyn
5 months ago
I think we should ensure pipeline1 completes successfully first.
upvoted 0 times
...
Marvel
6 months ago
That's true, but the question specifically asks for the pipeline to execute only if the previous execution completes successfully. So, a negative offset is needed.
upvoted 0 times
...
Ettie
6 months ago
But wouldn't a positive offset ensure that the trigger starts exactly after the completion time of the previous execution?
upvoted 0 times
...
Glory
7 months ago
I agree with Marvel. Having a negative offset ensures the trigger waits for the previous execution to complete successfully.
upvoted 0 times
...
Marvel
7 months ago
I think the correct option is D) offset: "-01:00:00" size: "01:00:00".
upvoted 0 times
...
Edelmira
8 months ago
Haha, I can see the confusion here. These time offsets are no joke! If we want to wait for the previous execution to complete, we need a negative offset. I'd go with option D as well.
upvoted 0 times
...
Dante
8 months ago
Hmm, I'm not sure about that. Shouldn't we be looking at a negative offset to ensure that the next execution doesn't start until the previous one has finished? I'm thinking option D might be the way to go.
upvoted 0 times
...
Maurine
8 months ago
Yeah, that makes sense. I'm leaning towards option C - offset: "01:00:00" size: "01:00:00". That way, the trigger will only fire after the previous execution has completed, and the pipeline will run as expected.
upvoted 0 times
...
Lamonica
8 months ago
Okay, let's think this through. We need to ensure that pipeline1 only runs if the previous execution completes successfully. That means we need to configure the self-dependency for Trigger1 correctly.
upvoted 0 times
Annita
7 months ago
Hmm, I'm not entirely convinced. Could it be another option?
upvoted 0 times
...
Magnolia
7 months ago
D) offset: "-01:00:00" size: "01:00:00"
upvoted 0 times
...
William
7 months ago
I think this might be the correct configuration.
upvoted 0 times
...
Rodney
7 months ago
C) offset: "01:00:00" size: "01:00:00"
upvoted 0 times
...
Nguyet
7 months ago
No, that doesn't seem right. Let's reconsider.
upvoted 0 times
...
Gilberto
7 months ago
B) offset: "01:00:00" size: "-01:00:00"
upvoted 0 times
...
Katie
7 months ago
Wait, are you sure that's the right configuration?
upvoted 0 times
...
Pearly
8 months ago
A) offset: "-00:01:00" size: "00:01:00"
upvoted 0 times
...
...

Save Cancel