试题详情
单项选择题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.

  • A
  • 关注下方微信公众号,在线模考后查看

热门试题