nerdexam
Microsoft

DP-300 · Question #180

Drag and Drop Question You have an Azure subscription that contains an Azure SQL managed instance named SQLMi1 and a SQL Agent job named Backupdb. Backupdb performs a daily backup of the databases…

The correct answer is Enable Database Mail.; Create an operator.; Add a failure notification to the job. To receive email notifications for SQL Agent job failures, you must first Enable Database Mail so that SQL Server has an email delivery mechanism configured. Next, you Create an Operator, which defines the recipient (email address) that will receive the notifications. Finally…

Submitted by brentm· Mar 6, 2026Monitor and optimize operational resources in Azure SQL - specifically configuring SQL Agent job alerts and notifications within Azure SQL Managed Instance (DP-300: Administering Microsoft Azure SQL Solutions)

Question

Drag and Drop Question You have an Azure subscription that contains an Azure SQL managed instance named SQLMi1 and a SQL Agent job named Backupdb. Backupdb performs a daily backup of the databases hosted on SQLMi1. You need to be notified by email if the 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. NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select. Answer:

Exhibit

DP-300 question #180 exhibit

Answer Area

Drag items

Create a SQL Server Agent alert.Create an operator.Create an extended event.Enable Database Mail.Add a failure notification to the job.

Correct arrangement

  • Enable Database Mail.
  • Create an operator.
  • Add a failure notification to the job.

Explanation

To receive email notifications for SQL Agent job failures, you must first Enable Database Mail so that SQL Server has an email delivery mechanism configured. Next, you Create an Operator, which defines the recipient (email address) that will receive the notifications. Finally, you Add a failure notification to the job, which links the operator to the specific job (Backupdb) so that when it fails, the operator is emailed automatically. This three-step sequence is the standard workflow for job failure alerting in SQL Server Agent.

Topics

#Azure SQL Managed Instance#SQL Server Agent#Database Mail#Job Notifications

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full DP-300 Practice