Multidimensional data models MCQs January 8, 2026November 19, 2024 by u930973931_answers 10 min Score: 0 Attempted: 0/10 Subscribe 1. What is a multidimensional data model primarily used for? (A) Transactional data processing (B) Analytical and decision support applications (C) Operational data storage (D) Data normalization 2. In a multidimensional data model, which of the following is an example of a dimension? (A) Sales amount (B) Time (C) Profit margin (D) Total revenue 3. What is the central table in a star schema called? (A) Aggregation table (B) Dimension table (C) Metadata table (D) Fact table 4. In a star schema, the dimension tables are usually: (A) Denormalized (B) Highly normalized (C) Stored as flat files (D) Distributed 5. A snowflake schema is different from a star schema because: (A) Dimension tables are normalized (B) Fact tables are normalized (C) It does not use fact tables (D) It requires less storage 6. What type of data does a fact table in a multidimensional model primarily store? (A) Attributes describing dimensions (B) Metadata about the schema (C) Aggregated or transactional numerical measures (D) Historical data snapshots 7. Which of the following best represents the structure of a multidimensional data model? (A) Grid (B) Graph (C) Tree (D) Cube 8. What is the purpose of hierarchies in a multidimensional model? (A) To link fact tables to dimension tables (B) To support aggregation and drill-down operations (C) To store metadata about dimensions (D) To represent unrelated dimensions 9. In a multidimensional data model, “granularity” refers to: (A) The size of the data cubes (B) The level of detail in the data stored (C) The relationships between dimensions (D) The aggregation method used 10. Which of the following is an example of a measure in a multidimensional data model? (A) Total sales revenue (B) Product category (C) Customer region (D) Order date