Practice — DWB11-035–051
DWB11-035 — DW/BI Activities · Standard · Recall
What should the DW/BI architecture describe? - A. Only the physical server list. - B. Only report layouts. - C. Where data comes from, where it goes, when it goes, why it goes, and how the environment supports that movement and use. - D. Only the source-system data dictionary.
DWB11-036 — DW/BI Activities · Difficult · Understand
Why does Chapter 11 recommend mechanisms that can connect analytical results back to transactional detail? - A. The warehouse should never store atomic data. - B. Operational systems should replace the warehouse. - C. BI tools cannot display historical data. - D. Users may need original operational detail without forcing the warehouse to carry every non-analytical field.
DWB11-037 — DW/BI Activities · Standard · Recall
Which three development tracks normally proceed concurrently in a DW/BI project? - A. Data, Technology, and Business Intelligence tools. - B. Governance, Privacy, and Audit. - C. Facts, Dimensions, and Cubes. - D. Plan, Build, and Retire.
DWB11-038 — DW/BI Activities · Standard · Understand
What does source-to-target mapping accomplish? - A. Defines only report colors and formats. - B. Documents how source entities/elements map and transform to targets and establishes lineage back to source systems. - C. Replaces Data Quality remediation. - D. Assigns BI licenses to users.
DWB11-039 — DW/BI Activities · Standard · Distinguish
Why is a solid taxonomy or logical data model useful during source-to-target mapping? - A. It guarantees source data is accurate. - B. It eliminates the need for transformation rules. - C. It provides a consistent semantic structure for reconciling differently named or structured source elements. - D. It determines query response times.
DWB11-040 — DW/BI Activities · Standard · Apply
A source contains invalid state codes that must be corrected and standardized before historical loading. Which activity is most direct? - A. BI portfolio implementation. - B. Release management. - C. Subject-area coverage measurement. - D. Data remediation/cleansing.
DWB11-041 — DW/BI Activities · Standard · Distinguish
How does transformation differ from remediation in Chapter 11? - A. Transformation implements business/integration rules in the technical system; remediation corrects or standardizes problematic values. - B. Transformation measures user adoption while remediation measures latency. - C. Transformation is only for reports while remediation is only for facts. - D. There is no distinction.
DWB11-042 — DW/BI Activities · Difficult · Apply
A fact arrives before its corresponding dimension member, but the business permits a provisional dimension entry so the fact can load. What strategy is this? - A. Pessimistic recycle. - B. Optimistic loading. - C. Full historical reload. - D. Production-reporting fallback.
DWB11-043 — DW/BI Activities · Difficult · Apply
A fact cannot resolve to a required dimension and policy forbids creating a placeholder. What should the load process do? - A. Silently drop the fact. - B. Create a random dimension key. - C. Place the fact in a recycle/reject area, alert/report it, and reload later after resolution. - D. Convert the fact to a BI report.
DWB11-044 — DW/BI Activities · Standard · Understand
Which set of factors should shape the warehouse population approach? - A. Only server CPU and disk size. - B. Only report layout and color. - C. Only user training schedules. - D. Latency, source availability, batch windows, targets, dimensional needs, time consistency, Data Quality, transform time, late-arriving dimensions and rejects.
DWB11-045 — DW/BI Activities · Standard · Apply
Executives, power users and front-line staff are forced into the same BI interface despite very different needs. What Chapter 11 action is missing? - A. Group users according to needs and match tools/capabilities to those requirements. - B. Normalize the data mart. - C. Replace the ODS with staging. - D. Increase full-load frequency.
DWB11-046 — DW/BI Activities · Standard · Understand
Why is a standard release plan important for a warehouse? - A. It prevents any changes after go-live. - B. It supports proactive resource planning, predictable delivery, continuous enhancement and product-centric management. - C. It replaces UAT. - D. It removes the need for business prioritization.
DWB11-047 — DW/BI Activities · Difficult · Apply
A sandbox analytical model looks promising. What must happen before Chapter 11 would treat it as a production data product? - A. Promote it immediately because business users created it. - B. Move it directly into staging and call it production. - C. It should pass pilot evaluation and be deemed production-ready by both business and IT, including quality/governance considerations. - D. Ignore downstream Data Quality because it is only analytics.
DWB11-048 — DW/BI Activities · Standard · Apply
A report runs thousands of times per day and is consistently slow. What response best matches Chapter 11? - A. Tune random unused queries first. - B. Disable monitoring to reduce overhead. - C. Replace the warehouse with an operational database. - D. Use usage statistics to tune the high-impact workload, potentially with indexes, aggregations, or precomputed results.
DWB11-049 — BI Tools & Techniques · Standard · Understand
Why is an integrated Metadata repository especially important in large DW/BI environments? - A. Organizations often use many tools/versions, so Metadata must be stitched together to explain data and processes end-to-end. - B. It is the only place warehouse data can be stored. - C. It replaces the logical data model. - D. It eliminates the need for Data Governance.
DWB11-050 — BI Tools & Techniques · Standard · Distinguish
What is the primary purpose of a DW data dictionary/glossary? - A. Track only server configuration. - B. Explain data in business terms, including information needed to understand and use it. - C. Schedule CDC jobs. - D. Measure subject-area coverage.
DWB11-051 — BI Tools & Techniques · Standard · Apply
An analyst asks, 'Where did this metric originate and what transformations produced it?' Which capability is most direct? - A. Usage metrics. - B. Business performance management. - C. Data lineage. - D. OLAP aggregation.