- What Is Domain 9 and Why It Matters
- Exam Weight in Context: 6% of Your Score
- Core DW/BI Concepts You Must Know Cold
- How DMBOK2 Frames Data Warehousing
- How Domain 9 Questions Are Written
- A Focused Study Block for Domain 9
- Domain 9 Intersections With Other CDMP Areas
- Registration, Fees, and Exam Logistics
- Frequently Asked Questions
- Domain 9 carries 6% of the 100-question CDMP exam, meaning roughly 6 questions determine your score in this area.
- The CDMP exam is open-book but 90 minutes is tight - knowing DMBOK2 chapter structure for DW/BI saves crucial lookup time.
- Associate level requires 60% overall; Practitioner requires 70% - every domain counts toward clearing those thresholds.
- Domain 9 overlaps heavily with Domain 6 (Data Integration) and Domain 10 (Metadata) - study them as a connected cluster.
What Is Domain 9 and Why It Matters
Data Warehousing and Business Intelligence (DW/BI) is Domain 9 of the CDMP exam, governed by DAMA International and based on the DAMA Data Management Body of Knowledge version 2 (DMBOK2) Revised Edition. For many candidates, this is the domain that feels most familiar - if you've worked with Kimball-style dimensional models, reporting layers, or enterprise analytics platforms, you'll recognize the territory. But familiarity is a trap. The CDMP exam tests how well you understand the discipline of DW/BI management, not just whether you've used the tools.
Domain 9 sits within a broader ecosystem of 14 exam domains. While it carries 6% of the overall exam weight, it's a domain where strong preparation often pays dividends into adjacent areas, particularly Data Integration and Interoperability (Domain 6) and Metadata Management (Domain 10). Professionals who hire CDMP-certified data practitioners - enterprise analytics teams, consulting firms, financial institutions, and government data offices - specifically value this domain because it signals an ability to design and govern BI environments, not just operate inside them.
Exam Weight in Context: 6% of Your Score
The CDMP Fundamentals exam consists of 100 multiple-choice questions answered in 90 minutes (ESL candidates receive an additional 20 minutes). Domain 9 accounts for 6% of those questions - roughly six questions on a standard exam administration. That number matters more than it might appear.
To earn Associate level, you need a 60% overall score. To reach Practitioner, you need 70% on the Fundamentals exam plus two specialist exams. For Master, the threshold rises to 80% on Fundamentals, plus two specialist exams and an experience assessment. At the Master level, leaving Domain 9 points on the table is a real risk - every 6-question domain becomes meaningful when you're chasing 80%.
| Certification Level | Fundamentals Pass Score | Additional Requirements | Impact of Domain 9 |
|---|---|---|---|
| Associate | 60% | None beyond Fundamentals | Low direct pressure, but contributes to overall floor |
| Practitioner | 70% | Two specialist exams | Moderate - 6 questions matter at 70% threshold |
| Master | 80% | Two specialist exams + experience assessment ($50) | High - minimal margin for missed domains |
Note also the exam fee structure: $300 base plus an $11 online proctoring fee for a total of $311. If you need to retake, the discounted retake fee is $200 plus $11 proctoring. That's real money, and it reinforces the case for thorough Domain 9 preparation the first time. For details on what happens if you don't pass, see the CDMP Exam Retake Policy: Fees, Rules and Next Steps before you sit.
Core DW/BI Concepts You Must Know Cold
The CDMP does not test vendor-specific tools. It tests your understanding of DW/BI as a data management discipline. The following conceptual areas appear consistently in Domain 9 questions and require precise, not approximate, understanding.
Data Warehousing Architecture Fundamentals
Candidates must distinguish between operational systems and analytical environments and understand the architectural layers of a data warehouse.
- Differences between OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing) systems
- Enterprise Data Warehouse (EDW), Data Mart, and Operational Data Store (ODS) - their definitions, purposes, and relationships
- Staging areas and their role in ETL workflows
- Lambda and Kappa architectures at a conceptual level (relevant given DMBOK2's updated content)
Dimensional Modeling Concepts
DMBOK2 gives significant coverage to dimensional modeling principles. You don't need to be an expert data modeler, but you must understand the vocabulary.
- Fact tables vs. dimension tables - what each stores and why
- Star schema vs. snowflake schema - structural differences and trade-offs
- Slowly Changing Dimensions (SCDs) - Type 1, Type 2, and Type 3 handling strategies
- Grain definition - why establishing the grain is the foundational step in dimensional design
- Conformed dimensions and their role in enterprise-wide consistency
ETL vs. ELT and Data Integration Approaches
The line between Domain 9 and Domain 6 (Data Integration and Interoperability) is deliberately blurry in DMBOK2. Candidates must understand how data moves into and through a warehouse.
- Extract, Transform, Load (ETL) - traditional pipeline model
- Extract, Load, Transform (ELT) - cloud-native pattern where transformation happens inside the warehouse
- Data lineage concepts as they apply to BI reporting accuracy
- Change Data Capture (CDC) methods for incremental loading
Business Intelligence Functions and Governance
BI is not just reporting - DMBOK2 treats it as a managed capability requiring governance structures, definitions, and quality controls.
- Types of BI outputs: dashboards, scorecards, ad hoc reports, self-service analytics
- The difference between metrics, KPIs, and dimensions in a business context
- Data virtualization as an alternative to physical data movement
- BI governance: controlling report definitions, metric ownership, and version management
- The role of a data dictionary and business glossary in supporting BI accuracy
How DMBOK2 Frames Data Warehousing
The CDMP exam is grounded exclusively in the DMBOK2 Revised Edition. For Domain 9, that means reading Chapter 11 of the DMBOK2 carefully. DAMA frames DW/BI as a knowledge area with specific activities, roles, tools, and techniques - not just a technology category.
Key DMBOK2 constructs you should internalize for Domain 9 include the concept of data warehouse as a subject-oriented, integrated, time-variant, nonvolatile collection of data - that four-part definition (originally from Bill Inmon) appears in DMBOK2 and is testable. You should also understand DAMA's perspective on the relationship between data warehousing and data governance: a DW environment without governance produces inconsistent reporting, and DMBOK2 is explicit about this dependency.
DMBOK2 also distinguishes between the data warehouse as infrastructure and business intelligence as capability. Questions that conflate the two are designed to test whether you understand this separation. A data warehouse is a technical environment. BI is the set of processes, tools, and practices that turn warehouse data into actionable insights. Both require management; they require different types of management.
How Domain 9 Questions Are Written
CDMP multiple-choice questions for Domain 9 tend to follow several recognizable patterns. Understanding these patterns - not just the content - improves your accuracy.
Definition questions ask you to identify the correct DMBOK2 definition for a term. For Domain 9, common targets include grain, conformed dimension, ODS, and data mart. Wrong answers are usually plausible paraphrases that change a key word - "integrated" becomes "aggregated," for example.
Scenario-based questions describe a data environment and ask what approach or concept best applies. These might describe a company migrating from an on-premises EDW to a cloud platform and ask which architectural consideration is most relevant from a DW/BI management perspective. The correct answer is grounded in DMBOK2 principles, not vendor recommendations.
Relationship questions test how well you understand the connections between Domain 9 concepts and other domains. A question might ask how metadata management supports BI reporting accuracy, requiring you to connect Domain 9 and Domain 10. These questions reward candidates who have studied the DMBOK2 holistically, not chapter by chapter in isolation.
Using a high-quality CDMP practice test platform before your exam date is the most reliable way to encounter Domain 9 questions in their actual format. The free 40-question practice exam included with purchase draws from a bank of 200 questions - a meaningful sample, but domain-specific drilling across all 14 areas is what builds true readiness.
A Focused Study Block for Domain 9
Because Domain 9 is a 6% domain - medium-weight, not among the top five - it fits best as part of a cluster study strategy where you address related domains in sequence. The most effective approach pairs Domain 9 with Domain 6 (Data Integration and Interoperability, also 6%) and Domain 10 (Metadata Management, 11%), since DMBOK2 treats these as deeply interconnected knowledge areas.
DMBOK2 Chapter 11 - Full Read
- Read Chapter 11 completely without stopping to memorize; build mental map
- Note every bolded term and its DMBOK2 definition
- Flag the four-part data warehouse definition and the ETL vs. ELT distinction
Dimensional Modeling Deep Dive
- Review star schema, snowflake schema, SCD Types 1-3 with concrete examples
- Write out the grain concept in your own words - then compare to DMBOK2 language
- Cross-reference with Domain 3 (Data Modeling and Design) notes for shared vocabulary
BI Governance and Metadata Connections
- Study BI governance structures: metric ownership, report versioning, business glossary role
- Review how Domain 10 (Metadata) supports DW/BI - this is a common question source
- Identify at least three DMBOK2 statements connecting metadata to warehouse management
Practice Questions and Gap Analysis
- Run 20-30 Domain 9 practice questions on the CDMP practice test platform
- For every wrong answer, locate the relevant DMBOK2 passage - don't just note the correct answer
- Flag any concept you needed to look up; those are your re-study targets
This five-day block assumes Domain 9 is one stop in a larger multi-week study plan covering all 14 domains. Candidates targeting Master level (80% threshold) should allocate more time to Domain 9 re-review in the final week before their exam, particularly on the BI governance and metadata intersection topics, where questions tend to have subtler wrong-answer distractors.
Domain 9 Intersections With Other CDMP Areas
One characteristic of the CDMP exam that distinguishes it from narrower certification exams is its emphasis on how data management disciplines interact. Domain 9 does not exist in isolation in DMBOK2, and the exam reflects that.
Domain 3 - Data Modeling and Design (11%): Dimensional modeling is both a Domain 9 topic and a topic that builds directly on Domain 3 modeling fundamentals. Fact tables, dimension tables, and normalization decisions are shared vocabulary. Strong Domain 3 preparation reinforces Domain 9.
Domain 6 - Data Integration and Interoperability (6%): ETL/ELT pipelines, data movement architectures, and integration patterns are covered in Domain 6 but constantly referenced in Domain 9. The DMBOK2 chapters cross-reference each other explicitly. Study these together if your schedule allows.
Domain 10 - Metadata Management (11%): This is the most frequently tested intersection with Domain 9. Business metadata (definitions of metrics, report logic, KPI calculations) lives in a business glossary and data dictionary - both Metadata Management artifacts. Questions that ask how to ensure BI report accuracy or consistency almost always have answers rooted in metadata governance.
Domain 11 - Data Quality (11%): Poor source data quality propagates through ETL pipelines into warehouse tables and ultimately into executive dashboards. DMBOK2 is explicit that DW/BI environments require upstream data quality controls. Expect questions that connect these two domains. For comprehensive study guidance on the full credential, the CDMP Domain 9: Data Warehousing and BI Study Guide 2026 is the canonical starting resource on this site.
Key Takeaway
Don't treat Domain 9 as a standalone island. The CDMP exam is designed to test data management as an integrated discipline. Candidates who score best in Domain 9 have typically studied it alongside Domains 6, 10, and 11 - not in sequence with no cross-referencing.
Registration, Fees, and Exam Logistics
The CDMP exam is administered by DAMA International as an online proctored exam available worldwide. The total cost for a first attempt is $311 ($300 exam fee plus $11 online proctoring fee). If you do not pass, the retake fee is discounted to $200 plus $11 proctoring, for a total of $211 per retake attempt.
As of the August 2024 policy update, exams must be taken within 12 months of enrollment. This is a hard deadline - enrollment does not grant indefinite access to the exam. Plan your study timeline with this window in mind, and don't enroll until you have a realistic schedule to complete preparation within the year.
There are no formal prerequisites for the Associate level. You do not need a specific degree, prior certification, or years of experience to sit for the Fundamentals exam. However, Practitioner and Master levels require additional components - specialist exams and, for Master, an experience assessment with a $50 fee.
Initial certification is valid for three years. CDMP is held by more than 10,000 professionals across 60+ countries, making it one of the most internationally recognized data management credentials available.
If you're unsure whether your Domain 9 preparation is at the right level before booking your exam, spend time on the CDMP practice test platform to benchmark yourself. The free 40-question sample draws from a bank of 200 questions and gives you a realistic preview of question difficulty and format before you commit to a $311 exam fee.
Frequently Asked Questions
Domain 9 accounts for 6% of the 100-question CDMP Fundamentals exam, which translates to approximately 6 questions. The exact number may vary slightly between exam versions, but 6% is the published domain weight used for study planning purposes.
Yes, the exam is open-book, meaning you may reference the DMBOK2 during the exam. However, with 100 questions in 90 minutes, you have less than 60 seconds per question on average. Relying on looking up Domain 9 definitions during the exam is a significant time risk. The open-book policy benefits candidates who know where to find information quickly - not those who haven't studied.
Chapter 11 of the DMBOK2 Revised Edition covers Data Warehousing and Business Intelligence. This is the primary source material for Domain 9 exam questions. Candidates should read this chapter thoroughly and note all defined terms, activity descriptions, and framework components.
DAMA's current specialist exam offerings include Data Governance, Data Quality, Data Modeling, Metadata, and others. Data Warehousing and BI is not currently listed as a standalone specialist exam track. Practitioner and Master candidates who want to specialize should review the current DAMA specialist exam catalog to select the two required specialist exams for their certification path.
The retake fee is $200 plus $11 proctoring ($211 total). Your Domain 9 preparation approach should be informed by score feedback - if you know Domain 9 was a weak area, prioritize re-reading DMBOK2 Chapter 11 and running additional practice questions before retaking. For full details on retake rules and timelines, see the CDMP Exam Retake Policy: Fees, Rules and Next Steps.