Exam 70-465 topic 1 question 9 discussion

Actual exam question from Microsoft's 70-465

Question #: 9
Topic #: 1

You have an 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.)

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

Show Suggested Answer

Suggested Answer: DE 🗳️
Use a trigger that starts a job which executes the application.
Reference: http://technet.microsoft.com/en-us/library/hh849759.aspx

by AlexandreVM at March 3, 2020, 6:07 p.m.