Microsoft
70-432 · Question #164
70-432 Question #164: Real Exam Question with Answer & Explanation
Sign in or unlock 70-432 to reveal the answer and full explanation for question #164. The question stem and answer options stay visible for context.
Question
You administer a Microsoft SQL Server 2008 R2 database that contains a schema named Reporting. The Reporting schema contains store procedures, tables, and views. Stored procedures and views in the Reporting schema access objects that are not contained in the schema. You need to ensure that the DOMAIN\BusinessReporting Active Directory group meets the following requirements: - Users are able to access objects in the Reporting schema through existing stored procedures. - Users are unable to modify tables and views in the database. What should you grant the DOMAIN\BusinessReporting group?
Options
- AAccess to the db_datareader role in the database
- BThe EXECUTE permissions on the Reporting schema
- CThe EXECUTE permissions to each schema that is queried by the stored procedures and
- DAccess to the sysadmin server role
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.