Microsoft
70-432 · Question #3
70-432 Question #3: Real Exam Question with Answer & Explanation
Sign in or unlock 70-432 to reveal the answer and full explanation for question #3. The question stem and answer options stay visible for context.
Question
You are the administrator of a SQL Server 2008 instance with a database named DB1. which contains the following stored procedure. (Line numbers are useded for reference only.) 01 CREATE PROCEDURE Sales.Procedure1 02 AS 03 IF OBJECT_ID('Service.Table') IS NOT NULL 04 DROP TABLE Service.Table; 05 06 CREATE TABLE Service.Table ( 07 Id int PRIMARY KEY CLUSTERED, 08 Name varchar(100); 09 ); 10 11 ... 12 GO The following exception is raised when a user tries to invoke Procedure1, "Msg 262, Level 14, State 1, Procedure Procedure1, Line 5 CREATE TABLE permission denied in database 'DB1'." You should grant the user access to execute Procedure1, you must assign only the required permissions. Which action should you perform?
Options
- ABetween lines 01 and 02, you should insert the WITH EXECUTE AS 'dbo' clause.
- BBetween lines 01 and 02, you should insert the EXECUTE AS USER = 'dbo' statement.
- CYou should give the user the ALTER permission on the Service schema
- DYou should give the CREATE TABLE permission and permit the user to drop the
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.