Practice — DWB11-018–034
DWB11-018 — Inmon & Kimball · Standard · Apply
Sales, Inventory and Orders are separate marts but all use the same enterprise Date and Product dimensions. What architectural concept makes those marts interoperable? - A. Operational Data Store. - B. Conformed dimensions. - C. Data Vault hub. - D. Full-load comparison.
DWB11-019 — Inmon & Kimball · Standard · Understand
What does the DW bus matrix show? - A. The order of ETL jobs in the nightly batch. - B. The network topology of warehouse servers. - C. The intersections between business processes that generate fact data and subject areas that serve as dimensions. - D. The access rights for BI users.
DWB11-020 — Inmon & Kimball · Difficult · Distinguish
Which statement best captures the structural difference between Inmon and Kimball while preserving their shared objective? - A. Inmon supports history while Kimball does not. - B. Kimball supports enterprise integration while Inmon does not. - C. Inmon is for BI and Kimball is only for operational reporting. - D. Inmon centers integration on a normalized enterprise warehouse; Kimball centers integration on dimensional marts linked by conformed dimensions and the bus.
DWB11-021 — Architecture & Loads · Foundational · Recall
What is the primary purpose of a staging area? - A. Provide an intermediate place to clean, integrate, enrich, standardize and prepare data before loading analytical stores. - B. Serve as the main self-service BI portal. - C. Hold only executive KPI summaries. - D. Act as the long-term system of record for all history.
DWB11-022 — Architecture & Loads · Foundational · Understand
What normally persists in the central or atomic warehouse layer described in Chapter 11? - A. Only current-day operational transactions. - B. Historical atomic data plus the latest batch state, organized to support integrated analytical use. - C. Only pre-aggregated KPI tables. - D. Only rejected records waiting for remediation.
DWB11-023 — Architecture & Loads · Standard · Apply
A customer-service dashboard needs integrated data refreshed every few minutes and only recent history. Which storage area best fits? - A. Historical central warehouse only. - B. Static data mart refreshed quarterly. - C. Operational Data Store (ODS). - D. Metadata repository.
DWB11-024 — Architecture & Loads · Standard · Apply
Finance needs a historical analytical subset focused on profitability and budgeting. Which storage structure is the best fit? - A. Staging area. - B. Message bus. - C. Source transaction log. - D. Data mart.
DWB11-025 — Architecture & Loads · Standard · Recall
Which three classic OLAP implementation families does Chapter 11 name? - A. Relational, multidimensional, and hybrid. - B. Batch, streaming, and messaging. - C. Normalized, denormalized, and raw. - D. Operational, tactical, and strategic.
DWB11-026 — Architecture & Loads · Foundational · Distinguish
How does a historical load differ from an ongoing warehouse update? - A. Historical loads are always real-time while updates are always monthly. - B. Historical data is typically loaded once or a few times; ongoing updates are repeatedly scheduled to keep the warehouse current. - C. Historical loads contain only dimensions while updates contain only facts. - D. There is no difference; the terms are interchangeable.
DWB11-027 — Architecture & Loads · Difficult · Understand
Why does Chapter 11 mention Data Vault as another historical storage approach? - A. It eliminates the need for Data Quality. - B. It is a synonym for an ODS. - C. It can retain normalized atomic history and keys so later dimensional marts can be rebuilt or adapted when grain changes. - D. It requires users to query raw source data directly.
DWB11-028 — Architecture & Loads · Standard · Apply
A source reliably stamps changed rows with date/time but does not explicitly record deletions. Which CDC method best matches? - A. Transaction-log CDC. - B. Message delta. - C. Full-load comparison only. - D. Time-stamped delta load.
DWB11-029 — Architecture & Loads · Standard · Apply
A source writes inserts, updates and deletes to a dedicated change table. Which CDC method is most direct? - A. Log-table delta load. - B. Time-stamped delta only. - C. Trickle feed. - D. OLAP cube refresh.
DWB11-030 — Architecture & Loads · Difficult · Distinguish
Which CDC approach reads database transaction-log evidence and avoids overlap while capturing deletes? - A. Time-stamped delta. - B. Database transaction-log CDC. - C. Full-load comparison. - D. Source-side trickle feed.
DWB11-031 — Architecture & Loads · Standard · Apply
A source executes mini-batches every five minutes or whenever 300 transactions accumulate. What pattern is this? - A. Messaging. - B. Streaming. - C. Trickle feed. - D. Full historical load.
DWB11-032 — Architecture & Loads · Difficult · Distinguish
What is the key accumulation difference between messaging and streaming in Chapter 11? - A. Messaging is batch-only while streaming is historical-only. - B. Messaging requires a data mart while streaming requires an ODS. - C. Messaging stores facts while streaming stores dimensions. - D. Messaging accumulates/publishes on a bus for subscribers, while streaming accumulates at the target in a buffer or queue.
DWB11-033 — DW/BI Activities · Foundational · Recall
What is the first core DW/BI activity in Chapter 11? - A. Understand Requirements. - B. Populate the Data Warehouse. - C. Implement the BI Portfolio. - D. Maintain Data Products.
DWB11-034 — DW/BI Activities · Standard · Apply
A team begins by cataloging source tables before interviewing business users about goals or analytical questions. What does Chapter 11 recommend instead? - A. Start with tool procurement. - B. Begin with business goals, processes, current/future questions, categories, KPIs and calculations. - C. Build summaries first and validate later. - D. Skip requirements because warehouse use evolves.