Microsoft Discussions

Exam 70-764 All Questions

View all questions & answers for the 70-764 exam

Go to Exam

Exam 70-764 topic 1 question 242 discussion

Actual exam question from Microsoft's 70-764

Question #: 242
Topic #: 1

[All 70-764 Questions]

You work as a Database Administrator (DBA) for a company named ABC.com.
The company uses a Microsoft SQL Server 2012 infrastructure. Computer users use custom applications that store data in SQL Server databases hosted on a server named ABC-SQL1.
You discover that the Windows Application event log on ABC-SQL1 contains error events.
You need to configure a solution that will run an application whenever an event with a specific event ID number is generated in the Windows Application event log.
What should you configure?

A. You should configure an alert and a job.
B. You should configure an alert and a maintenance plan.
C. You should configure a trigger and a maintenance plan.
D. You should configure a trigger and a job.
E. You should configure an alert and a trigger.

Show Suggested Answer

Suggested Answer: A 🗳️

by gdv at Jan. 14, 2020, 6:21 a.m.

Comments

Submit Cancel

jolsca

4 years, 9 months ago

Coorecto is A, when you create an alert you have the option to run job if you want

upvoted 2 times

...

TheSwedishGuy

5 years, 4 months ago

Raise an alert once the error occurs, and configure the alert to start the job once the alert is raised.

upvoted 2 times

TheSwedishGuy

5 years, 3 months ago

Alerts read from the Windows application log. https://docs.microsoft.com/en-us/sql/ssms/agent/alerts?view=sql-server-ver15

upvoted 2 times

...

...

gdv

5 years, 5 months ago

I think it should be D. Configure a trigger and a job

upvoted 2 times

...