Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 5 question 11 discussion

Actual exam question from Microsoft's DP-300

Question #: 11
Topic #: 5

DRAG DROP -
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:

Show Suggested Answer

Suggested Answer:

First create a condition, then a custom policy based on the condition, finally run a policy evaluation.
Reference:
https://www.mssqltips.com/sqlservertip/2298/enforce-sql-server-database-naming-conventions-using-policy-based-management/

by U_C at Oct. 10, 2021, 2:57 a.m.

Comments

Submit Cancel

TheDataGuy

2 years, 1 month ago

Condition-->Policy->Evaluate. https://learn.microsoft.com/en-us/sql/relational-databases/policy-based-management/administer-servers-by-using-policy-based-management?view=sql-server-ver16

upvoted 1 times

...

Ciupaz

2 years, 3 months ago

Remember CP: firts the Condition, then the Policy.

upvoted 3 times

TheSwedishGuy

9 months ago

Thanks man. Good way to remember.

upvoted 1 times

...

reachmymind

2 years, 11 months ago

Correct Answer -> Create a custom condition based on a built-in facet -> Create a custom policy based on a condition -> Run a policy evaluation https://www.mssqltips.com/sqlservertip/2298/enforce-sql-server-database-naming-conventions-using-policy-based-management/

upvoted 3 times

...

smaa

3 years ago

https://docs.microsoft.com/en-us/sql/relational-databases/policy-based-management/administer-servers-by-using-policy-based-management?view=sql-server-ver15 Looks like given answer is correct.

upvoted 1 times

...

Anandk291996

3 years, 1 month ago

Existing answer is correct. We should create a condition before creating policy.

upvoted 1 times

...

U_C

3 years, 4 months ago

I think the correct answer is: B-C-F

upvoted 3 times

maxtohmilz

3 years, 3 months ago

you should create the condition before the policy https://www.red-gate.com/simple-talk/blogs/sql-server-policy-based-management-creating-a-custom-condition/

upvoted 4 times

...

learnazureportal

3 years, 4 months ago

Yes, The correct answer is BCF.

upvoted 1 times

...