Fact Dimension Tables Quiz

What you'll be asked

1. In a star schema, which table type typically contains the quantitative metrics or measurements of a business process?
2. When designing a data warehouse, what is the primary purpose of a dimension table?
3. You are modeling a retail database. Which of the following would most likely be stored as a row in a fact table?
4. What is the primary benefit of using a 'Surrogate Key' in a dimension table rather than using the source system's natural key?
5. In a 'Factless Fact Table' scenario, what is the most appropriate use case?

Answers and explanations come after you submit.