Microsoft
70-432 · Question #164
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…
The correct answer is D. Access to the sysadmin server role. See the full explanation below for the reasoning.
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
How the community answered
(32 responses)- A9% (3)
- B6% (2)
- C3% (1)
- D81% (26)
Community Discussion
No community discussion yet for this question.