Which server should you recommend?

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.)

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *