Administering a SQL Database Infrastructure — Question 241

You have a SQL Server 2014 instance named SQL1. SQL1 creates error events in the Windows Application event log.
You need to recommend a solution that will run an application when SQL1 logs a specific error in the Application log.
Which SQL elements should you include in the recommendation? (Each correct answer presents part of the solution. Choose all that apply.)

Answer options

• A. A policy
• B. A maintenance plan
• C. An alert
• D. A job
• E. A trigger

Correct answer: D, E

Explanation

The correct components for this solution are a job and a trigger. A job can execute a specific task when certain conditions are met, while a trigger can respond to events such as error logging. The other options, such as a policy, maintenance plan, and alert, do not directly facilitate running an application based on error logs.