Microsoft
70-432 · Question #124
70-432 Question #124: Real Exam Question with Answer & Explanation
Sign in or unlock 70-432 to reveal the answer and full explanation for question #124. The question stem and answer options stay visible for context.
Question
You administer a SQL Server 2008 instance that contains a database named DB1. The DB1 database contains the following stored procedure. (Line numbers are included for reference only.) When a user named User1 attempts to invoke Procedure1, the following exception is raised: "Msg 262, Level 14, State 1, Procedure Procedure1, Line 5 CREATE TABLE permission denied in database 'DB1'." You need to provide User1 access to execute Procedure1 by allocating only the required permissions. What should you do?
Exhibit
Options
- AGrant the ALTER permission on the Sales schema to User1.
- BGrant the CREATE TABLE permission and allow User1 to drop the Sales.Table1 table.
- CInsert the WITH EXECUTE AS 'dbo' clause between lines 01 and 02.
- DInsert the EXECUTE AS USER = 'dbo' statement between lines 02 and 03.
Unlock 70-432 to see the answer
You've previewed enough free 70-432 questions. Unlock 70-432 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.