OLAP MCQ Questions & Answers
OLAP MCQs : This section focuses on "OLAP" of Data Warehousing. These Multiple Choice Questions (MCQs) should be practiced to improve the Data Warehousing skills required for various interviews (campus interviews, walk-in interviews, company interviews), placements, entrance exams and other competitive examinations.
1. OLAP stands for?
A. Offline Analytical Processing Server
B. Online Analysts Processing Server
C. Online Access Processing Server
D. Online Analytical Processing Server
View Answer
Ans : D
Explanation: Online Analytical Processing Server (OLAP).
2. OLAP based on?
A. one dimensional data model
B. two dimensional data model
C. multidimensional data model
D. All of the above
View Answer
Ans : C
Explanation: Online Analytical Processing Server (OLAP) is based on the multidimensional data model
3. How many types of OLAP servers?
A. 1
B. 2
C. 3
D. 4
View Answer
Ans : D
Explanation: We have four types of OLAP servers : Relational OLAP (ROLAP), Multidimensional OLAP (MOLAP), Hybrid OLAP (HOLAP), Specialized SQL Servers
4. _________ uses array-based multidimensional storage engines for multidimensional views of data.
A. KOLAP
B. MOLAP
C. ROLAP
D. ZOLAP
View Answer
Ans : B
Explanation: MOLAP uses array-based multidimensional storage engines for multidimensional views of data.
5. ROLAP servers are placed between relational back-end server and client front-end tools
A. TRUE
B. FALSE
C. Can be true or false
D. Can not say
View Answer
Ans : A
Explanation: True, ROLAP servers are placed between relational back-end server and client front-end tools.
6. Which of the following is false about OLAP?
A. Involves historical processing of information
B. Useful in analyzing the business
C. Number or users is in millions
D. Number of records accessed is in millions
View Answer
Ans : C
Explanation: Number or users is in hundreds
7. The pivot operation is also known as?
A. dice
B. rotation
C. roll up
D. None of the above
View Answer
Ans : B
Explanation: The pivot operation is also known as rotation.
8. The generalization of cross-tab which is represented visually is ____________ which is also called as data cube.
A. Two dimensional cube
B. Multidimensional cube
C. N-dimensional cube
D. Cuboid
View Answer
Ans : A
Explanation: Each cell in the cube is identified for the values for the three dimensional attributes
9. The process of viewing the cross-tab (Single dimensional) with a fixed value of one attribute is
A. Pivoting
B. Dicing
C. Slicing
D. Roll up
View Answer
Ans : C
Explanation: The slice operation selects one particular dimension from a given cube and provides a new sub-cube. Dice selects two or more dimensions from a given cube and provides a new sub-cube.
10. Roll-up performs aggregation on a data cube.
A. Yes
B. No
C. Can be yes or no
D. Can not say
View Answer
Ans : A
Explanation: Yes, Roll-up performs aggregation on a data cube.
Discussion