PrepAway - Latest Free Exam Questions & Answers

what should you do?

You are the administrator of your company network. You are in charge of a SQL Server 2008 instance.
You have to make sure that the names of all user-defined stored procedures contain the prefix usp_ on all instances. Besides this, you have to make sure that you cannot create stored procedures that do not contain this prefix. So what should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
You should create a policy that targets the name of the stored procedure that is evaluated on demand.

B.
You should create a policy that targets the name of the stored procedure that is evaluated on change.

C.
You should create a condition that targets the name of stored procedure that is evaluated on demand.

D.
You should create a condition that targets the name of the stored procedure that is evaluated on change.


Leave a Reply