Star Schema — Learn free

Self-check

Questions 1–10 of 10

1. Whose data warehousing approach do the star schema and snowflake schema belong to?
Question 1A. Bill InmonB. Ralph KimballC. Edgar CoddD. Dan LinstedtE. Peter Chen
2. According to Ralph Kimball, which modelling approach must be used for data warehouses and data marts?
Question 2A. Third Normal FormB. Data VaultC. Dimensional modelling, consisting of star and snowflake schemasD. Anchor modellingE. Entity-relationship modelling
3. In a star schema, what sits in the middle of the model?
Question 3A. A dimension tableB. A fact tableC. A conformed dimensionD. A staging tableE. An OLAP cube
4. In a star schema, how are the dimensions related to the fact table?
Question 4A. Each dimension is joined directly to the fact tableB. Dimensions are joined to each other in a chainC. Dimensions are nested inside the fact tableD. Dimensions are stored in a separate databaseE. Dimensions are joined only through sub-dimensions
5. In the star schema example with a Sales fact table, which of the following is given as a dimension?
Question 5A. RevenueB. Quantity soldC. TimeD. Discount amountE. Transaction ID
6. What makes up the primary key of the fact table in a star schema?
Question 6A. A single auto-generated surrogate keyB. All the foreign key columns coming from the dimensionsC. The transaction timestampD. The product nameE. The sales amount
7. When a report or query is created against a star schema, how many joins are needed to reach any dimension?
Question 7A. Always one direct joinB. Two joins via a sub-dimensionC. As many joins as there are dimensionsD. No joins, because dimensions are embeddedE. A variable number depending on normalisation
8. Which of the following is NOT a dimension named in the Sales star schema example?
Question 8A. TimeB. LocationC. ProductD. CategoriesE. Supplier
9. In which kinds of data store is the star schema applied?
Question 9A. OLTP systems onlyB. Data warehouses and data martsC. Data lakes onlyD. Web scraping outputsE. Message queues
10. In the star schema example, which table is the fact table?
Question 10A. TimeB. LocationC. ProductD. SalesE. Categories