Exam 70-764 topic 1 question 165 discussion

Actual exam question from Microsoft's 70-764

Question #: 165
Topic #: 1

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

Show Suggested Answer

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

by TheSwedishGuy at Jan. 29, 2020, 3 p.m.

Comments

Submit Cancel

MSSucks

Highly Voted 5 years, 5 months ago

I also doubt that. However an alert is able to listen for event log entries and launch a job. And a job is able to launch an application by doing CmdExec. So I think the correct answers are more likely: C. An alert D. A job

upvoted 6 times

...

V_karag

Most Recent 5 years, 1 month ago

There are 3 types of triggers. DDL , DML & Logon. How these scope applies on this scenario??

upvoted 1 times

V_karag

5 years ago

Finally the answer is right. We can call a command with xp_cmdshell via a trigger. https://social.msdn.microsoft.com/Forums/sqlserver/en-US/688ec345-813e-4028-a7b1-1839e4af9d7b/call-a-dll-or-exe-file-from-sql-trigger?forum=sqlnetfx

upvoted 2 times

huzein

4 years, 8 months ago

yes, you can run an app from a trigger but how and when you raise that trigger? i think the alert is correct and from the alert you can a job. so i vote for CD.

upvoted 1 times

...

TheSwedishGuy

5 years, 6 months ago

Triggers are created on the table level.

upvoted 1 times

...

TheSwedishGuy

5 years, 6 months ago

The trigger executes the job which is specified to launch an application. Interesting..

upvoted 1 times

...