Microsoft
70-432 · Question #11
You are the administrator of a SQL Server 2008 instance. According to the company requirement, the names of all user-defined stored procedures must contain the prefix usp_ on all instances. Besides…
The correct answer is B. A policy should be created. See the full explanation below for the reasoning.
Question
You are the administrator of a SQL Server 2008 instance. According to the company requirement, the names of all user-defined stored procedures must contain the prefix usp_ on all instances. Besides this, you must make sure that stored procedures that do not contain this prefix cannot be created by you. What should you do?
Options
- AA policy should be created.
- BA policy should be created.
- CA condition should be created.
- DA condition should be created.
How the community answered
(45 responses)- A7% (3)
- B82% (37)
- C9% (4)
- D2% (1)
Community Discussion
No community discussion yet for this question.