DP-300 · Question #181
Drag and Drop Question You have SQL Server on an Azure virtual machine. You need to use Policy-Based Management in Microsoft SQL Server to identify stored procedures that do not comply with your…
The correct answer is Create a custom condition based on a built-in facet.; Create a custom policy based on a condition.; Run a policy evaluation. To enforce naming conventions on stored procedures using Policy-Based Management, you must first create a custom condition using a built-in facet (such as the StoredProcedure facet) that defines the naming rule (e.g., using a pattern match). Next, you create a custom policy…
Question
Exhibit
Answer Area
Drag items
Correct arrangement
- Create a custom condition based on a built-in facet.
- Create a custom policy based on a condition.
- Run a policy evaluation.
Explanation
To enforce naming conventions on stored procedures using Policy-Based Management, you must first create a custom condition using a built-in facet (such as the StoredProcedure facet) that defines the naming rule (e.g., using a pattern match). Next, you create a custom policy that references that condition to define when compliance is required. Finally, you run a policy evaluation to check existing stored procedures against the policy and identify non-compliant objects.
Topics
Community Discussion
No community discussion yet for this question.