Data Warehousing and OLAP MCQs January 8, 2026November 19, 2024 by u930973931_answers 10 min Score: 0 Attempted: 0/10 Subscribe 1. What is a data warehouse? (A) A collection of operational databases (B) A database optimized for transactional processes (C) A subject-oriented, integrated, time-variant, and non-volatile collection of data (D) A system designed for real-time data analytics 2. Which of the following is NOT a characteristic of a data warehouse? (A) Non-volatile (B) Subject-oriented (C) Time-variant (D) Real-time update capability 3. In OLAP, what does “roll-up” operation do? (A) Splits data into smaller parts (B) Aggregates data by climbing up a concept hierarchy (C) Rotates data axes for better visualization (D) Selects a subset of data 4. What does ETL stand for in data warehousing? (A) Extract, Transform, Load (B) Evaluate, Transfer, Log (C) Extract, Transfer, Link (D) Encode, Transfer, Load 5. Which of the following schemas is commonly used in data warehousing? (A) Tree schema (B) Star schema (C) Mesh schema (D) Network schema 6. A “snowflake schema” in a data warehouse: (A) Requires no ETL processes (B) Is used for unstructured data (C) Is a dynamic schema that changes frequently (D) Is a type of star schema with normalized dimensions 7. What is the primary purpose of OLAP? (A) To perform complex analytical and ad-hoc queries (B) To handle large-scale transactional queries (C) To store unstructured data (D) To replace ETL processes 8. Which of the following OLAP operations allows viewing data from different perspectives? (A) Drill-down (B) Slice (C) Pivot (or rotate) (D) Roll-up 9. What is a dimension table in a data warehouse? (A) A table containing descriptive attributes related to facts (B) A table that contains metrics and facts (C) A temporary table for staging data (D) A table storing transactional data 10. Which type of OLAP system uses pre-computed and stored data cubes? (A) DOLAP (Desktop OLAP) (B) ROLAP (Relational OLAP) (C) HOLAP (Hybrid OLAP) (D) MOLAP (Multidimensional OLAP)