Exam DP-200 topic 4 question 28 discussion

Actual exam question from Microsoft's DP-200

Question #: 28
Topic #: 4

You have an alert on a SQL pool in Azure Synapse that uses the signal logic shown in the exhibit.

On the same day, failures occur at the following times:
✑ 08:01
✑ 08:03
✑ 08:04
✑ 08:06
✑ 08:11
✑ 08:16
✑ 08:19
The evaluation period starts on the hour.
At which times will alert notifications be sent?

A. 08:15 only
B. 08:10, 08:15, and 08:20
C. 08:05 and 08:10 only
D. 08:10 only
E. 08:05 only

Show Suggested Answer

Suggested Answer: B 🗳️
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/alerts-insights-configure-portal

by JaNieWiem at April 10, 2021, 11:17 a.m.

Comments

Submit Cancel

JaNieWiem

Highly Voted 4 years, 1 month ago

The aggregation is 15 min so it counts last 15 min and when number of errors is greater then threshold (3) it sends an alert. So the answer is correct

upvoted 11 times

...

Hinzzz

Most Recent 3 years, 11 months ago

Period (the look back window over which metric values are checked): Over the last 15 mins Frequency (the frequency with which the metric alert checks if the conditions are met): 5 min the condition is greater than. so the answer is correct

upvoted 2 times

...

JaNieWiem

4 years, 1 month ago

E: only 8:05 Threshold is 3 so the alert should rise when there are 3 error within 5 min period. Can anyone confirm or explain why it's 8:10,15 and 20?

upvoted 2 times

HarmC

4 years, 1 month ago

threshold 3 means the count should be at least 4. It checks every 5 minutes if in the last 15 minutes the count is greater then 3, therefor the answer is correct.

upvoted 6 times

vrmei

4 years ago

Yes, Count > 3 (means 4,5,6...)

upvoted 2 times

...