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.