1. What is a multidimensional data model primarily used for?
A. Transactional data processing
B. Operational data storage
C. Analytical and decision support applications
D. Data normalization
Answer: C
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
Answer: B
3. What is the central table in a star schema called?
A. Fact table
B. Dimension table
C. Metadata table
D. Aggregation table
Answer: A
4. In a star schema, the dimension tables are usually:
A. Highly normalized
B. Denormalized
C. Stored as flat files
D. Distributed
Answer: B
5. A snowflake schema is different from a star schema because:
A. Fact tables are normalized
B. Dimension tables are normalized
C. It does not use fact tables
D. It requires less storage
Answer: B
6. What type of data does a fact table in a multidimensional model primarily store?
A. Attributes describing dimensions
B. Aggregated or transactional numerical measures
C. Metadata about the schema
D. Historical data snapshots
Answer: B
7. Which of the following best represents the structure of a multidimensional data model?
A. Grid
B. Cube
C. Tree
D. Graph
Answer: B
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
Answer: B
9. In a multidimensional data model, “granularity” refers to:
A. The level of detail in the data stored
B. The size of the data cubes
C. The relationships between dimensions
D. The aggregation method used
Answer: A
10. Which of the following is an example of a measure in a multidimensional data model?
A. Product category
B. Total sales revenue
C. Customer region
D. Order date
Answer: B