OLAP Interview Questions

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

The correct answer is Multidimensional

Q: What is the other name for OLAP cube?

The correct answer is Both a and b

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

The correct answer is Both a and b

Take as many assements as you can to improve your validate your skill rating

Total Questions: 5

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

A. Multidimensional

B. Single dimensional

C. Two dimensional

D. Three dimensional

Correct Answer is : Multidimensional

2. What is the other name for OLAP cube?

A. Multidimensional cube

B. Hyper cube

C. Cube

D. Both a and b

Correct Answer is : Both a and b

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

A. Star schema

B. Snow flake schema

C. Both a and b

D. Database

Correct Answer is : Both a and b

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

A. Slice

B. Roll up

C. Dice

D. Pivot

Correct Answer is : Roll up

5. _________________operation of OLAP provides alternate presentation of data by rotating it

A. Slice

B. Roll up

C. Dice

D. Pivot

Correct Answer is : Pivot

OLAP interview questions