Microsoft
70-459 · Question #56
You need to recommend a solution to allow application users to perform UPDATE operations on the database tables. The solution must meet the business requirements. What should you recommend?
The correct answer is B. Create stored procedures that use EXECUTE AS clauses.. See the full explanation below for the reasoning.
Question
You need to recommend a solution to allow application users to perform UPDATE operations on the database tables. The solution must meet the business requirements. What should you recommend?
Options
- ACreate a user-defined database role and add users to the role.
- BCreate stored procedures that use EXECUTE AS clauses.
- CCreate functions that use EXECUTE AS clauses.
- DCreate a Policy-Based Management Policy.
How the community answered
(30 responses)- A10% (3)
- B83% (25)
- C3% (1)
- D3% (1)
Community Discussion
No community discussion yet for this question.