70-465 | You need to recommend a solution that addresses the security…

Following is 70-465 | You need to recommend a solution that addresses the security… from latest Microsoft practice test.

Question: 17

You need to recommend a solution that addresses the security requirement. What should you recommend?

A. Revoke user permissions on the tables. Create stored procedures that manipulate data. Grant the users the EXECUTE permission on the stored procedures.
B. Grant the users the SELECT permission on the tables. Create views that retrieve data from the tables. Grant the users the SELECT permission on the views.
C. Deny the users SELECT permission on the tables. Create views that retrieve data from the tables. Grant the users the SELECT permission on the views.
D. Deny the users the SELECT permission on the tables. Create stored procedures that manipulate data. Grant the users the EXECUTE permission on the stored procedures.

Answer: C

Explanation

* Security Requirements
You must provide users with the ability to execute functions within the ERP application, without having direct access to the underlying tables.