You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer. Your company’s database auditing department must receive an e-mail message when the SQL Server service and the SQL Server Agent service are started, stopped, or paused. They also need to receive an e-mail message when the EXECUTE AS option is used with stored procedures and other commands. You need to ensure that the auditing department receives the e-mail messages that they need. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
A.
Create an Event Notification on the Audit Server Starts and Stops event class.
B.
Use SQL Server Profiler to track the Audit Statement Permission event class.
C.
Create a Windows Group Policy Object to audit System Events.
D.
Use SQL Server Profiler to track the Audit Server Starts and Stops event class.
E.
Create an Event Notification on the Audit Server Principal Impersonation event class.
F.
Use SQL Server Profiler to track the Audit Server Principal Impersonation event class.
Explanation:
The Audit Server Principal Impersonation event class occurs when there is an impersonation within server scope, such as execute as login. The Audit Server Starts and Stops event class occurs when the Microsoft SQL Server service state is modified.