PrepAway - Latest Free Exam Questions & Answers

Which query should you use?

You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project.

You have a cube named SalesCube that contains the following objects:

A measure group named Sales that contains a measure named Internet Sales Amount.
A dimension named DimProduct that contains a hierarchy named Product Category. The hierarchy contains the Category attribute on the first level, the Subcategory attribute on the second level, and the Product attribute on the third level.
You need to write a Multidimensional Expressions (MDX) query that displays only the product names and the Internet sales amount for each product.

Which query should you use?

PrepAway - Latest Free Exam Questions & Answers

A.
select [Sales].[Internet Sales Amount] on columns,[DimProduct].[Product Category].[Product].members on rowsfrom [SalesCube];

B.
select [Sales].[Internet Sales Amount] on columns,[DimProduct].[Product Category].[Subcategory].members on rowsfrom [SalesCube];

C.
select [Sales].[Internet Sales Amount] on columns,[DimProduct].[Product Category].members on rowsfrom [SalesCube];

D.
select [Sales].[Internet Sales Amount] on columns,[DimProduct].[Product Category].&[3] on rowsfrom [SalesCube];


Leave a Reply