What should you recommend?

You need to recommend a solution to allow application users to perform tables. The solution must meet the business requirements.

What should you recommend?
A . Create a Policy-Based Management Policy.
B . Create a user-defined database role and add users to the role.
C . Create stored procedures that use EXECUTE AS clauses.
D . Create functions that use EXECUTE AS clauses.

View Answer

Answer: D

Explanation:

* EXECUTE AS Clause (Transact-SQL)

In SQL Server you can define the execution context of the following user-defined modules: functions (except inline table-valued functions), procedures, queues, and triggers.