4. Question 4 What is the February Average Sales Amount of the No Discount promotion for all currencies? Note that February is the third column as WebPivotTable may not render…
3. Question 3 How many levels are in the Delivery Date.Month of Year dimension excluding All? 1 point 1 2 3 4
13. Question 13 Identify the dimension expansion shown in the Rows of the snapshot for part 3. 1 point New Product -> Touring-3000 Promotion Seasonal Discount -> Sport…
7. Question 7 What is the Average Sales Amount of Discontinued Product for the USA and Canadian dollars as source currencies in all periods? 1 point $2,667.13 $3,627.81…
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
