Microsoft Certified Azure Database Administrator Associate · Free Practice Question Medium
Question 9
You have just configured a regular maintenance job using SQL Server Agent. To ensure smooth operations, you want to be notified if the job fails. Which of the following steps should you take?
- A Create an Operator with the desired contact details.
- B Use Azure Logic Apps to monitor the job status.
- C Configure Notifications on the job to alert the Operator upon failure.
- D Configure the SQL Server Audit feature for notifications.
Reveal correct answers
Correct answers: A, C
Explanation
An operator in SQL Server Agent defines contact information for an individual responsible for the maintenance of one or more instances of SQL Server. You can then configure the job to notify the operator in case of failures. Reference: https://docs.microsoft.com/en-us/sql/ssms/agent/create-a-job?view=sql-server-ver15Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
