You design a Business Intelligence (BI) solution by using SQL Server 2008. A SQL Server 2008 Analysis Services (SSAS) solution contains a cube that has the following objects: ·Dimensions named DimCustomer,DimProduct,and DimGeography ·Measures named InternetSales and TotalSales Users run reports against all dimensions and measures by authenticating with their Windows accounts. You need to provide a basic view of data to the users to display only DimGeography, DimProduct,and TotalSales by using the least amount of storage space. What should you do?()
A.
Create a new perspective for the current cube. Select DimGeography, DimProduct, and TotalSales.
B.
Create a new cube. Add DimGeography, DimProduct, and TotalSales.
C.
Create a new role. Grant access only to DimGeography, DimProduct, and TotalSales.
D.
Create a new data source view. Add the tables used for DimGeography, DimProduct, and TotalSales.