nerdexam
MicrosoftMicrosoft

DP-300 · Question #74

DP-300 Question #74: Real Exam Question with Answer & Explanation

The correct answer is D: Create an alert rule that uses an Activity Log signal type.. Activity log events - An alert can trigger on every event, or, only when a certain number of events Incorrect Answers: C: Metric values - The alert triggers when the value of a specified metric crosses a threshold you assign in either direction. That is, it triggers both when the

Submitted by mateo_ar· Mar 6, 2026Monitor, configure, and optimize database resources

Question

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?

Options

  • 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.

Explanation

Activity log events - An alert can trigger on every event, or, only when a certain number of events Incorrect Answers: C: Metric values - The alert triggers when the value of a specified metric crosses a threshold you assign in either direction. That is, it triggers both when the condition is first met and then afterwards when that condition is no longer being met. https://docs.microsoft.com/en-us/azure/azure-sql/database/alerts-insights-configure-portal

Community Discussion

No community discussion yet for this question.

Full DP-300 PracticeBrowse All DP-300 Questions