Which SQL elements should you include in the recommendation?

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.)
A . A policy
B . A maintenance plan
C . An alert
D . A job
E . A trigger

Answer: DE

Explanation:

Use a trigger that starts a job which executes the application.

References: http://technet.microsoft.com/en-us/library/hh849759.aspx

Latest 70-764 Dumps Valid Version with 451 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>