In a data warehouse, what is a dimension table?
- A table that contains descriptive attributes
- A table that contains primary keys and foreign keys
- A table that stores metadata about the data warehouse
- A table that stores transactional data
A dimension table in a data warehouse contains descriptive attributes about the data, such as customer demographics or product categories. These tables provide context for the measures stored in fact tables.
Loading...
Related Quiz
- Scenario: Your team is tasked with designing a system to handle real-time analytics on social media interactions. Which type of NoSQL database would you recommend, and why?
- In a physical data model, denormalization is sometimes applied to improve ________.
- Scenario: A colleague is facing memory-related issues with their Apache Spark job. What strategies would you suggest to optimize memory usage and improve job performance?
- What are slowly changing dimensions (SCDs) in the context of data warehousing?
- Scenario: You are designing a distributed system where multiple nodes need to communicate with each other. What communication protocol would you choose, and why?