Practice — DWB11-052–068
DWB11-052 — BI Tools & Techniques · Difficult · Distinguish
How does impact analysis differ from lineage? - A. Impact analysis measures query speed while lineage measures user count. - B. Impact analysis is only a BI visualization technique. - C. They are identical. - D. Impact analysis asks what components would be affected by a proposed change; lineage traces origin and movement relationships.
DWB11-053 — BI Tools & Techniques · Standard · Understand
Which capability should a warehouse data-integration tool support beyond transformation logic? - A. Process audit, control, restart and scheduling. - B. Only dashboard rendering. - C. Only business glossary authoring. - D. Only OLAP cube design.
DWB11-054 — BI Tools & Techniques · Standard · Distinguish
Which description best fits operational reporting in Chapter 11? - A. Executive-only long-range strategic scorecards. - B. Reporting tied to operational or tactical business activity, sometimes directly against transactional systems and sometimes enhanced by ODS/DW data. - C. Only multidimensional cube analysis. - D. Only data-mining models.
DWB11-055 — BI Tools & Techniques · Standard · Recall
What is Business Performance Management (BPM) in the Chapter 11 BI portfolio? - A. A CDC technique. - B. A staging-area design. - C. Integrated processes and applications for assessing and managing metrics aligned with organizational strategy, such as budgeting and planning. - D. A source-to-target mapping standard.
DWB11-056 — BI Tools & Techniques · Difficult · Apply
Business users create dashboards and ad hoc analyses inside a governed portal with controlled privileges, shared content and support. What is this? - A. Unmanaged shadow analytics. - B. Operational Data Store. - C. Transaction-log CDC. - D. Self-service BI.
DWB11-057 — BI Tools & Techniques · Standard · Understand
Why should warehouse audit information be queryable at a useful grain? - A. It lets users verify data arrival/condition and supports detailed troubleshooting and confidence. - B. It replaces all production data. - C. It removes the need for lineage. - D. It is only for licensing audits.
DWB11-058 — BI Tools & Techniques · Standard · Apply
A team wants to prove an architectural approach and expose source-data quality issues before a large commitment. Which Chapter 11 technique fits best? - A. Skip discovery and buy the most popular tool. - B. Prototype using real representative data and user questions. - C. Build the final enterprise warehouse first. - D. Create only a project charter.
DWB11-059 — Implementation & Governance · Standard · Recall
Which item belongs on the Chapter 11 DW/BI readiness checklist? - A. Guarantee all source data is already perfect. - B. Eliminate business sponsorship after funding. - C. Define data sensitivity/security constraints and ensure business support, architectural approach, resources, tools and ingestion capability. - D. Forbid incremental delivery.
DWB11-060 — Implementation & Governance · Difficult · Apply
A warehouse team has a long-term target architecture but needs to deliver prioritized capabilities quarterly. What planning artifact best matches Chapter 11? - A. A one-time cutover plan only. - B. A source-system ERD. - C. A license inventory. - D. A release roadmap listing releases by date and capabilities.
DWB11-061 — Implementation & Governance · Standard · Understand
What is configuration management protecting in DW/BI? - A. Consistent versioning and transport of models, code, semantic layers and environment configuration across releases. - B. Only user passwords. - C. Only report formatting. - D. Only source data values.
DWB11-062 — Implementation & Governance · Standard · Apply
The business will not commit subject-matter experts to a major warehouse initiative. What does Chapter 11 suggest? - A. Proceed because DW/BI is an IT project. - B. Treat the lack of business-resource commitment as a serious failure condition and potentially halt until commitment is confirmed. - C. Replace SMEs with automated profiling only. - D. Skip requirements and use source-system definitions.
DWB11-063 — Implementation & Governance · Difficult · Distinguish
What is the intended role of DW/BI governance in Chapter 11? - A. Approve every query manually. - B. Replace the production support team. - C. Mitigate risk and define/monitor controls while remaining business-driven rather than arbitrarily blocking execution. - D. Prohibit all sandbox experimentation.
DWB11-064 — Implementation & Governance · Standard · Apply
What evidence should support business acceptance of warehouse data? - A. Only successful server startup. - B. Only the number of loaded rows. - C. Only executive approval of the dashboard color scheme. - D. Understandable definitions, verifiable Data Quality, demonstrable lineage, and UAT comparisons of BI results to source data.
DWB11-065 — Implementation & Governance · Standard · Distinguish
What should a DW/BI Service Level Agreement primarily define? - A. Business and technical service expectations such as response time, retention and availability appropriate to the environment. - B. Only the logical data model. - C. Only user training topics. - D. Only CDC method names.
DWB11-066 — Implementation & Governance · Standard · Understand
Which item belongs in a Chapter 11 reporting strategy? - A. Only a list of BI vendors. - B. Security/access, user-tool fit, report type/frequency/distribution/storage, visualization and timeliness-versus-performance trade-offs. - C. Only the dimensional model. - D. Only query response time targets.
DWB11-067 — Implementation & Governance · Difficult · Distinguish
Which measure is stronger evidence of actual DW/BI adoption than the number of licensed users? - A. Total storage capacity. - B. Number of source tables. - C. Connected/concurrent users and query activity over time. - D. Number of report colors.
DWB11-068 — Implementation & Governance · Expert-discrimination · Apply
A DW/BI program reports only '5,000 registered users.' Which measurement set would better demonstrate Chapter 11 effectiveness? - A. Only the registered-user count. - B. Only total warehouse terabytes. - C. Only the number of dashboards built. - D. Actual connected/query usage, subject-area coverage, load-window support, query/refresh performance, and customer satisfaction.