Data Warehouse Concepts, Design, and Data Integration

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  …

9. Question 9 In MDX, a tuple 1 point   identifies a cell using one member from each dimension.   is a dimension selected in a query.   is a…

4. Question 4 The number of credit hours taken by a student in a semester is 1 point   an additive measure as it can be summed across all dimensions….

3. Question 3 The daily rental rate on a car rental is 1 point   a non-additive measure.   an additive measure even though it is not additive across time….

2. Question 2 What is a member in a data cube? 1 point   Quantitative variable of interest   Number of rows or columns   Value of a dimension  …

1. Question 1 What is a dimension in a data cube? 1 point   Number of rows or columns   Subject label for a row or column   Value in…

9. Question 9 If no measures appear in the SELECT clause of an MDX statement, 1 point   the statement is not valid.   the default measure is shown in…

5. Question 5 For a data cube with dimensions, employee and department for January 2015, an operation to replace the department dimension with a subset of departments is a 1…

15. Question 15 What industry pioneered data warehouse usage? 1 point     Military   Telecommunications   Retail   Health care

14. Question 14 The project relationship graphs demonstrate tradeoffs between 1 point   time and risk as scope changes.   scope and risk as business value changes.   business value…