Microsoft
70-451 · Question #91
70-451 Question #91: Real Exam Question with Answer & Explanation
Sign in or unlock 70-451 to reveal the answer and full explanation for question #91. The question stem and answer options stay visible for context.
Question
You are a database developer. You develop solutions by using SQL Server 2008 in an enterprise environment. You plan to create a stored procedure that queries a sales table and produces forecast data. You do not have administrative permissions, and you are not the owner of the database. You have permissions to create stored procedures. Users will only have permissions to execute your stored procedures. You need to ensure that users can execute the stored procedures. What should you do?
Options
- ASet the TRUSTWORTHY property of the database to ON.
- BInclude an EXECUTE AS OWNER clause when you create each stored procedure.
- CInclude an EXECUTE AS CALLER clause when you create each stored procedure.
- DInclude a SETUSER statement before you query the sales table in each stored procedure.
Unlock 70-451 to see the answer
You've previewed enough free 70-451 questions. Unlock 70-451 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.