nerdexam
Microsoft

DP-300 · Question #57

Drag and Drop Question You have SQL Server on an Azure virtual machine named SQL1. SQL1 has an agent job to back up all databases. You add a user named dbadmin1 as a SQL Server Agent operator. You nee

The correct answer is Enable Database Mail; Enable the email settings for the SQL Server Agent; Create a job notification. To send email alerts from SQL Server Agent, you must first enable Database Mail (the email infrastructure in SQL Server), then configure SQL Server Agent to use Database Mail by enabling its email settings. Finally, you create a job notification on the specific job that triggers

Submitted by jaden.t· Mar 6, 2026Implement a secure environment / Monitor and optimize operational resources - specifically configuring SQL Server Agent notifications and Database Mail on SQL Server hosted in Azure VMs (AZ-900 / DP-300 exam domain: Monitor and Optimize Azure SQL resources)

Question

Drag and Drop Question You have SQL Server on an Azure virtual machine named SQL1. SQL1 has an agent job to back up all databases. You add a user named dbadmin1 as a SQL Server Agent operator. You need to ensure that dbadmin1 receives an email alert if a job fails. 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:

Exhibits

DP-300 question #57 exhibit 1
DP-300 question #57 exhibit 2

Answer Area

Drag items

Create a job alertCreate a job notificationEnable Database MailEnable the email settings for the SQL Server AgentCreate a job target

Correct arrangement

  • Enable Database Mail
  • Enable the email settings for the SQL Server Agent
  • Create a job notification

Explanation

To send email alerts from SQL Server Agent, you must first enable Database Mail (the email infrastructure in SQL Server), then configure SQL Server Agent to use Database Mail by enabling its email settings. Finally, you create a job notification on the specific job that triggers an email to the operator (dbadmin1) when the job fails. This three-step sequence establishes the email pipeline from the ground up before linking it to the job.

Topics

#SQL Server Agent#Database Mail#Job Notifications#Azure Virtual Machines

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full DP-300 Practice