Exit 70-447 UPGRADE:MCDBA Skills to MCITP DB Admin by Using MS SQL 2005
Question 1 of 5
0% complete
Q1 Single choice

You are a database administrator for your company. You are responsible for managing 10 SQL Server 2005 computers that run Microsoft Windows Server 2003, Enterprise Edition. The company's Microsoft Active Directory administrators handle all Group Policy object (GPO) deployments. The Active Directory administrators have deployed a security template named SQL05_Security.inf that has the appropriate settings to meet the company's security policy. You need to identify the existing configuration of each SQL Server 2005 computer to ensure that it meets the company's security policy.

What should you do?

  • A

    Use Network Monitor on each SQL Server 2005 computer to capture a detailed report of the types of network traffic on the local network adapter.

  • B

    Use the Performance Logs and Alerts snap-in to create counter logs for the Network Interface performance object.

  • C

    Use the Security Configuration and Analysis tool on each SQL Server 2005 computer to identify discrepancies between system settings and database settings.

  • D

    Use the Security Template snap-in to analyze the SQL05_Security.inf security template.

Previous Next