PrepAway - Latest Free Exam Questions & Answers

You have a SQL Server 2014 environment That contains 20 servers.

You have a SQL Server 2014 environment That contains 20 servers.

The corporate security policy states that all SQL

Server 2014 instances must meet specific security standards.

You need to recommend a management strategy for the SQL Server 2014 servers.

What should you include in the recommendation? More than one answer choice may achieve the goal. Select the BEST ans

wer.

A. Multi server jobs

B. Policy-Based Management

C. Common criteria compliance

D. Maintenance plans

Explanation:

Policy-Based Management is a system for managing one or more instances of SQL Server. When SQL Server policy administrators use

Policy-Based Management, they use SQL Server Management Studio to create policies to manage entities on the server, such as the instance of SQL Server, databases, or other SQL Server objects.


Leave a Reply