You are a database developer and you have about two years experience in creating
business Intelligence (BI) by using SQL Server2008. Now you are employed in a company
named NaproStar which uses SQL Server2008. Your company makes and sells Cars. You
work as the technical support. Now you are in charge of a SQL Server 2008 Analysis
Services (SSAS) database. Tim is the distributor of the Southern Area. Now according to the
business requirement, Tim has to access the database. After discussion, your company
decides to give Tim the necessary permissions. There are two roles respectively named
Southern Area and Cars. The table below shows the schemas of the two roles. For both
roles, you have set the Visual Totals property to True. Now you get another order from the
company, according to the company requirement, Tim can only be able to view the members
in the Product dimension that relate to the Cars category in the Southern Area. You have to
accomplish this task. So what action should you perform?

A.
Tim should be added to a new role that has the following two components:
{[Sales Territory].[Sales Territory Area].AllMembers} as the denied set{[Sales
Territory].[Sales
Territory Area].[Southern]} as the allowed set.{[Product].[Product Category].[Product
Category].AllMembers} as the denied set. {[Product].[Product Category].[Product
Category].[Cars]}
as the allowed set.

B.
Tim should be added to the Cars role

C.
Tim should be added to the Southern Area role

D.
Tim should be added to a new role that has the following two components: {[Sales
Territory].[Sales Territory Area].[Southern]} as the allowed set.{[Product].[Product
Category].[Product Category].[Cars]} as the allowed set.