DP-300 Certification Practice Question #191

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 naming conventions.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:

Accepted Answer

Policy-Based Management in SQL Server works in this order: First, you define a **Condition** (an expression that tests a facet property — e.g., SP names start with "usp_"). Then, you create a **Policy** that references the condition and specifies when/how it's evaluated. Finally, you **Run a policy evaluation** to identify non-compliant stored procedures. This sequence is mandatory — a policy cannot exist without a condition. All community signals unanimously agree on this order.

More DP-300 practice questions