• Description: Microsoft SQL Server 2005 Business Intelligence ? Implementation and
• Passing Score: 0%
• Practice Test - Number of questions: 97 questions
• Simulation Test - Number of questions: 97 questions
• Simulation Test Duration: 120 minutes
• Has explanations: No

You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project. You have a cube named SalesCube that contains the following objects:

Answer(s)

1. measure group named Sales that contains a measure named Internet Sales Amount.A dimension named DimProduct that contains a hierarchy named Product Category. Thehierarchy contains the Category attribute on the first level, the Subcategory attribute on thesecond level, and the Product attribute on the third level.MaintenanceYou need to write a Multidimensional Expressions (MDX) query that displays only the productnames and the Internet sales amount for each product.Which query should you use?A - select [Sales].[lnternet Sales Amount] on columns,[DimProduct].[Product Category].[Product].members on rowsfrom [SalesCube];
2. - select [Sales].[lnternet Sales Amount] on columns,[DimProduct].[Product Category].[Subcategory].members on rowsfrom [SalesCube];
3. - select [Sales].[Internet Sales Amount] on columns,[DimProduct].[Product Category].memberson rowsfrom [SalesCube];
4. - select [Sales].[lnternet Sales Amount] on columns,[DimProduct].[Product Category].&[3] onrowsfrom [SalesCube];

measure group named Sales that contains a measure named Internet Sales Amount.A dimension named DimProduct that contains a hierarchy named Product Category. Thehierarchy contains the Category attribute on the first level, the Subcategory attribute on thesecond level, and the Product attribute on the third level.MaintenanceYou need to write a Multidimensional Expressions (MDX) query that displays only the productnames and the Internet sales amount for each product.Which query should you use?A - select [Sales].[lnternet Sales Amount] on columns,[DimProduct].[Product Category].[Product].members on rowsfrom [SalesCube];