You manage an instance of SQL Server 2008. You are creating a Policy-Based Management policy to enforce anaming convention for databases. You want to ensure that the policy is enabled immediately after it is created. Which evaluation mode will prevent you from creating such a policy?
A.
On demand
B.
On schedule
C.
On change: log only
D.
On change: prevent
Explanation:
The On demand evaluation mode prevents you from creating a policy that is enabled immediately after it iscreated. Policy-Based Management is used to manage entities on an instance of SQL Server 2008. Whilecreating Policy-Based Management policies, you are required to select an evaluation mode that defines how thepolicy should be evaluated. You can select one of the following four evaluation modes:
? On demand : This mode evaluates the policy when it is manually run by the user. When this evaluationmode is selected, the Enabled check box on the General page of the
Create New Policy dialog boxcannot be selected. This prevents the policy from being enabled after it is created.
? 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 can select the On schedule , On change: log only
, or On change: prevent evaluation mode because all ofthese modes allow Policy-Based Management policies to be enabled immediately after they are created.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