Which of the following actions should you take?

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.)

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:



Leave a Reply 0

Your email address will not be published. Required fields are marked *