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.
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.
B
Common criteria compliance, being an international computer security standard, is an advanced feature that can be easily enabled. If these SQL instances are all on Enterprise edition, CCC could be the best solution here.
Policy-Management can be used to accomplish this but then it’s hard work to define the conditions and policies and potentially the need for a Central Management Server.
I’d go with PBM just because CCC is so poorly documented.