DP-200 Exam QuestionsBrowse all questions from this exam

DP-200 Exam - Question 168


HOTSPOT -

You have an Azure data factory that has two pipelines named PipelineA and PipelineB.

PipelineA has four activities as shown in the following exhibit.

Exam DP-200 Question 168

PipelineB has two activities as shown in the following exhibit.

Exam DP-200 Question 168

You create an alert for the data factory that uses Failed pipeline runs metrics for both pipelines and all failure types. The metric has the following settings:

✑ Operator: Greater than

✑ Aggregation type: Total

✑ Threshold value: 2

✑ Aggregation granularity (Period): 5 minutes

✑ Frequency of evaluation: Every 5 minutes

Data Factory monitoring records the failures shown in the following table.

Exam DP-200 Question 168

For each of the following statements, select yes if the statement is true. Otherwise, select no.

NOTE: Each correct answer selection is worth one point.

Hot Area:

Exam DP-200 Question 168
Show Answer
Correct Answer:
Exam DP-200 Question 168

Box 1: No -

Only one failure at this point.

Box 2: No -

Only two failures within 5 minutes.

Box 3: Yes -

More than two (three) failures in 5 minutes

Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/alerts-insights-configure-portal

Discussion

4 comments
Sign in to comment
JaNieWiem
Apr 10, 2021

There is 6 min between 44 and 50 So there shouldn't be any alert.

Wendy_DK
Apr 17, 2021

I agree No for all

maciejt
Jun 4, 2021

No alerts at all. Not only because there is 6 min period, but also failed activity 3 in pipeline A will not cause pipeline to fails and activity 4 has COMPLETED condition, which means previous activity might either suceeed or fail and it still be triggered. Only last activities in the pipeline must have status success or skipped fot pipeline to succeed.

bsa_2021
Jun 21, 2021

Every 5 minutes, it will check. Hence at exactly 10:50 it will check and (may be) the failure of the 2nd pipeline has already logged in by the time the check happens and hence the given answer is correct. Its my analysis and happy to be corrected.

ramelas
Dec 5, 2021

at 10:50 you are in a new window so no, no alerts at all

ramelas
Dec 5, 2021

in dp 300 there is the same question and the provided answers are NO, NO, NO