70-462J Free Dumps Study Materials
Question 12: 複数のデータベースを持つMicrosoft SQL Server 2012サーバーを管理します。
ユーザーがsp_で始まるストアドプロシージャを作成できないようにする必要があります。
どの3つのアクションを順番に実行しますか?
(答えるには、適切な行動を行動のリストから回答領域に移動し、正しい順序で並べます。
)
Correct Answer:Explanation
Step 1: Create a Condition named StoredProcNamingConvention by using the Stored
Procedure facet that has a single expression. Set the Field to @Name, Operator to NOT
LIKE, and Value to 'sp[_]%'.
Step 2: Create a Policy named StoredProcNamingPolicy Set the Check condition to
StoredProcNamingConvention and Evaluation Mode to On Change: Prevent Step 3: Enable
StoredProcNamingPolicy Policies are created and managed by using Management Studio.
The process includes the following steps:
* Select a Policy-Based Management facet that contains the properties to be configured.
* Define a condition that specifies the state of a management facet.
* Define a policy that contains the condition, additional conditions that filter the target sets,
and the evaluation mode.
* Check whether an instance of SQL Server is in compliance with the policy.
Evaluation modes
There are four evaluation modes, three of which can be automated:
* On demand. This mode evaluates the policy when directly specified by the user.
* On change: prevent. This automated mode uses DDL triggers to prevent policy
violations.Important:If the nested triggers server configuration option is disabled, On change:
prevent will not work correctly.
Policy-Based Management relies on DDL triggers to detect and roll back DDL operations that
do not comply with policies that use this evaluation mode. Removing the Policy-Based
Management DDL triggers or disabling nest triggers, will cause this evaluation mode to fail or
perform unexpectedly.
* On change: log only. This automated mode uses event notification to evaluate a policy
when a relevant change is made.
* On schedule. This automated mode uses a SQL Server Agent job to periodically evaluate a
policy.