6. Question 6 What is the Average Sales Amount of Resller promotions for the USA and Canadian dollars as source currencies in January? 1 point $4,999.50 $2,667.13 …
12. Question 12 The Source Currency dimension can be used as both a field in the Rows and Filters areas. 1 point True False
11. Question 11 What changes occur in the MDX SELECT statement when a filter condition is added to a pivot table specification such as from Part 2 to Part 3…
1. Question 1 How many levels are in the Promotions dimension excluding All? 1 point 1 2 3 4
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
