Discuss Microsoft DP-300 Exam Topic 9 Question 4

You have 50 Azure SQL databases.

You need to notify the database owner when the database settings, such as the database size and pricing tier, are modified in Azure.

What should you do?

ACreate a diagnostic setting for the activity log that has the Security log enabled.

BFor the database, create a diagnostic setting that has the InstanceAndAppAdvanced metric enabled.

CCreate an alert rule that uses a Metric signal type.

DCreate an alert rule that uses an Activity Log signal type.

Suggested Answer: D

Activity log events - An alert can trigger on every event, or, only when a certain number of events occur.

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

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

12 comments · newest first

Luann 12 months ago

I thought A was the right answer at first, but now I’m leaning towards D.

Minna 1 year ago

Totally agree with D! It’s the best choice here.

Hermila 1 year ago

Wait, are we sure D covers all the settings?

Marvel 1 year ago

I think C could work too, but not for settings changes.

Shakira 1 year ago

Option D is the way to go for activity log changes!

Mozelle 1 year ago

I recall that the Activity Log captures changes, so option D sounds right. But I wonder if there's a better way to get notified directly?

Cordell 1 year ago

I'm not entirely sure, but I remember something about diagnostic settings being useful for monitoring changes. Could it be option A or B?

Gail 1 year ago

I think we need to focus on the Activity Log for changes like pricing tiers. So, maybe option D?

Frederick 1 year ago

I practiced a similar question where we had to set alerts for database modifications. I feel like option C might be relevant, but I'm leaning towards D for activity logs.

Delisa 1 year ago

Hmm, I'm a bit unsure about this one. I know it has to do with information security, but I'm not totally clear on the specific risks. I'll have to think it through carefully.

Glenn 1 year ago

Okay, I think I can narrow this down. The sn_compliance_citation and sn_grc_issue tables sound like they could be related to content, so I'll select those.

Lelia 1 year ago

Ugh, I'm really struggling with this question. The manufacturing strategies are tripping me up, and I'm not sure I fully understand the differences between them and how that impacts lead time. I might have to come back to this one and see if I can figure it out with some more thought.

Microsoft DP-300 Exam - Topic 9 Question 4 Discussion