Lesson 1: Designing Policies
Quick Check
1. What are the fi ve objects that are used within Policy Based Management?
2. What are the allowed execution modes for a policy?
3. Which object has a property that allows you to mandate checking for all databases on an instance?
4. How many facets can be checked within a single condition?
5. How many conditions can be checked within a single policy?
Quick Check Answers
1. The objects that are used with Policy Based Management are facets, conditions, policies, policy targets, and policy categories.
2. The policy execution modes are On demand, On schedule, On change, Log only, and On change, prevent.
3. Policy categories allow you to mandate checking of all databases within an instance.
4. A condition can be defi ned on only one facet.
5. A policy can check only a single condition.
Lesson Summary
You can build policies to enforce conditions across any version of SQL Server.
Policies can enforce a single condition and each condition can be based on a single facet.
Policy categories allow you to group policies together for compliance checking.
A policy category can be set with the Mandate property, which requires the policy to be checked against all databases within an instance.
