Rapid Recall 01–38
Answer aloud or on paper before opening the key.
- Define DW/BI management in Chapter 11.
- Name the two program goals.
- Name the eight guiding principles.
- BI vs Data Warehouse vs Data Warehousing?
- What makes an EDW enterprise-wide?
- State Inmon’s four defining DW properties.
- Why is integrated data not just copied data?
- Why is non-volatility analytically useful?
- Atomic vs summarized data?
- Name the major CIF components.
- ODS vs DW?
- Operational Data Mart vs Data Mart?
- How does Master/Reference Data support the warehouse?
- Define Kimball’s dimensional warehouse.
- Fact vs dimension?
- What is a conformed dimension?
- What does the DW bus matrix show?
- Inmon vs Kimball in one sentence?
- Name major DW architecture components.
- Staging vs central warehouse?
- ODS vs mart?
- What are the three OLAP implementation families?
- Historical load vs ongoing update?
- Why design history from requirements?
- What does Data Vault add to the discussion?
- Name five batch CDC methods.
- Timestamp delta vs log-table delta?
- Transaction-log CDC vs message delta?
- When is full-load comparison needed?
- Name the three low-latency patterns.
- Trickle feed vs messaging vs streaming?
- Why isolate volatile change from historical warehouse data?
- Write the six DW/BI activities in order.
- How do DW requirements differ from operational-system requirements?
- What should requirements interviews capture?
- What belongs in DW/BI architecture?
- What are the three concurrent development tracks?
- Define source-to-target mapping.