Star Schema

Share this topic

Star Schema

From the book I Am Datapedia!, published here free by the author.

Part of I Am Datapedia!

Self-check

Questions 1–10 of 10

  1. 1. Whose data warehousing approach do the star schema and snowflake schema belong to?

    Question 1
  2. 2. According to Ralph Kimball, which modelling approach must be used for data warehouses and data marts?

    Question 2
  3. 3. In a star schema, what sits in the middle of the model?

    Question 3
  4. 4. In a star schema, how are the dimensions related to the fact table?

    Question 4
  5. 5. In the star schema example with a Sales fact table, which of the following is given as a dimension?

    Question 5
  6. 6. What makes up the primary key of the fact table in a star schema?

    Question 6
  7. 7. When a report or query is created against a star schema, how many joins are needed to reach any dimension?

    Question 7
  8. 8. Which of the following is NOT a dimension named in the Sales star schema example?

    Question 8
  9. 9. In which kinds of data store is the star schema applied?

    Question 9
  10. 10. In the star schema example, which table is the fact table?

    Question 10