nerdexam
Microsoft

70-450 · Question #66

70-450 Question #66: Real Exam Question with Answer & Explanation

The correct answer is B. To finish the task, a configuration server should be utilized.. Configuration Server or Central Management Server In SOL Server 2008, you can designate an instance ot SQL Server as a Central Management Server. Central Management Servers store a list of instances of SOL Server that is organized into one or more Central Management Server groups

Question

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?

Options

  • ATo finish the task, the Distributed File System Replication service should be utilized.
  • BTo finish the task, a configuration server should be utilized.
  • CTo finish the task, the policies should be distributed by utilizing Group Policy Objects.
  • DTo finish the task, the policies should be distributed by utilizing the Active Directory directory

Explanation

Configuration Server or Central Management Server In SOL Server 2008, you can designate an instance ot SQL Server as a Central Management Server. Central Management Servers store a list of instances of SOL Server that is organized into one or more Central Management Server groups. Actions that are taken by using a Central Management Server group will act on all servers in the server group. This includes connecting to servers by using Object Explorer and executing Transact-SOL statements and Policy-Based Management policies on multiple servers at the same time. All Central Management Servers and subordinate servers must be registered by using Windows Authentication. Versions ot SOL Server that are earlier than SOL Server 2008 cannot be designated as a Central Management

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-450 Practice