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.
A and C
Because : Need Standard or Enterprise edition of SQL Server.
Server 4 seems to be an ideal SQL Server instance for CMS as it can be setup on SQL 2008 R2 Express Edition.
As per Microsoft, MSSQL2014 WEB Edition also support policy automation and central management, so B is a candidate as well:
https://msdn.microsoft.com/library/cc645993(v=sql.120).aspx;
However, considering that test and prod environment have to be separate from management perspective, right answers are A&C.