You are a professional level SQL Sever 2008 Database Administrator. 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, a configuration server should be utilized.
B.
To finish the task, the policies should be distributed by utilizing Group Policy Objects.
C.
To finish the task, the policies should be distributed by utilizing the Active Directory
directory service.
D.
To finish the task, the Distributed File System Replication service should be utilized.
Explanation: