Deal of The Day! 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
8 months ago
I also think option D is the correct one, because it ensures the pipeline runs sequentially.
upvoted 0 times
...
Melissa
8 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
8 months ago
So, do you think option D is the correct configuration for self-dependency?
upvoted 0 times
...
Melissa
8 months ago
I agree, it's important for the pipeline to run smoothly.
upvoted 0 times
...
Ashlyn
8 months ago
I think we should ensure pipeline1 completes successfully first.
upvoted 0 times
...
Marvel
9 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
9 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
10 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
10 months ago
I think the correct option is D) offset: "-01:00:00" size: "01:00:00".
upvoted 0 times
...
Edelmira
11 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
11 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
11 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
11 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
10 months ago
Hmm, I'm not entirely convinced. Could it be another option?
upvoted 0 times
...
Magnolia
10 months ago
D) offset: "-01:00:00" size: "01:00:00"
upvoted 0 times
...
William
10 months ago
I think this might be the correct configuration.
upvoted 0 times
...
Rodney
10 months ago
C) offset: "01:00:00" size: "01:00:00"
upvoted 0 times
...
Nguyet
10 months ago
No, that doesn't seem right. Let's reconsider.
upvoted 0 times
...
Gilberto
10 months ago
B) offset: "01:00:00" size: "-01:00:00"
upvoted 0 times
...
Katie
10 months ago
Wait, are you sure that's the right configuration?
upvoted 0 times
...
Pearly
10 months ago
A) offset: "-00:01:00" size: "00:01:00"
upvoted 0 times
...
...

Save Cancel