> > Analysis MCQs > OLAP (Online Analytical Processing) MCQs

OLAP (Online Analytical Processing) MCQ

A key feature of online analytical processing is the ability to ________.

Redict

Drill down

Confound

Explain

Retract

Answer

Correct Answer: Drill down

Note: This Question is unanswered, help us to find answer for this one

Dice operation is also known as rotate.

False

True

Answer

Correct Answer: False

Note: This Question is unanswered, help us to find answer for this one

It is because of ________________ that enables OLAP to achieve great performance for a query.

Composition

Dice

Aggregation

Hybrid

Answer

Correct Answer: Aggregation

Note: This Question is unanswered, help us to find answer for this one

MOLAP databases generally give better performance.

True

False

Answer

Correct Answer: True

Note: This Question is unanswered, help us to find answer for this one

Aggregations are built from the _________________ by changing the granularity on specific dimensions.

Fact table

Schema

None

Dimension table

Answer

Correct Answer: Fact table

Note: This Question is unanswered, help us to find answer for this one

Which of the following below is/are OLAP vendors?

Cognos

Infor

Oracle corporation

All

Answer

Correct Answer: Cognos

Note: This Question is unanswered, help us to find answer for this one

The output of an OLAP query is displayed as

Pivot

Matrix

Excel

Matrix And Pivot

Answer

Correct Answer: Matrix And Pivot

Note: This Question is unanswered, help us to find answer for this one

_______________operation of OLAP involves computing all of the data relationships for one or more dimensions.

Pivot

Dice

Slice

Roll up

Answer

Correct Answer: Roll up

Note: This Question is unanswered, help us to find answer for this one

__________operation of OLAP provides alternate presentation of data by rotating it.

Dice

Slice

Pivot

Roll up

Answer

Correct Answer: Pivot

Note: This Question is unanswered, help us to find answer for this one

Can the user perform data-entry or editing tasks on OLAP data?

Yes

Answer

Correct Answer: No

Note: This Question is unanswered, help us to find answer for this one

What is the source of the OLAP cube’s metadata?

Star schema

Star schema And Snow flake schema

Database

Snow flake schema

Answer

Correct Answer: Star schema And Snow flake schema

Note: This Question is unanswered, help us to find answer for this one

What is sparsity?

A condition when each cell of the cube is not filled with data.

A condition when each cell of the cube is not filled with data and that leads to less processing time.

A condition when each cell of the cube is filled with data and that leads to more processing time.

A condition when each cell of the cube is not filled with data and that leads to more processing time.

Answer

Correct Answer: A condition when each cell of the cube is not filled with data and that leads to more processing time.

Note: This Question is unanswered, help us to find answer for this one

Following are three steps in random order for creating a data cube. 1. Chose a data source 2. Create the query that extracts data from the database 3. Create the cube from the extracted data

3,2,1

1,2,3

3,1,2

2,1,3

Answer

Correct Answer: 1,2,3

Note: This Question is unanswered, help us to find answer for this one

What are the applications of OLAP?

None

Business reporting for sales, marketing

Budgeting

Forecasting

Answer

Correct Answer: Business reporting for sales, marketing

Note: This Question is unanswered, help us to find answer for this one

What is the other name for OLAP cube?

Cube

Multidimensional cube And Hyper cube

Hyper cube

Multidimensional cube

Answer

Correct Answer: Multidimensional cube And Hyper cube

Note: This Question is unanswered, help us to find answer for this one

Which type of data models are used by databases configured for OLAP?

Single dimensional

Two dimensional

Three dimensional

Multidimensional

Answer

Correct Answer: Multidimensional

Note: This Question is unanswered, help us to find answer for this one