Data Warehouse Concepts, Design, and Data Integration

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  …

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…