Microsoft
70-432 · Question #193
70-432 Question #193: Real Exam Question with Answer & Explanation
Sign in or unlock 70-432 to reveal the answer and full explanation for question #193. The question stem and answer options stay visible for context.
Question
You administer a SQL Server 2008 instance named SQL1. SQL1 contains a database named DB1. You create a new user named User1 in the DB1 database. No additional permissions have been assigned to User1 or the public role. User1 will interact with database objects stored in a new schema named Reporting. The other objects in the DB1 database are owned by the dbo and are contained in a schema named Operations. You need to grant the minimum necessary permission to User1 to create tables and stored procedures in the Reporting schema. You also need to ensure that User1 cannot alter any of the objects in the Operations schema. Which Transact-SQL statements should you execute?
Options
- AGRANT CREATE TABLE, CREATE PROCEDURE TO User1;
- BALTER AUTHORIZATION ON SCHEMA::Reporting TO User1;
- CGRANT CONTROL ON SCHEMA::Reporting TO User1;
- DGRANT CREATE TABLE, CREATE PROCEDURE ON SCHEMA: Reporting; TO User1;
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.