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.)
A.
Server1
B.
Server2
C.
Server3
D.
Seiver4
Explanation:
Need Standard or Enterprise edition of SQL Server.