70-450 · Question #13
You administer a SQL Server 2008 infrastructure. Humongous Insurance has 20 branch offices that store customer data in SQL Server 2008 databases. Customer data that is stored across multiple…
The correct answer is A. Use a configuration server. Configuration servers are the original name for central management servers, which allow the administration and enforcement of SQL Server 2008 policies for multiple servers to be
Question
You administer a SQL Server 2008 infrastructure. Humongous Insurance has 20 branch offices that store customer data in SQL Server 2008 databases. Customer data that is stored across multiple database instances has to be security compliant. You plan to design a strategy for custom policies by using the Policy-Based Management feature. Custom policies are in XML format. The strategy must meet the following requirements:
- Custom policies are distributed to all instances.
- The policies are enforced on all instances.
You need to implement the strategy by using the least amount of administrative effort. What should you do?
Options
- AUse a configuration server.
- BUse the Distributed File System Replication service.
- CDistribute the policies by using Group Policy Objects.
- DDistribute the policies by using the Active Directory directory service
How the community answered
(45 responses)- A84% (38)
- B2% (1)
- C4% (2)
- D9% (4)
Explanation
Configuration servers are the original name for central management servers, which allow the administration and enforcement of SQL Server 2008 policies for multiple servers to be
Topics
Community Discussion
No community discussion yet for this question.