Administering a SQL Database Infrastructure — Question 54

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?

Answer options

• 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.

Correct answer: A

Explanation

The correct answer is A because configuring an alert will notify the system when the specific event occurs, and a job can be set to run the application in response to that alert. Options B and C include maintenance plans, which are not relevant for executing applications based on event logs. Option D incorrectly suggests using a trigger, which is not needed in this scenario, and option E mixes an alert with a trigger, which doesn't fulfill the requirement to run an application.