PrepAway - Latest Free Exam Questions & Answers

What should you do?

You work as a database administrator at Domain.com. The Domain.com network contains a
SQL Server 2008 computer named CERTKILLER-DB01. CERTKILLER-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 about a decade.

What should you do? (Choose TWO.)

PrepAway - Latest Free Exam Questions & Answers

A.
You should consider setting the authentication mode to SQL Server and Windows Authentication mode.

B.
You should consider create a SQL Server Agent job for the SQL Trace stored procedure.

C.
You should consider disabling the C2 Audit Tracing setting.

D.
You should consider configuring the job to start when the SQL Server Agent service starts.

E.
You should consider setting the Login auditing to log all logins as events.


Leave a Reply