You work as a database administrator at ABC.com. The ABC.com network contains a SQL Server
2008 computer named ABC-DB01. ABC-DB01 needs the SQL Server service and the SQL Server
Agent service to start automatically. Besides that, it should also audit all user names and
application names that access the system. Auditing should be on always and the result should be
there for 15 years.
What steps should you take? (Choose all that apply.)

A.
By setting the authentication mode to SQL Server and Windows Authentication mode.

B.
By setting the authentication mode to mixed mode.

C.
By creating a SQL Server Agent job for the SQL Audit stored procedure.

D.
By creating a SQL Server Agent job for the SQL Trace stored procedure.

E.
By creating a SQL Server Agent job for the SQL Logging stored procedure.

F.
By disabling the C2 Audit Tracing setting.

G.
By enabling the C2 Audit Tracing setting.

H.
By setting the Login auditing to log all logins as events.

I.
By configuring the job to start when the SQL Server Agent service starts.

J.
By manually starting the job each time you start the server.

Explanation:
To automate administration, follow these steps:
•Establish which administrative tasks or server events occur regularly and whether these tasks or
events can be administered programmatically. A task is a good candidate for automation if it
involves a predictable sequence of steps and occurs at a specific time or in response to a specific
event.
•Define a set of jobs, schedules, alerts, and operators by using SQL Server Management Studio,

Transact-SQL scripts, or SQL Server Management Objects (SMO).
•Run the SQL Server Agent jobs you have defined.
To define your own trace using stored procedures
•Specify the events to capture using sp_trace_setevent.
•Specify any event filters. For more information, see How to: Set a Trace Filter (Transact-SQL).
•Specify the destination for the captured event data using sp_trace_create.