You work as a database administrator at ABC.com. ABC.com makes use of a SQL Server 2008
R2 instance.
You have been instructed to make sure that all stored procedures that are defined by ABC.com’s
users make use of the prefix usp_. You are also instructed to make sure that administrators are
prevented from creating stored procedures that do not make use of the prefix usp_.
Which of the following actions should you take? (Choose all that apply.)
A.
You should consider generating a policy that targets the name of the stored procedure, which is
evaluated on change.
B.
You should consider generating a condition that targets the name of the stored procedure,
which is evaluated on change.
C.
You should consider assigning minimum permissions to all administrators.
D.
You should consider creating a trigger.
Explanation: