ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-764 All Questions

View all questions & answers for the 70-764 exam
Go to Exam

Exam 70-764 topic 1 question 165 discussion

Actual exam question from Microsoft's 70-764
Question #: 165
Topic #: 1
[All 70-764 Questions]

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 Hide 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

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
MSSucks
Highly Voted 5 years, 2 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 4 years, 10 months ago
There are 3 types of triggers. DDL , DML & Logon. How these scope applies on this scenario??
upvoted 1 times
V_karag
4 years, 10 months 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, 5 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, 3 months ago
Triggers are created on the table level.
upvoted 1 times
...
TheSwedishGuy
5 years, 3 months ago
The trigger executes the job which is specified to launch an application. Interesting..
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago