Microsoft
70-433 · Question #113
70-433 Question #113: Real Exam Question with Answer & Explanation
Sign in or unlock 70-433 to reveal the answer and full explanation for question #113. The question stem and answer options stay visible for context.
Question
You have a SQL Server database. The database contains two schemas named Marketing and Sales. The Marketing schema is owned by a user named MarketingManager. The Sales schema is owned by a user named SalesManager. A user named John must be able to access the Sales.Orders table by using a stored procedure named Marketing.GetSalesSummary. John is not granted a SELECT permission on the Sales.Orders table. A user named SalesUser does have SELECT permission on the Sales.Orders table. You need to implement appropriate permissions for John and the stored procedure Marketing.GetSalesSummary. What should you do?
Options
- AMarketing.GetSalesSummary should be created by using the EXECUTE AS 'SalesUser' clause.
- BMarketing.GetSalesSummary should be created by using the EXECUTE AS OWNER clause.
- CMarketing.GetSalesSummary should be created by using the EXECUTE AS CALLER clause.
- DMarketing.GetSalesSummary should be created without an EXECUTE AS clause.
Unlock 70-433 to see the answer
You've previewed enough free 70-433 questions. Unlock 70-433 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.