nerdexam
Microsoft

DP-300 · Question #293

Drag and Drop Question You create a new Azure SQL managed instance named SQL1 and enable Database Mail extended stored procedures. You need to ensure that SQL Server Agent jobs running on SQL1 can not

Sign in or unlock DP-300 to reveal the answer and full explanation for question #293. The question stem and answer options stay visible for context.

Submitted by neha2k· Mar 6, 2026Implement and Manage a Relational Database Environment / Configure Azure SQL Managed Instance / Automate database tasks and configure alerting

Question

Drag and Drop Question You create a new Azure SQL managed instance named SQL1 and enable Database Mail extended stored procedures. You need to ensure that SQL Server Agent jobs running on SQL1 can notify administrators when a failure occurs. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Answer:

Exhibit

DP-300 question #293 exhibit

Answer Area

Drag items

Create a Database Mail account.Create a profile named AzureManagedInstance_dbmail_profile.Create a profile named application_dbmail_profile.Enable email notifications upon failure.Enable pager notifications upon failure.

Unlock DP-300 to see the answer

You've previewed enough free DP-300 questions. Unlock DP-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Azure SQL Managed Instance#Database Mail#SQL Server Agent#Job Notifications
Full DP-300 Practice