DP-300 Certification Practice Question #195

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.
Select and Place:

Accepted Answer

The question states the operator (dbadmin1) is already created. The three remaining steps needed are: (1) **Enable Database Mail** — the prerequisite mail subsystem in SQL Server; (2) **Enable the email settings for the SQL Server Agent** — configure SQL Agent to use a Database Mail profile; (3) **Create a job notification** — configure the job to send email to the operator on failure. The overwhelming community consensus (42+20+12+9+3+3 upvotes) agrees on C→D→B. The minority suggestion of A-D-B is discounted because "Create a job alert" is a different concept from job notifications.

More DP-300 practice questions