Practice — DWB11-001–017
Record answer, confidence (1–5), time, and review flag before opening diagnostics.
DWB11-001 — Foundations · Foundational · Recall
Which statement best matches Chapter 11's definition of Data Warehousing and Business Intelligence? - A. Planning, implementing, and managing an integrated data system that supports knowledge workers engaged in reporting, query, and analysis. - B. Recording every operational transaction in a single application. - C. Creating dashboards without integrating underlying data. - D. Managing only the hardware used by analytical systems.
DWB11-002 — Foundations · Foundational · Recall
Which is one of the two Chapter 11 program goals? - A. Replace all operational systems with the data warehouse. - B. Create insights that support effective business analysis and decision-making. - C. Eliminate the need for Data Governance by centralizing data. - D. Store only summarized data to maximize performance.
DWB11-003 — Foundations · Standard · Understand
Why does Chapter 11 identify historical warehouse data as especially useful for compliance? - A. Warehouses automatically certify regulatory compliance. - B. Historical data eliminates the need for source-system controls. - C. Historical integrated data can provide evidence that the organization met regulatory or reporting obligations. - D. Compliance reporting always requires real-time streaming.
DWB11-004 — Foundations · Foundational · Recall
Which principle says warehouse content should be driven by the business priority and the intended BI delivery? - A. Summarize and optimize first. - B. One size fits all. - C. Make staging permanent. - D. Start with the end in mind.
DWB11-005 — Foundations · Standard · Distinguish
A team wants to aggregate away detailed source records before any analytical requirements are validated. Which Chapter 11 principle argues against this? - A. Summarize and optimize last, not first. - B. Focus on business goals. - C. One size does not fit all. - D. Promote transparency and self-service.
DWB11-006 — Foundations · Standard · Understand
Why does Chapter 11 say to build Metadata with the warehouse? - A. Metadata is needed only for physical storage sizing. - B. Users must be able to explain what data means, how calculations were derived, and where the data came from. - C. Metadata replaces the need for source-to-target mapping. - D. Metadata is useful only after the warehouse reaches production.
DWB11-007 — Foundations · Standard · Apply
A global architecture is defined, but each release delivers one prioritized business process at a time. Which guiding principle does this best illustrate? - A. Summarize and optimize first. - B. One size does not fit all. - C. Think and design globally; act and build locally. - D. Non-volatility.
DWB11-008 — Foundations · Foundational · Distinguish
Chapter 11 uses the term Business Intelligence in two ways. Which pair is correct? - A. An operational database and its backup system. - B. A data warehouse and its staging area. - C. A reporting department and its project methodology. - D. A type of analysis for understanding organizational activity/opportunity, and the technologies that enable that analysis.
DWB11-009 — Inmon & Kimball · Foundational · Recall
Which set contains the four classic Inmon warehouse properties? - A. Subject-oriented, integrated, time-variant, and non-volatile. - B. Normalized, virtualized, encrypted, and distributed. - C. Dimensional, conformed, current, and volatile. - D. Operational, transactional, real-time, and application-oriented.
DWB11-010 — Inmon & Kimball · Standard · Distinguish
What does 'subject-oriented' mean in the Inmon/CIF discussion? - A. The warehouse stores only one subject area at a time. - B. The warehouse is organized around major business subjects or entities rather than one application or function. - C. The warehouse is organized by source-system table name. - D. The warehouse is designed exclusively for one executive user.
DWB11-011 — Inmon & Kimball · Standard · Understand
Why does Chapter 11 say integrated warehouse data is not simply a copy of operational data? - A. Warehouse data must always be summarized. - B. Warehouse data excludes Master and Reference Data. - C. Common key structures, definitions, codes, naming conventions and representations are applied consistently. - D. Warehouse data must be stored in cubes.
DWB11-012 — Inmon & Kimball · Standard · Apply
A regulator reruns the same historical query six months later and expects the same point-in-time result. Which warehouse property is most directly involved? - A. Subject-oriented. - B. Volatile. - C. Self-service. - D. Time-variant.
DWB11-013 — Inmon & Kimball · Standard · Distinguish
Which statement best describes non-volatility in the Inmon warehouse? - A. Existing historical warehouse records are generally not updated like operational records; new states are appended. - B. Warehouse data can never be loaded again. - C. Warehouse data is always read-only at the storage-engine level. - D. Only summarized records are retained.
DWB11-014 — Inmon & Kimball · Standard · Distinguish
Which description best fits an Operational Data Store (ODS) in the CIF? - A. A permanent archive of all enterprise history. - B. An integrated, lower-latency store of current or near-term data that is more volatile and has a shorter history than the warehouse. - C. A dimensional mart used only for strategic analysis. - D. A transient staging area that end users never query.
DWB11-015 — Inmon & Kimball · Difficult · Distinguish
How does an Operational Data Mart (OpDM) differ from a conventional historical data mart in Chapter 11? - A. It contains only external Reference Data. - B. It is the enterprise integration layer in Inmon architecture. - C. It supports tactical decision-making with current/near-term volatile data and is sourced from an ODS rather than the historical DW. - D. It is a synonym for a staging database.
DWB11-016 — Inmon & Kimball · Foundational · Recall
Which description best matches Kimball's warehouse approach? - A. A normalized enterprise repository that must precede all marts. - B. A real-time operational store with no history. - C. A collection of raw files that users query directly. - D. Transaction data structured dimensionally for query and analysis.
DWB11-017 — Inmon & Kimball · Standard · Distinguish
In a star schema, what is the relationship between facts and dimensions? - A. Facts contain quantitative measures of business processes; dimensions provide descriptive context used to analyze those facts. - B. Facts describe users while dimensions store only system logs. - C. Facts are always text while dimensions are always numeric. - D. Facts are source systems and dimensions are staging tables.