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

Question

You manage 100 Azure SQL managed instances located across 10 Azure regions. You need to receive voice message notifications when a maintenance event affects any of the 10 regions. The solution must minimize administrative effort. What should you do?

Options

• AFrom the Azure portal, create a service health alert.
• BFrom the Azure portal, create an Azure Advisor operational excellence alert.
• CFrom Microsoft SQL Server Management Studio (SSMS), configure a SQL Server agent job.
• DFrom the Azure portal, configure an activity log alert.

Explanation

To receive voice message notifications for Azure SQL managed instance maintenance events across multiple regions with minimal administrative effort, you should use Azure Service Health alerts.

Common mistakes.

• B. Azure Advisor provides recommendations for optimizing Azure resources for cost, security, reliability, operational excellence, and performance, but it does not proactively notify about maintenance events.
• C. SQL Server Agent jobs are used for automating administrative tasks within a SQL Server instance itself and cannot monitor platform-level Azure service health or generate voice notifications.
• D. While activity logs record subscription-level events, Azure Service Health is the dedicated, purpose-built service for proactive notifications about Azure service maintenance and incidents, offering a more direct and less administrative solution for this specific requirement.

Concept tested. Monitoring Azure Service Health for maintenance events

Reference. https://learn.microsoft.com/en-us/azure/service-health/overview

No community discussion yet for this question.