DAMA Certified Data Management Professional (CDMP)

Which DAMA-DMBoK 2 role is accountable for the business meaning of a data element, including its definition, valid values, and quality rules?

• AData Steward
• BDatabase Administrator
• CData Custodian
• DData Architect

DMBoK distinguishes between the Data Governance Council and the Data Management Executive. Which best describes the Council?

• AA cross-functional decision-making body that approves policies, standards, and stewardshi…
• BAn IT operations team that runs nightly ETL jobs
• CA vendor-led group that selects database products
• DA regulatory auditor that signs off on every data change

Which DMBoK governance operating model relies on local stewards in each business unit who coordinate through a central council?

• AFederated
• BCentralized
• CDecentralized
• DOutsourced

In DMBoK, what is the primary deliverable of the Data Governance function?

• AData strategy, policies, standards, and procedures aligned to business objectives
• BPhysical database backups stored offsite
• CSource code for ETL jobs
• DVendor licensing contracts

Which DMBoK environmental factor describes the methods, techniques, and procedures used to perform data management work?

• APractices and Methods
• BGoals and Principles
• CTools
• DRoles and Responsibilities

A new data policy is drafted but the steward of the affected domain has not approved it. Per DMBoK, what is the correct next step?

• ARoute the policy to the steward for review and approval before publication
• BPublish the policy because IT has already implemented it
• CDiscard the policy and rely on tribal knowledge
• DEscalate directly to the board, bypassing the steward

Which statement best contrasts a Data Steward with a Data Custodian?

• AThe Steward owns business meaning and quality, while the Custodian operates the systems t…
• BThe Steward writes SQL, while the Custodian writes business definitions
• CSteward and Custodian are interchangeable titles
• DThe Steward is a vendor, while the Custodian is an employee

Which DMBoK artifact catalogs authoritative data definitions, owners, and rules at the enterprise level?

• ABusiness Glossary
• BData dictionary for a single application
• CETL job catalog
• DHardware asset inventory

DMBoK distinguishes 'data governance' from 'data management'. Which statement captures the difference?

• AData governance is the exercise of authority and control over data assets; data managemen…
• BData governance and data management are synonyms
• CData governance is a tool, while data management is a process
• DData governance only applies to PII; data management applies to everything

An organization wants to measure the success of its data governance program. Which metric set best aligns with DMBoK guidance?

• APolicy adoption rate, issue resolution time, steward coverage, and value of decisions ena…
• BNumber of databases backed up nightly
• CAverage CPU utilization on the data warehouse
• DTotal dollars spent on storage hardware

Which DMBoK principle states that data should be governed as an enterprise asset rather than as the property of any single department?

• AData is a shared enterprise asset
• BData is owned by the IT department
• CEach application owns its own data
• DData is owned by the vendor that provides the database

Which model represents data and its relationships in business terms, independent of any technology?

• AConceptual data model
• BLogical data model
• CPhysical data model
• DDatabase deployment diagram

Which normal form requires that every non-key attribute be fully functionally dependent on the entire primary key?

• ASecond Normal Form (2NF)
• BFirst Normal Form (1NF)
• CThird Normal Form (3NF)
• DBoyce-Codd Normal Form (BCNF)

Which modeling notation is most associated with crow's-foot relationships and is widely used for relational logical models?

• AInformation Engineering (IE)
• BIDEF1X
• CUML class diagram
• DEntity-Attribute-Value (EAV)

Which DMBoK term describes a model that captures attributes, keys, and relationships in technology-neutral but fully detailed form?

• ALogical data model
• BConceptual data model
• CPhysical data model
• DView definition

Which dimensional modeling technique models a fact at its lowest possible level of detail?

• AAtomic grain fact table
• BAggregated summary fact
• CSnapshot dimension
• DBridge table