DW Quiz 4

BIDS (Business Intelligence Development Studio) provides environment for developing your OLAP Cube and Deploy on SQL Server. a. True b. False

a

In any analytical system, time is a critical dimension. a. True b. False

a

MOLAP refers to ............OLAP. a. Multidimensional b. Multiple c. Many-to-Many d. Mix

a

OLAP systems provide ............. and roll-up capabilities. a. drill-down b. drop-down c. top-down d. up-down

a

ROLAP refers to ............OLAP. a. Relational b. Rapid c. Running d. Roll

a

Regarding OLAP, which statement is true? a. An OLAP cube is a technology that stores data in an optimized way to provide a quick response to various types of complex queries by using dimensions and measures. b. Most cubes store dimensional values with its special storage structure to provide quick response to queries. c. An OLAP cube is a technology that stores data in data warehouse. d. None of the others

a

SSAS (SQL Server Analysis Services) is Microsoft BI Tool for creating Online Analytical Processing and data mining functionality. a. True b. False

a

Which is the act of picking a rectangular subset of a cube by choosing a single value for one of its dimensions, creating a new cube with one fewer dimension? a. Slice c. Dice b. Roll-up c. Drill Down/Up

a

Which operation allows an analyst to rotate the cube in space to see its various faces? a. Pivot b. Dice c. Roll-up d. Slice

a

Which operation allows the user to navigate among levels of data ranging from the most summarized to the most detailed? a. Drill Down b. Dice c. Roll-up d. Slice

a

Which statement is correct? a. We have to choose OLAP Cube when performance is a key factor, the key decision makers of the company can ask for statistics from the data anytime from your huge database. b. We have to choose OLAP Cube when storage is a key factor, the key decision makers of the company can ask for statistics from the data anytime from your small database. c. We have to choose OLAP Cube when we do not want to implement ETL. d. None of the others.

a

Which statement is correct? a. With OLAP cube, we are able to create data mining structure on this data which can be helpful in forecasting, prediction. b. OLAP cube help us reduce the cost (time, CPU usage) of updating the data warehouse database. c. OLAP is an optimized way to design the data warehouse system. d. None of the others.

a

Which operation produces a subcube by allowing the analyst to pick specific values of multiple dimensions? a. Slice b. Dice c. Roll-up d. Drill Down/Up

b

Which operation involves summarizing the data along a dimension? a. Dice b. Slice c. Roll-up d. Drill Down

c

Regarding to Online Analytical Processing (OLAP), which statement is INCORRECT? a. Designed to hold historical data for analyses and forecast business needs b. Data stored in denormalized format c. Used by users who are associated with the decision making process, e.g., Managers, CEO. d. Holds daily Latest Transactional Data related to your application

d