Administering Relational Databases on Microsoft Azure — Question 5

You have an Azure SQL Database managed instance named SQLMI1. A Microsoft SQL Server Agent job runs on SQLMI1.
You need to ensure that an automatic email notification is sent once the job completes.
What should you include in the solution?

Answer options

• A. From SQL Server Configuration Manager (SSCM), enable SQL Server Agent
• B. From SQL Server Management Studio (SSMS), run sp_set_sqlagent_properties
• C. From SQL Server Management Studio (SSMS), create a Database Mail profile
• D. From the Azure portal, create an Azure Monitor action group that has an Email/SMS/Push/Voice action

Correct answer: C

Explanation

The correct answer is C, as creating a Database Mail profile in SSMS is essential for sending emails from SQL Server Agent jobs. Options A and B do not directly address the requirement for email notifications, while option D is related to monitoring rather than the specific email setup needed for job completion.