Galaxy Schema — Learn free

Self-check

Questions 1–10 of 10

1. By what other name is the galaxy schema known?
Question 1A. Star cluster schemaB. Fact constellation schemaC. Snowflake schemaD. Hypercube schemaE. Dimension network schema
2. How does the galaxy schema compare in complexity with the star and snowflake schemas?
Question 2A. It is simpler than bothB. It is simpler than star but more complex than snowflakeC. It is more complex than bothD. It is equally complexE. It has no dimensions, so complexity does not apply
3. How many fact tables does a galaxy schema contain?
Question 3A. Exactly oneB. NoneC. More than oneD. Exactly twoE. One per dimension
4. What are the dimensions that connect multiple fact tables across multiple star schemas called?
Question 4A. Sub-dimensionsB. Conformed dimensionsC. Degenerate dimensionsD. Junk dimensionsE. Role-playing dimensions
5. What structural change does a galaxy schema make to a star schema?
Question 5A. It merges all dimensions into the fact tableB. It divides the star schema into smaller star schemas with reusable dimensions connecting themC. It removes the fact tableD. It normalises the fact table into 3NFE. It converts dimensions into cubes
6. Which schema answers the question of where conformed dimensions appear in dimensional modelling?
Question 6A. Star schemaB. Snowflake schemaC. Galaxy schemaD. Third Normal FormE. Data Vault
7. What is a reusable dimension in a galaxy schema?
Question 7A. A dimension copied separately for each fact tableB. A dimension that connects multiple fact tablesC. A dimension stored in the OLTP systemD. A dimension that has been deleted and restoredE. A dimension with only one row
8. Which of the following is NOT true of the galaxy schema?
Question 8A. It is also called the fact constellation schemaB. It contains more than one fact tableC. It uses conformed dimensionsD. It has exactly one fact table at its centreE. It is more complex than the star schema
9. The galaxy schema belongs to which data warehousing approach?
Question 9A. Ralph Kimball's dimensional approachB. Bill Inmon's 3NF approachC. Data Vault ensemble modellingD. Anchor modellingE. NoSQL document modelling
10. What do the small star schemas within a galaxy schema share?
Question 10A. A single fact tableB. Conformed dimensions that connect their fact tablesC. The same primary keyD. A single sub-dimensionE. Nothing; they are fully independent