8. Question 8 What is the February Average Sales Amount of No Discount promotion for the Euro Currency as a source currency? February is the third column in the pivot…
5. Question 5 What is the Average Sales Amount across all periods and currencies for Mountain-100 Clearance Sale in the Reseller -> Discontinued Product items? 1 point $3,590.42 $10,455.32…
2. Question 2 What is the hierarchical ordering of levels in the Promotions dimension from coarsest (least detailed) to finest (most detailed)? 1 point Category-Promotion Category-Type-Promotion Category-Type-Subcategory Product-Subcategory-Type
7. Question 7 To combine multiple dimensions on an axis, 1 point a crossjoin operator must be used. a nested SELECT must be used. the WHERE clause…
6. Question 6 In an MDX statement, a slicer is specified in which clause 1 point FROM Nested SELECT statements SELECT WHERE
1. Question 1 What is a measure in a data cube? 1 point Number of rows or columns Subject label for a row or column …
8. Question 8 If the TIME dimension is added in the SELECT clause, the following MDX statement is: SELECT CrossJoin({[Order Status].[Disputed], [Order Status].[Resolved]}, {[Measures].[Sales], [Measures].[Quantity]}) ON COLUMNS, {[Product].[ClassicCars]} ON ROWS…
5. Question 5 In the result of the following MDX statement, SELECT CrossJoin({[Order Status].[Disputed], [Order Status].[Resolved]}, {[Measures].[Sales], [Measures].[Quantity]}) ON COLUMNS, {[Product].[ClassicCars]} ON ROWS FROM [SteelWheelsSales] WHERE ([TIME].[2012]) 1 point …
2. Question 2 The sparsity of a date cube usually increases when 1 point the number of members in a dimension decreases dimensions are added the number…
10. Question 10 The following MDX statement has how many axes: SELECT CrossJoin({[Order Status].[Disputed], [Order Status].[Resolved]}, {[Measures].[Sales], [Measures].[Quantity]}) ON COLUMNS, {[Product].[ClassicCars]} ON ROWS FROM [SteelWheelsSales] WHERE ([TIME].[2012]) 1 point …
