Microsoft
70-451 · Question #23
70-451 Question #23: Real Exam Question with Answer & Explanation
The correct answer is A. Create the procedure by using the EXECUTE AS SELF option.. See the full explanation below for the reasoning.
Question
You are a database developer. You plan to design a database solution by using SQL Server 2008. There are two schemas named Sales and Marketing. You are the owner of the Sales schema and the Marketing schema is owned by a user named MarketingUser. Users of the Marketing schema do not have permissions to access the Sales schema. You have permissions to create objects in all schemas in the database. The Sales schema has a table named Customers. You plan to create a stored procedure in the Marketing schema for the marketing team. The stored procedure will select data from the Customers table and will be owned by MarketingUser. You need to ensure that the marketing team is able to execute the stored procedure. What should you do?
Options
- ACreate the procedure by using the EXECUTE AS SELF option.
- BCreate the procedure by using the EXECUTE AS CALLER option.
- CCreate the procedure by using the EXECUTE AS OWNER option.
- DCreate the procedure by using the EXECUTE AS USER=MarketingUser option.
Community Discussion
No community discussion yet for this question.