PrepAway - Latest Free Exam Questions & Answers

What should you do?

You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKing A. AIOTestKing A is a member of a Microsoft Active Directory domain. You do not have any rights or privileges to perform domain administration. However, you have been granted membership in the local Administrators group on AIOTestKing A. You perform most of the management of AIOTestKing A from your administrative workstation. However, for security reasons, you want to track all attempts for interactive logons and network connections to AIOTestKing A. What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Configure the SQL Server service on AIOTestKing A to audit all successful and failed logon attempts.

B.
Run the SQL Server Profiler and use a standard default template.

C.
Edit the local security policy of AIOTestKing A. Then, configure success and failure auditing on the Audit logon events setting.

D.
Create a Group Policy object (GPO) that is configured for success and failure auditing of the Audit account logon events setting. Ask the domain administrator to link the GPO to the object containing AIOTestKing A.


Leave a Reply