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?
A.
Access to the db_datareader role in the database
B.
The EXECUTE permissions on the Reporting schema
C.
The EXECUTE permissions to each schema that is queried by the stored procedures and
views in the Reporting schema
D.
Access to the sysadmin server role