Question
A data analyst is modeling a new data warehouse to analyze sales. One of the requirements is to analyze sales by region. Which of the following best describes the region table?
- A. Fact
- B. Dimensional Correct
- C. Bridge
- D. Snowflake
Explanation
A region table holds descriptive attributes (region name, country, territory) that the sales facts are sliced by, so it is a dimension table in a star schema. The fact table holds the measurable sales transactions with keys to the dimensions. A bridge table resolves many-to-many relationships, and snowflake describes a schema design in which dimensions are normalized, not the role of a single table.
