Exam 70-764 topic 1 question 259 discussion

Actual exam question from Microsoft's 70-764

Question #: 259
Topic #: 1

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

Show Suggested Answer

Suggested Answer: AC 🗳️
Need Standard or Enterprise edition of SQL Server.

by TheSwedishGuy at Jan. 31, 2020, 5:18 p.m.

Comments

Submit Cancel

strider500

4 years, 5 months ago

I think correct answer is B and D, Central Management Server cannot be a member of a group that it maintains. https://docs.microsoft.com/en-us/sql/relational-databases/administer-multiple-servers-using-central-management-servers?view=sql-server-2016 Editions features https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2016?view=sql-server-ver15

upvoted 1 times

...

strider500

4 years, 5 months ago

Note that the Central Management Server cannot be a member of a group that it maintains.

upvoted 1 times

...

TheSwedishGuy

5 years, 3 months ago

Central Management Server (CMS) requires standard or enterprise.

upvoted 1 times

...

Exam 70-764 All Questions

View all questions & answers for the 70-764 exam

Exam 70-764 topic 1 question 259 discussion

Comments

strider500

strider500

TheSwedishGuy

SY0-701