Microsoft
70-432 · Question #33
You are the administrator of a SQL Server 2008 instance. There are user-defined stored procedures. You have to ensure two things. First the names of all user-defined stored procedures must contain…
The correct answer is A. You should create a policy that targets the name of the stored procedure that is evaluated on. See the full explanation below for the reasoning.
Question
You are the administrator of a SQL Server 2008 instance. There are user-defined stored procedures. You have to ensure two things. First the names of all user-defined stored procedures must contain the prefix usp_ on all instances; secondly stored procedures wich do not contain this prefix cannot be created by you. What should you do to ensure these two?
Options
- AYou should create a policy that targets the name of the stored procedure that is evaluated on
- BYou should create a policy that targets the name of the stored procedure that is evaluated on
- CYou should create a condition that targets the name of stored procedure that is evaluated on
- DYou should create a condition that targets the name of the stored procedure that is evaluated
How the community answered
(25 responses)- A72% (18)
- B8% (2)
- C16% (4)
- D4% (1)
Community Discussion
No community discussion yet for this question.