You administer a SQL Server 2008 Analysis Services (SSAS) database. A sales manager is
responsible for the sales of bikes in the Northeast region. You plan to grant the necessary
permissions to the sales manager to access the database. You have two roles named
Northeast Region and Bikes. The schemas of the two roles are as shown in the following
table.

The Visual Totals property is set to True for both roles.
You need to ensure that the sales manager can view only the members in the Product
dimension that relate to the Bikes category in the Northeast region.
What should you do?

A.
Add the manager to the Bikes role.

B.
Add the manager to the Northeast Region role.

C.
Add the manager to a new role that has the following two components: {[Sales
Territory].[Sales
Territory Region].&[Northeast]} as the allowed set.{[Product].[Product Category].[Product
Category].&[Bikes]} as the allowed set.

D.
Add the manager to a new role that has the following four components: {[Sales
Territory].[Sales
Territory Region].AllMembers} as the denied set{[Sales Territory].[Sales Territory
Region].&[Northeast]} as the allowed set.{[Product].[Product Category].[Product
Category].AllMembers} as the denied set. {[Product].[Product Category].[Product
Category].&[Bikes]} as the allowed set.