试题详情
单项选择题You are the administrator of a SQL Server 2005 computer named SQL1. SQL1 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 SQL1. You perform most of the management of SQL1 from your administrative workstation. However, for security reasons, you want to track all attempts for interactive logons and network connections to SQL1. What should you do?()

A、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 SQL1.

B、Configure the SQL Server service on SQL1 to audit all successful and failed logon attempts.

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

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

  • C
  • 关注下方微信公众号,在线模考后查看

热门试题