1. What is star schema ? Junior A. one central fact table joined to denormalized dimension tables B. a system-generated key that lets multiple historical versions of a business key coexist C. a table of numeric measures at a defined grain with FKs to dimensions D. a star whose dimensions are further normalized into sub-dimensions
2. Which term means: "one central fact table joined to denormalized dimension tables"? Junior A. semi-additive measure B. SCD Type 3 C. snowflake schema D. star schema
3. Which statement is correct? Junior A. star schema — one central fact table joined to denormalized dimension tables B. star schema — overwrites the old value, keeping no history C. star schema — preserves history with new rows plus effective/end dates and a current flag D. star schema — Kimball is bottom-up dimensional; Inmon is top-down 3NF enterprise modeling
4. What is snowflake schema ? Junior A. preserves history with new rows plus effective/end dates and a current flag B. a table of numeric measures at a defined grain with FKs to dimensions C. a star whose dimensions are further normalized into sub-dimensions D. Kimball is bottom-up dimensional; Inmon is top-down 3NF enterprise modeling
5. Which term means: "a star whose dimensions are further normalized into sub-dimensions"? Junior A. semi-additive measure B. snowflake schema C. SCD Type 3 D. additive measure
6. Which statement is correct? Junior A. snowflake schema — a system-generated key that lets multiple historical versions of a business key coexist B. snowflake schema — the level of detail represented by one fact-table row C. snowflake schema — a measure summable across some dimensions but not time (e.g. account balance) D. snowflake schema — a star whose dimensions are further normalized into sub-dimensions
7. What is fact table ? Junior A. a star whose dimensions are further normalized into sub-dimensions B. the level of detail represented by one fact-table row C. preserves history with new rows plus effective/end dates and a current flag D. a table of numeric measures at a defined grain with FKs to dimensions
8. Which term means: "a table of numeric measures at a defined grain with FKs to dimensions"? Junior A. additive measure B. fact table C. SCD Type 3 D. snowflake schema
9. Which statement is correct? Junior A. fact table — a system-generated key that lets multiple historical versions of a business key coexist B. fact table — a table of numeric measures at a defined grain with FKs to dimensions C. fact table — a table of descriptive attributes (who/what/where/when) D. fact table — overwrites the old value, keeping no history
10. What is dimension table ? Junior A. one central fact table joined to denormalized dimension tables B. a system-generated key that lets multiple historical versions of a business key coexist C. the level of detail represented by one fact-table row D. a table of descriptive attributes (who/what/where/when)
11. Which term means: "a table of descriptive attributes (who/what/where/when)"? Junior A. SCD Type 1 B. SCD Type 2 C. Kimball vs Inmon D. dimension table
12. Which statement is correct? Junior A. dimension table — Kimball is bottom-up dimensional; Inmon is top-down 3NF enterprise modeling B. dimension table — a measure summable across all dimensions (e.g. revenue) C. dimension table — a table of numeric measures at a defined grain with FKs to dimensions D. dimension table — a table of descriptive attributes (who/what/where/when)
13. What is grain ? Junior A. a star whose dimensions are further normalized into sub-dimensions B. a table of descriptive attributes (who/what/where/when) C. Kimball is bottom-up dimensional; Inmon is top-down 3NF enterprise modeling D. the level of detail represented by one fact-table row
14. Which term means: "the level of detail represented by one fact-table row"? Junior A. additive measure B. snowflake schema C. grain D. surrogate key
15. Which statement is correct? Junior A. grain — overwrites the old value, keeping no history B. grain — a table of numeric measures at a defined grain with FKs to dimensions C. grain — the level of detail represented by one fact-table row D. grain — a system-generated key that lets multiple historical versions of a business key coexist
16. What is SCD Type 1 ? Mid A. overwrites the old value, keeping no history B. a star whose dimensions are further normalized into sub-dimensions C. a table of descriptive attributes (who/what/where/when) D. a system-generated key that lets multiple historical versions of a business key coexist
17. Which term means: "overwrites the old value, keeping no history"? Mid A. dimension table B. SCD Type 2 C. SCD Type 3 D. SCD Type 1
18. Which statement is correct? Mid A. SCD Type 1 — a table of descriptive attributes (who/what/where/when) B. SCD Type 1 — overwrites the old value, keeping no history C. SCD Type 1 — a measure summable across some dimensions but not time (e.g. account balance) D. SCD Type 1 — preserves history with new rows plus effective/end dates and a current flag
19. What is SCD Type 2 ? Mid A. a star whose dimensions are further normalized into sub-dimensions B. a system-generated key that lets multiple historical versions of a business key coexist C. preserves history with new rows plus effective/end dates and a current flag D. a measure summable across some dimensions but not time (e.g. account balance)
20. Which term means: "preserves history with new rows plus effective/end dates and a current flag"? Mid A. fact table B. surrogate key C. SCD Type 1 D. SCD Type 2
21. Which statement is correct? Mid A. SCD Type 2 — a measure summable across some dimensions but not time (e.g. account balance) B. SCD Type 2 — overwrites the old value, keeping no history C. SCD Type 2 — a star whose dimensions are further normalized into sub-dimensions D. SCD Type 2 — preserves history with new rows plus effective/end dates and a current flag
22. What is SCD Type 3 ? Mid A. a table of descriptive attributes (who/what/where/when) B. keeps limited history in extra columns (e.g. previous_value) C. a star whose dimensions are further normalized into sub-dimensions D. a system-generated key that lets multiple historical versions of a business key coexist
23. Which term means: "keeps limited history in extra columns (e.g. previous_value)"? Mid A. grain B. SCD Type 3 C. additive measure D. Kimball vs Inmon
24. Which statement is correct? Mid A. SCD Type 3 — keeps limited history in extra columns (e.g. previous_value) B. SCD Type 3 — a system-generated key that lets multiple historical versions of a business key coexist C. SCD Type 3 — a measure summable across all dimensions (e.g. revenue) D. SCD Type 3 — a star whose dimensions are further normalized into sub-dimensions
25. What is surrogate key ? Mid A. a system-generated key that lets multiple historical versions of a business key coexist B. a measure summable across all dimensions (e.g. revenue) C. a table of numeric measures at a defined grain with FKs to dimensions D. a table of descriptive attributes (who/what/where/when)
26. Which term means: "a system-generated key that lets multiple historical versions of a business key coexist"? Mid A. fact table B. semi-additive measure C. surrogate key D. Kimball vs Inmon
27. Which statement is correct? Mid A. surrogate key — Kimball is bottom-up dimensional; Inmon is top-down 3NF enterprise modeling B. surrogate key — a table of numeric measures at a defined grain with FKs to dimensions C. surrogate key — a system-generated key that lets multiple historical versions of a business key coexist D. surrogate key — the level of detail represented by one fact-table row
28. What is Kimball vs Inmon ? Senior A. a measure summable across some dimensions but not time (e.g. account balance) B. overwrites the old value, keeping no history C. a measure summable across all dimensions (e.g. revenue) D. Kimball is bottom-up dimensional; Inmon is top-down 3NF enterprise modeling
29. Which term means: "Kimball is bottom-up dimensional; Inmon is top-down 3NF enterprise modeling"? Senior A. dimension table B. Kimball vs Inmon C. SCD Type 2 D. SCD Type 1
30. Which statement is correct? Senior A. Kimball vs Inmon — a measure summable across all dimensions (e.g. revenue) B. Kimball vs Inmon — Kimball is bottom-up dimensional; Inmon is top-down 3NF enterprise modeling C. Kimball vs Inmon — preserves history with new rows plus effective/end dates and a current flag D. Kimball vs Inmon — a measure summable across some dimensions but not time (e.g. account balance)
Showing 30 of 36 Modeling questions — the full set, with answers, explanations and an AI tutor on every question, is inside.