exam questions

Exam DP-200 All Questions

View all questions & answers for the DP-200 exam

Exam DP-200 topic 4 question 30 discussion

Actual exam question from Microsoft's DP-200
Question #: 30
Topic #: 4
[All DP-200 Questions]

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.

PipelineB has two activities as shown in the following exhibit.

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.

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:

Show Suggested Answer Hide Answer
Suggested Answer:
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

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
JaNieWiem
Highly Voted 4 years, 1 month ago
There is 6 min between 44 and 50 So there shouldn't be any alert.
upvoted 27 times
...
Wendy_DK
Highly Voted 4 years, 1 month ago
I agree No for all
upvoted 6 times
...
bsa_2021
Most Recent 3 years, 11 months ago
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.
upvoted 1 times
ramelas
3 years, 6 months ago
at 10:50 you are in a new window so no, no alerts at all
upvoted 1 times
...
ramelas
3 years, 6 months ago
in dp 300 there is the same question and the provided answers are NO, NO, NO
upvoted 1 times
...
...
maciejt
4 years ago
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.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...