You are managing a SQL Server 2008 computer called SQLTEST1. You should configure
the SQL Server service and the SQL Server Agent service to start automatically, and set
SQLTEST1 to audit all user names and application names that plan to get information from
SQLTEST1. SQLTEST1 must operate auditing always, and you should keep the results for
10 years. Which is the correct answer?
A.
You should disable the C2 Audit Tracing setting on the server properties.
B.
You should 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.
C.
You should set the Login auditing setting to both failed and successful logins
D.
You should configure the server authentication mode as SQL Server and Windows
Authentication mode.