You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKingA. The SQL Server service and the SQL Server Agent service are configured to start automatically. You need to configure AIOTestKing A to audit all user names and application names that attempt to access information from AIOTestKingA. AIOTestKing A must perform auditing at all times, and the results must be kept for 10 years. What should you do?

A.
Create a SQL Server Agent job to run the SQL Trace stored procedure. Configure the job to start when the SQL Server Agent service starts.

B.
Set the Login auditing setting to Both failed and successful logins.

C.
Disable the C2 Audit Tracing setting on the server properties.

D.
Configure the server authentication mode as SQL Server and Windows Authentication mode.

Explanation:
Microsoft SQL Server provides Transact-SQL system stored procedures to create traces on an instance of the SQL Server Database Engine. These system stored procedures can be used from within your own applications to create traces manually, instead of using SQL Server Profiler. To ensure that the trace is always running start the trace as a SQL Server Agent job configured to start when SQL Server Agent start (which should be when the operative system starts)