PrepAway - Latest Free Exam Questions & Answers

You have a SQL Server 2014 environment That includes four servers.

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 casesensitive 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