Term
| what is an extensible and scalable configuration framework used to manage servers? |
|
Definition
|
|
Term
| True or False, Policy Based Management can be Applied to servers, Databases and other Objects |
|
Definition
|
|
Term
| True or False, Policy Based Management Help you control and manage the configuration of data services throughout the enterprise |
|
Definition
|
|
Term
| True or False, Policy Based Management allows you to prevent changes that deviate from the specified configurations |
|
Definition
|
|
Term
| True or False, Policy Based Management CANNOT be scaled across multiple servers for consistent configuration enforcement |
|
Definition
| False, it can be scaled across multiple servers |
|
|
Term
|
Definition
| the core objects on which standards are built. They define the type of object or option to be checked. |
|
|
Term
| how many facets does SQL server ship with? |
|
Definition
|
|
Term
| where are the objects for Policy Based Management stored? |
|
Definition
|
|
Term
| what is the equivalent of a WHERE clause in a DML statement? |
|
Definition
|
|
Term
| how can you define conditions to be checked or enforced? |
|
Definition
| by defining criteria for the properties of a facet, using one or more facet properties |
|
|
Term
| true or false, a condition can only be defined by one facet property that can be checked for multiple criteria |
|
Definition
| false, it can be defined by one or more facet properties, each facet property can be checked for multiple criteria |
|
|
Term
| true or false, a single condition can be defined for multiple facets |
|
Definition
| false, a single condition cannot be defined for multiple facets |
|
|
Term
| comparison operators are used to build ________ |
|
Definition
|
|
Term
| complex conditions can be defined using what? |
|
Definition
|
|
Term
| what kind of values must a condition return? |
|
Definition
|
|
Term
| what are the 4 properties of a condition? |
|
Definition
1. Name
2. Facet
3. Expression
4. Description |
|
|
Term
| what is used to specify the objects to compare the condition against? |
|
Definition
|
|
Term
| true or false, Policy Targets cannot target a policy at the server level, such as instances of SQL Server 2008 |
|
Definition
| false, they can target a policy at the server level |
|
|
Term
| true or false, Policy Targets, can target a policy at the database level, such as all user databases or all system databases |
|
Definition
|
|
Term
| regarding Policy Targets, what targets can you use? |
|
Definition
1. server instances
2. databases
3. tables
4. indexes
5. logins & database users
6. audit objects
7. linked servers
8. triggers
9. Resource Governor and its objects
10. schemas |
|
|
Term
| what can be created for a single condition and are set to either enforce or check compliance? |
|
Definition
|
|
Term
| what are the execution modes available? |
|
Definition
On Demand
On Change: Log Only
On Change: Prevent
On Schedule |
|
|
Term
| if a policy was created using a condition that was defined with the advanced editor, what is the only execution mode that's available? |
|
Definition
|
|
Term
| what policy, evaluates the policy only when you directly execute the policy (also called ad hoc policy evaluation) |
|
Definition
|
|
Term
| what policy, evaluates a policy when a relevant change is made; logs policy violations in event logs? |
|
Definition
|
|
Term
| what policy, when nested triggers are enabled uses DDL triggers to prevent policy violations by detecting changes that violate policy and rolling them back? |
|
Definition
|
|
Term
| what policy, uses SQL Server Agent jobs to periodically evaluate policies; logs violations in event logs; generates a report |
|
Definition
|
|
Term
| One Change: Prevent mode can only be used when? |
|
Definition
| only when it is possible for a DDL trigger to prevent the change |
|
|
Term
| A policy includes these properties |
|
Definition
1. Name
2. Enabled
3. Check condition
4. Targets
5. Evaluation mode
6. Server restriction
7. Category
8. Description
9. Additional Help Hyperlink |
|
|
Term
| what can be used to group one or more policies into a single compliance unit? |
|
Definition
|
|
Term
| if not specified, all policies belong to what category? |
|
Definition
|
|
Term
| to check or enforce policies, you create a ___________ to one or more policies |
|
Definition
|
|
Term
| at what levels does a subscription occur? |
|
Definition
| instance and database level |
|
|
Term
| when a policy category is set to ______, and the instance is subscribed to the category, all databases that meet the target are controlled by the policies within the policy category. |
|
Definition
|
|
Term
| Policies that cannot be set to enforce compliance must be checked ________ |
|
Definition
|
|
Term
| how can you check Policy Compliance manually? |
|
Definition
| Right-click Object Explorer, select Policies, then View. Right-click the instance name and select Policies, then Evaluate to execute the policies |
|
|
Term
| what can you configure to allow you to manage multiple instances of SQL Server |
|
Definition
| Central Management Server |
|
|
Term
| true or false, once set up, you can evaluate policies against a specific instance, folder or all instances underneath the Central Management Server |
|
Definition
|
|
Term
| true or false, policies and conditions cannot be exported to files and imported from files. |
|
Definition
|
|
Term
| True or False, if you import from the Central Management Server, the policies are imported to every instance defined underneath the Central Management Server, and to the Central Management Server itself |
|
Definition
| false, the policies are not imported to the Central Mangement Server itself. |
|
|
