You’re the administrator of your company network. And SQL Server 2008 has been deployed on your computer. Now you use SQL Server 2008 to create a SQL Server 2008 Analysis Services (SSAS) solution and then you design a Business Intelligence (BI) solution. The exhibit below presents the data source view of the solution.
You create the components below from the corresponding tables in the data source view:
A measure group named FactSales
Two dimensions named DimCustomer and DimGeography
In the FactSales measure group, you intend to analyze data by geographic location. You have to use the DimGeography dimension to execute the rollup measures in the FactSales measure group. So what should you do?
A.
You should create a regular relationship for the DimGeography dimension.
B.
You should create a referenced relationship for the DimGeography dimension.
C.
You should create a many-to-many relationship for the DimGeography dimension.
D.
You should create a role-playing dimension instance for the DimGeography dimension.