DIMENSIONAL DATA MODELLING
From the book I Am Datapedia!, published here free by the author.
Part of I Am Datapedia!
Questions 1–10 of 10
1. Into what two kinds of structure does Dimensional Data Modelling organise data?
2. What is the primary goal of dimensional modelling?
3. Which two questions do facts and dimensions answer together?
4. What distinguishes a star schema?
5. In a snowflake schema, what might a Customer dimension reference?
6. How does dimensional modelling relate to normalisation?
7. Which measures does the example Fact_LoanApproval table contain?
8. Which question is given as an example that business users can easily answer with a dimensional loan model?
9. Which of the following is NOT listed as a strength of dimensional modelling?
10. To which modelling family does dimensional modelling belong?