Which type of data does a dimension table primarily contain?
- Descriptive data
- Metadata
- Numerical data
- Transactional data
A dimension table primarily contains descriptive data that provides context to the numerical values stored in the fact table. Dimension tables typically include attributes such as customer name, product category, time period, etc. These attributes are used to slice and dice the data in the fact table for analysis.
Loading...
Related Quiz
- Which of the following statements best describes the use of SQL in data modeling?
- Scenario: A project manager wants to visualize the interactions between different components of a system. Which modeling language would be most suitable for this purpose, SQL or UML?
- What is a key characteristic of document databases in terms of schema flexibility?
- How does data partitioning contribute to database performance?
- What are the advantages of using Data Marts over Data Warehouses in certain scenarios?