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 …
6. Question 6 What statement is FALSE about the MDX language 1 point MDX is the base of some Microsoft products. mdXML is a query language in the…
1. Question 1 The followings are dimensions with hierarchies EXCEPT. 1 point gender phone number date of birth U.S. Social Security Number
10. Question 10 Only one cube name can appear in the FROM clause of an MDX statement. 1 point True False
8. Question 8 Which of the followings is NOT a typical feature of pivot table products. 1 point charting feature for graphical display of pivot table results require…
4. Question 4 For a data cube with dimensions, employee, department, and time, an operation to replace the time dimension with a specific month (such as January 2015), is a…
10. Question 10 The slicer in the following MDX statement is: 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 …
