Administering Relational Databases on Microsoft Azure — Question 50

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?

Answer options

• A. From the Azure portal, create a service health alert.
• B. From the Azure portal, create an Azure Advisor operational excellence alert.
• C. From the Azure portal, configure an activity log alert.
• D. From Microsoft SQL Server Management Studio (SSMS), configure a SQL Server agent job.

Correct answer: A

Explanation

Creating a service health alert in the Azure portal will effectively notify you about maintenance events impacting your regions, directly addressing your need for voice message notifications. The other options either do not provide voice notifications, require more administrative effort, or are not suited for monitoring service health specifically.