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.
0
0
Server 4 seems to be an ideal SQL Server instance for CMS as it can be setup on SQL 2008 R2 Express Edition.
0
0
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.
0
0