PrepAway - Latest Free Exam Questions & Answers

You need to recommend a management strategy for the SQL…

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

PrepAway - Latest Free Exam Questions & Answers

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.

Policy-Based Management How-to Topics


Leave a Reply