You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo.
You are experienced in managing databases in an enterprise-level organization,optimizing and sustaining the database life cycle.
In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization.
A SQL Server 2008 infrastructure is managed by you. There are 30 branch offices in DoubleSecurity Insurance,
and in the branch offices, customer data are stored in SQL Server 2008 databases.
Customer data should be security compliant if it is stored through multiple database instances.
You intend to utilize the Policy-Based Management feature to design a strategy for custom policies.
And the format of custom policies is XML format. The requirements listed below should be
satisfied. The company distributes custom policies to all instances.
In addition, the company enforces the policies on all instances.
A strategy should be thought out and the minimum amount of administrative effort should be utilized.
Which action should you perform to finish the task?
A.
To finish the task, the Distributed File System Replication service should be utilized.
B.
To finish the task, a configuration server should be utilized.
C.
To finish the task, the policies should be distributed by utilizing Group Policy Objects.
D.
To finish the task, the policies should be distributed by utilizing the Active Directory directory service.