nerdexam
Microsoft

70-465 · Question #131

You have a SQL Server 2014 environment That includes four servers. The servers are configured as shown in the following table. You plan to configure Policy-Based Management to enforce the following…

The correct answer is A. Server1 C. Server3. The question asks which servers can serve as a Central Management Server (CMS) for Policy-Based Management, given that policies must be enforced on Server1 and Server3 with specific rules involving on-demand evaluation modes.

Submitted by luis.pe· Mar 5, 2026Design and implement database solutions for SQL Server

Question

You have a SQL Server 2014 environment That includes four servers. The servers are configured as shown in the following table. You plan to configure Policy-Based Management to enforce the following rules: - On Server1, enable SQL Server password policies and enable the default trace. - On Server3, ensure that the names of user-defined stored procedures begin with the prefix "usp_" and ensure that all databases use a case- sensitive collation. You need to recommend which server you must configure as a Central Management Server. Which server should you recommend? (Each correct answer presents a complete solution. Choose all that apply.)

Exhibit

70-465 question #131 exhibit

Options

  • AServer1
  • BServer2
  • CServer3
  • DSeiver4

How the community answered

(24 responses)
  • A
    88% (21)
  • B
    4% (1)
  • D
    8% (2)

Why each option

The question asks which servers can serve as a Central Management Server (CMS) for Policy-Based Management, given that policies must be enforced on Server1 and Server3 with specific rules involving on-demand evaluation modes.

AServer1Correct

Server1 can be configured as a Central Management Server because a CMS can manage policies for itself and other registered servers. The policies for Server1 (password policies and default trace) and Server3 (stored procedure naming and collation) can all be evaluated on demand or on schedule from Server1.

BServer2

Server2 is running SQL Server 2008 R2, which does not support all the Policy-Based Management features needed to serve as a Central Management Server for evaluating policies against SQL Server 2014 instances in this scenario.

CServer3Correct

Server3 can also serve as the Central Management Server, as it can register and evaluate policies against both itself and Server1. The policies specified (naming conventions, collation checks, password policies, default trace) use on-demand or on-schedule evaluation modes that work across registered servers via a CMS.

DSeiver4

Server4 is running SQL Server 2008, which is an older version that lacks full Central Management Server capabilities required to evaluate and enforce Policy-Based Management policies against the SQL Server 2014 instances in this environment.

Concept tested: Central Management Server and Policy-Based Management in SQL Server

Source: https://learn.microsoft.com/en-us/sql/relational-databases/policy-based-management/administer-servers-by-using-policy-based-management

Topics

#Policy-Based Management#Central Management Server#SQL Server configuration#password policies

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-465 Practice