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