70-465 · Question #11
70-465 Question #11: Real Exam Question with Answer & Explanation
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 Server,
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
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
Community Discussion
No community discussion yet for this question.