Microsoft
70-465 · Question #11
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…
The correct answer is B. Policy-Based Management. 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…
Submitted by yousef_jo· Mar 5, 2026Design database security solutions
Question
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.
Options
- AMulti server jobs
- BPolicy-Based Management
- CCommon criteria compliance
- DMaintenance plans
How the community answered
(57 responses)- A18% (10)
- B72% (41)
- C7% (4)
- D4% (2)
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.
Topics
#policy-based management#security compliance#multi-server management
Community Discussion
No community discussion yet for this question.