You are the SQL administrator of your company. The network contains an instance of SQL Server 2008.
You arein the process of creating a Policy-Based Management policy on the SQL server to ensure that SQL logins arecreated using a certain naming convention.
You want to ensure that the policy is automated and not violated. Which evaluation mode should you configure for the policy?
A.
On demand
B.
On schedule
C.
On change: log only
D.
On change: prevent
Explanation:
You should configure the On change: prevent evaluation mode for the policy. Policy-Based Management is usedto manage entities on an SQL Server 2008 instance. To create Policy-Based Management policies, you shouldfirst select a facet that contains the properties that you want to configure. Facets are SQL Server entities in whichone or more related configuration options are defined. You should then define a condition that defines the state ofthe facet. Then, you should specify the target, such as servers, databases, or logins, to which the policy should beapplied. You should select an evaluation mode that defines how the policy should be evaluated. You can selectone of the following four evaluation modes:
? On demand : This mode evaluates the policy when it is manually run by the user.
? On schedule : This mode allows the policy to be evaluated automatically by using a SQL Server Agent job.This mode also logs any violations of the policy.
? On change: log only : This mode evaluates a policy automatically when a relevant change occurs. Thismode also logs any violations of the policy.
? On change: prevent : This mode is an automated mode that prevents any violation of the policy by usingDDL triggers.You should not configure the
On demand evaluation mode for the policy because this mode evaluates the policyonly when it is manually run by the user. In this scenario, you want the policy to be automated. You should not configure the On schedule evaluation mode for the policy. In this scenario, you want to preventpolicy violations. The On schedule
evaluation mode does not prevent policy violations. This mode only logs anyviolations of the policy.You should not configure the On change: log only evaluation mode for the policy because this mode does notprevent policy violations. The On change: log only
evaluation mode only logs any violations of the policy.Objective:
Maintaining SQL Server InstancesSub-Objective:
Implement the declarative management framework (DMF).References:
MSDN > MSDN Library > Servers and Enterprise Development > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Operations > Administration >Administering Servers by Using Policy-Based Management