DQ-1220 DAMA Data Quality Specialist Questions and Answers
A control chart shows a stable defect rate for several weeks, followed by one point far outside the established control limits. This most strongly indicates:
Options:
A special cause requiring investigation
Normal random variation only
A metadata definition
A guaranteed improvement
Answer:
AExplanation:
A point materially outside established control limits is a classic signal of special-cause variation. Statistical Process Control distinguishes routine variation inherent in a stable process from unusual variation introduced by an identifiable event or change.
When a Data Quality process normally produces a stable percentage of invalid records and a sudden observation lies beyond the expected statistical range, investigation should focus on what changed. Possible causes include a new source system, software deployment, changed mapping, revised business rule, unusual batch, or manual processing error.
The current DMBOK2 Chapter 13 revision retains Statistical Process Control concepts while reorganizing them into supporting material and explicitly maps Shewhart/Deming improvement stages to Data Quality processes.
The signal does not prove what caused the defect, nor does it establish that performance has improved or deteriorated permanently. It indicates that the observed variation is sufficiently unusual to justify analysis.
Quality teams should preserve the evidence, correlate the timing with system and process changes, use lineage to identify affected sources, and investigate before adjusting the process unnecessarily.
Reference Topics: DAMA-DMBOK2 Chapter 13 — Statistical Process Control; Control Charts; Common Cause; Special Cause; Continuous Improvement.
===============
A Data Quality team repeatedly corrects invalid postal codes in the warehouse, but the same errors reappear after every nightly load. What is the most appropriate long-term response?
Options:
Increase the number of cleansing scripts in the warehouse
Correct the source or integration process causing the defect
Ignore the issue because cleansing already works
Reduce the frequency of data loads
Answer:
BExplanation:
The correct long-term response is to remove the root cause in the source or integration process. Repeated warehouse cleansing treats symptoms. If the defect is recreated every night, operational costs continue and downstream systems remain exposed until the cleansing process executes.
DAMA Data Quality practice emphasizes sustained improvement rather than repeated correction. The quality lifecycle therefore includes identifying defects, determining business impact, analyzing root causes, implementing corrective actions, and monitoring results. The current Chapter 13 revision specifically strengthens clarification of the Data Quality Improvement Lifecycle and responsibilities within it.
The underlying cause might be weak source validation, an incorrect source-to-target mapping, outdated Reference Data, transformation logic, or missing governance over postal-code rules.
Cleansing remains appropriate where historical data must be repaired or immediate downstream protection is required. However, preventive control should be introduced as close to the creation point as practical.
Metadata and lineage help trace the postal code through the data flow, while governance establishes who has authority to change the offending process.
Reference Topics: DAMA-DMBOK2 Chapter 13 — Root-Cause Analysis; Remediation; Prevention; Cleansing; Data Integration and Lineage.
===============
Emergency contact phone number would be found in which master data management program?
Options:
Product
Asset
Employee
Answer:
CExplanation:
An emergency contact phone number belongs to the Employee master-data domain. Employee Master Data describes relatively stable information about employees that needs to be consistently identified and reused across organizational processes and systems. Contact details associated with an employee—including emergency-contact information—therefore fall naturally within an Employee MDM program rather than Product or Asset MDM.
The broader DAMA Master Data framework identifies employees as one of the recurring enterprise entities that may require coordinated management alongside customers, products, suppliers, locations, and similar core subjects. Published versions of this specific DAMA certification item likewise identify Employee as the correct domain.
Managing this information centrally or through coordinated master-data processes helps prevent conflicting phone numbers, obsolete emergency contacts, duplicate employee identities, and inconsistent values across Human Resources and other authorized systems.
The data is also sensitive personal information. Governance should therefore define ownership, access rights, retention rules, and permitted usage. Quality controls should address completeness, validity, currency, and accuracy, because outdated emergency-contact information may fail precisely when it is needed.
Metadata Management should record definitions and classifications so that “emergency contact phone number” is consistently distinguished from an employee's own mobile or work telephone number.
Reference Topics: DAMA-DMBOK2 Chapter 10 — Master Data Domains; Employee Master Data; Data Governance; Chapter 13 — Accuracy, Completeness and Currency.
===============
Which DMBoK knowledge area is most likely responsible for a high percentage of returned mail?
Options:
Data Integration and Interoperability
Metadata Management
Data Warehousing and Business Intelligence
Reference and Master Data
Data Quality
Answer:
EExplanation:
A high percentage of returned mail is primarily a Data Quality problem. Returned correspondence frequently results from inaccurate, incomplete, obsolete, incorrectly formatted, or otherwise unusable address data. The operational symptom therefore indicates that address information is failing to meet its intended business purpose.
Published versions of this DAMA question identify Data Quality as the intended knowledge area. The underlying principle aligns directly with DMBOK2 Chapter 13: quality is assessed relative to the requirements of the business process consuming the data.
Several quality dimensions may contribute. Accuracy concerns whether the address correctly represents the customer's actual location. Completeness concerns missing apartment numbers, postal codes, or address components. Validity evaluates whether values conform to accepted formats and domains. Currency addresses whether a previously correct address has become obsolete. Consistency can also be involved where address information differs between systems.
Reference and Master Data Management may provide customer-master consolidation and standardized geographic reference values, but the direct defect represented by returned mail is poor-quality address data.
A mature response should involve profiling returned-mail records, determining defect patterns and root causes, establishing address-quality rules, correcting affected records, and introducing preventive validation at capture.
Reference Topics: DAMA-DMBOK2 Chapter 13 — Fitness for Purpose; Accuracy; Completeness; Validity; Currency; Profiling; Root-Cause Analysis.
===============
In data security, which of the following is not one of the four A's:
Options:
Audit
Agile
Authentication
Access
Authorization
Answer:
BExplanation:
Agile is not one of the four A's of Data Security. DAMA security guidance groups core security processes around Access, Audit, Authentication, and Authorization. These capabilities collectively control who can interact with information resources, establish identity, determine permitted actions, and provide evidence of activity for monitoring and accountability. DAMA-aligned security references identify these four concepts directly.
Authentication confirms the identity of a user or system. Authorization determines what an authenticated identity is permitted to do. Access concerns the actual ability to obtain or interact with data and services. Audit provides traceability by recording and reviewing relevant activities.
Agile, by contrast, is an approach to iterative delivery and project or product development. It may influence how security controls are implemented within development lifecycles, but it is not itself one of the foundational security-control categories identified in this model.
Data Security and Data Quality are separate but related disciplines. Unauthorized modifications can compromise accuracy and integrity, while weak auditability can prevent organizations from identifying how data was altered. Appropriate security controls therefore help preserve the reliability of governed information.
Metadata classification also supports these controls by identifying sensitive data and linking it to access and protection requirements.
Reference Topics: DAMA-DMBOK2 Chapter 7 — Data Security; Access; Authentication; Authorization; Audit; Data Governance; Chapter 13 — Integrity and Controlled Data Modification.
===============
What are the types of models that are modelled in data models?
Options:
Category Information
Business Event Information
Resource Information
All of these
Detail Transaction Information
Answer:
DExplanation:
DAMA-DMBOK2 identifies four principal types of data that may be represented in data models: Category Information, Resource Information, Business Event Information, and Detail Transaction Information. Because options A, B, C and E are all legitimate categories, All of these is correct.
Category information classifies things—for example, classifying customers by market segment or products by size or colour. Resource information represents business resources required for operations, including entities such as Customer, Product, Supplier, Facility and Account. These resource entities frequently overlap strongly with Master and Reference Data Management.
Business event information records events created during operational processes, such as orders, invoices or withdrawals. Detail transaction information represents highly granular observations, including point-of-sale records, clickstream data, social-media interactions, sensor outputs and other high-volume events.
This classification matters to Data Quality because quality controls must reflect the semantics and lifecycle of the data being evaluated. Reference and master data require strong uniqueness, definition and consistency controls; event data require integrity and timeliness; high-volume detailed data often require automated profiling and statistical monitoring.
Data models also generate important metadata—definitions, relationships, domains and constraints—which becomes the basis for measurable Data Quality rules.
Reference Topics: DAMA-DMBOK2 Chapter 5 — Types of Data that are Modeled; Chapter 10 — Reference and Master Data; Chapter 13 — Data Quality Rules and Dimensions; Metadata Management.
===============
Periodic archiving of transaction data from a production CRM system is critical for:
Options:
Training junior DBAs
Providing alternate sources for reporting systems
Managing deleted customer records
The maintenance of database performance
Enabling the distribution of transaction data across the enterprise
Answer:
DExplanation:
Periodic archiving is critical for maintaining database performance. As a production CRM accumulates historical transactions, active tables and indexes can become increasingly large. This increases storage consumption, backup duration, index-maintenance overhead, and the quantity of data that database engines must process during operational queries.
DAMA-DMBOK2 treats archiving as an important Data Storage and Operations activity. Historical information that remains subject to retention requirements but is no longer frequently needed for operational processing can be moved to suitable archival storage. DAMA-aligned guidance for this scenario specifically links periodic transaction archiving with maintaining production database performance.
Archiving is not the same as arbitrary deletion. Retention policies, legal obligations, recovery requirements, auditability, and business value determine how long data must remain accessible and where it should be stored. The archive must also be recoverable and appropriately secured.
Data Quality implications include maintaining integrity and traceability during migration to the archive. Records should remain complete, relationships should be preserved, and metadata should indicate retention status and archival location.
Providing reporting sources or managing deleted customers may be secondary considerations, but neither is the principal purpose described in the question.
Reference Topics: DAMA-DMBOK2 Chapter 6 — Data Storage and Operations; Archiving; Database Performance; Retention; Chapter 13 — Integrity and Historical Data.
===============
A pensioner who usually receives a quarterly bill of around $300 was sent a $100,000,000 electricity bill. They were a victim of poor data quality checks in which dimension?
Options:
Integrity
Accuracy
Currency
Timeliness
Reasonableness
Answer:
EExplanation:
The failed control is principally Reasonableness. DAMA treats reasonableness as the extent to which data values or patterns conform to credible expectations. The current DMBOK2 revision recognizes Reasonableness among the standard Data Quality dimensions, alongside Accuracy, Validity, Completeness, Integrity, Uniqueness, Timeliness, Currency and Consistency.
A $100,000,000 residential electricity bill may be syntactically valid: the field may accept the number, the record may satisfy referential constraints, and the value may have arrived on time. Nevertheless, it is grossly inconsistent with the customer's historical pattern of approximately $300 per quarter. A reasonableness control would therefore compare the amount with expected ranges, historical consumption, statistical limits, peer-group distributions, or business thresholds and flag the value before billing.
This illustrates an important distinction from Accuracy. Accuracy asks whether the stored value correctly represents reality. Reasonableness asks whether the value is credible in context. The absurd magnitude itself is detectable without first obtaining an independently verified “true” bill value.
Practical controls include range checks, deviation-from-history rules, z-score/outlier detection, control limits, and exception thresholds. Such rules should be governed as metadata and owned by an appropriate Data Steward.
Reference Topics: DAMA-DMBOK2 Chapter 13 — Data Quality Dimensions; Reasonableness; Measurement and Monitoring; Statistical Process Control; Data Quality Rules.
===============
An effective Data Governance communication program should include the following:
Options:
Regular newsletters
All answers
Events that encourage informal networking
A custom training program
A Data Governance Portal
Answer:
BExplanation:
An effective Data Governance communication program should employ multiple complementary communication mechanisms, making All answers correct. Governance changes how people define, create, use, approve, and resolve issues with data; consequently, sustained adoption requires more than publishing policies.
Regular newsletters keep stakeholders aware of progress, decisions, metrics, and upcoming activities. A Data Governance Portal provides a persistent location for policies, standards, stewardship information, glossaries, issue processes, and supporting materials. Custom training develops the capabilities required for individuals to understand their specific governance responsibilities. Informal networking events help establish relationships across business and technical groups, which is particularly important when resolving data ownership and definition conflicts.
DAMA-DMBOK2 treats communication and organizational change as core implementation considerations because governance depends on participation across functions rather than on a single technical team. Published CDMP material for this item identifies the combined response—newsletters, portal, training, and networking—as the intended answer.
For Data Quality, communication ensures that quality definitions, issue-management procedures, stewardship responsibilities, thresholds, and remediation decisions are understood and consistently applied.
Reference Topics: DAMA-DMBOK2 Chapter 3 — Governance Communications; Organizational Change; Training; Data Governance Portal; Stewardship Engagement; Chapter 13 — Data Quality Culture.
===============
The creation of overly complex enterprise integration over time is often a symptom of:
Options:
Multiple integration technologies
Multiple data warehouses
Multiple application coding languages
Multiple data owners
Multiple metadata tags
Answer:
AExplanation:
The strongest indicator is the uncontrolled proliferation of multiple integration technologies. Enterprise integration environments often become progressively more complex when different projects independently adopt different ETL platforms, messaging products, APIs, middleware technologies, replication mechanisms, file-transfer approaches, and proprietary interfaces.
The problem is architectural fragmentation. Each integration technology introduces its own configuration methods, transformation logic, monitoring mechanisms, metadata, failure handling, security controls, support skills, and operational procedures. As the number of technologies increases, point-to-point dependencies multiply and the organization accumulates technical debt. This makes end-to-end lineage, troubleshooting, change-impact analysis, and consistent application of Data Quality rules significantly harder. The source question itself identifies this specific integration-management issue. DAMA-oriented exam material likewise identifies multiple integration technologies as the characteristic cause of an overly complex integration landscape.
DAMA-DMBOK2 therefore emphasizes managed Data Integration and Interoperability architecture, reusable patterns, common models, governed interfaces, and metadata describing transformations.
From a Data Quality perspective, uncontrolled integration technology can result in inconsistent transformations, duplicated cleansing rules, mismatched reference values, and poorly understood lineage. Standardization reduces these risks by making movement and transformation processes more transparent and governable.
Reference Topics: DAMA-DMBOK2 Chapter 8 — Data Integration and Interoperability; Integration Architecture; Metadata and Lineage; Chapter 13 — Quality Controls Across Data Movement.
===============
Project costs will increase faster by adding to the data model than adding to the process model because:
Options:
Each additional data item increases the complexity of data migration
Each additional data item drives an increase in storage space
Each additional data item adds complexity to the data warehouse
Each additional data item adds a number of processes to fully manage it
Each additional data item drives an increase in security risk of the data
Answer:
DExplanation:
Each additional data item creates obligations across multiple lifecycle processes, which is why option D is the most complete answer. DAMA-DMBOK2 treats data as an asset that must be managed throughout an interconnected lifecycle rather than merely stored in a database. Activities include creation or acquisition, validation, integration, transformation, storage, maintenance, access, use, protection, retention, archiving, and disposal.
Consequently, introducing another meaningful data element may require changes to data models, metadata repositories, interfaces, mappings, business rules, validation controls, security classifications, quality measurements, lineage documentation, reporting logic, retention rules, and stewardship responsibilities. The cost is therefore cumulative across several management processes.
Option A identifies only migration. Option B reduces the impact to storage, which is usually a minor component. Option C applies only where a warehouse is involved. Option E identifies one legitimate consideration—security—but security is only one part of the complete management obligation.
The Data Quality implication is substantial. Every additional Critical Data Element may require explicit definitions of validity, completeness, accuracy, timeliness, and consistency, together with monitoring and issue-management procedures. This demonstrates why organizations should avoid collecting data indiscriminately and should manage data according to genuine business value and requirements.
Reference Topics: DAMA-DMBOK2 Chapter 1 — Data Lifecycle; Data as an Asset; Chapter 5 — Data Modeling; Chapter 13 — Data Quality Requirements and Monitoring.
===============
A Data Quality rule states that every active supplier must have a valid tax identifier. Who should approve whether the rule is mandatory for the Supplier domain?
Options:
Appropriate business governance/stewardship authority
Any developer working on the database
The network administrator
The storage vendor
Answer:
AExplanation:
Whether the rule is mandatory is a business governance decision and should be approved through the appropriate Data Owner, Data Steward, or governance authority responsible for the Supplier domain.
A developer can implement a database constraint, but technical implementation does not establish business policy. The organization must determine whether every active supplier genuinely requires a tax identifier, whether exceptions exist by jurisdiction or supplier type, and what consequences should follow when the rule is violated.
The approved rule should be documented as metadata and linked to the relevant business term, physical fields, authoritative sources, threshold, and responsible steward.
This illustrates the separation between governance and execution. Governance defines and authorizes the requirement; operational and technical teams implement the validation and monitoring.
DAMA's public framework places Governance across the Data Management knowledge areas and Metadata Management as the mechanism for maintaining definitions, lineage, and usage context.
Reference Topics: DAMA-DMBOK2 Chapter 3 — Governance and Stewardship; Chapter 13 — Data Quality Rules; Metadata Management; Supplier Master Data.
===============
Descriptive metadata describes a resource, enabling its identification and retrieval.
Options:
For example, a document has a number of pages, number of chapters and word count
For example, a book has author, title and subject associated with it
For example, a car has a wheel, an engine and a transmission
For example, a record has version number, archive dates and purge dates
For example, a lump of coal burns about 100 degrees and gives off carbon dioxide
Answer:
BExplanation:
DAMA-DMBOK2 distinguishes descriptive, structural, and administrative metadata when discussing metadata classifications used outside conventional IT contexts. Descriptive metadata identifies and describes a resource sufficiently to enable discovery and retrieval. DMBOK2 gives title, author, and subject as explicit examples of descriptive metadata.
A book's author, title, and subject therefore answer practical discovery questions: What is the resource? Who created it? What is it about? These attributes allow catalogues, repositories, search tools, and users to identify and retrieve the required resource.
Option A is principally structural metadata. DMBOK2 specifically identifies the number of pages and chapters as examples describing relationships within or among the components of a resource. Option D represents administrative metadata because version numbers and archive dates help manage the resource throughout its lifecycle.
The distinction is important to Data Quality because metadata itself must have appropriate completeness, consistency, currency, and accuracy. Incorrect descriptive metadata can make a valid data asset effectively undiscoverable or lead users to select an inappropriate source.
Metadata Management therefore supports Data Quality by giving data consumers reliable definitions, context, provenance, ownership, lineage, and usage information.
Reference Topics: DAMA-DMBOK2 Metadata Management — Descriptive Metadata; Structural Metadata; Administrative Metadata; Metadata Quality; Chapter 13 — Data Quality and Metadata Management.
===============
Database monitoring tools measure key database metrics, such as:
Options:
Create, read, normalization, user access
Capacity, availability, backup instances, data quality
Create, read, update, delete
Capacity, design, normalization, user access
Capacity, availability, cache performance, user statistics
Answer:
EExplanation:
DAMA-DMBOK2 identifies capacity, availability, cache performance, and user statistics as representative metrics captured by database-monitoring tools. Database monitoring is an operational control mechanism used by Database Administrators and platform teams to understand whether database infrastructure is available, adequately sized, responsive, and being used as expected. DMBOK2 explicitly describes monitoring tools as automating the observation of metrics such as capacity, availability, cache performance, and user statistics.
Capacity metrics indicate resource consumption and future growth requirements. Availability measures whether data services remain accessible when required. Cache-performance measures help identify inefficient access patterns and bottlenecks, while user statistics provide information about workload and database consumption.
The other choices mix design concepts, CRUD operations, or Data Quality concepts with operational monitoring measures. For example, normalization is a modelling technique rather than a routine runtime performance metric. Similarly, “create, read, update, delete” describes basic data operations rather than monitoring indicators.
Although database performance and Data Quality are distinct disciplines, poor operational performance can affect Data Quality dimensions such as timeliness and availability. Monitoring therefore supports the technical environment in which governed, reliable information is delivered to users and applications.
Reference Topics: DAMA-DMBOK2 — Data Storage and Operations; Database Operations; Capacity and Availability Management; Monitoring; Chapter 13 — Timeliness and Operational Fitness for Purpose.
===============
A goal of reference and master data management is for data to ensure shared data is:
Options:
Secure, auditable, publicly available and free
Continuous, consistent, current and private
Complete, consistent, content and relevant
Secure, auditable, complete and relevant
Complete, consistent, current and authoritative
Answer:
EExplanation:
DAMA-DMBOK2 explicitly identifies a core goal of Reference and Master Data Management as ensuring that shared Master and Reference Data is complete, consistent, current, and authoritative across organizational processes.
Complete means required shared entities and attributes are sufficiently populated for their intended use. Consistent means equivalent data has compatible meaning and representation wherever it is consumed. Current means the information reflects an acceptably recent state. Authoritative means the organization recognizes a trusted source or governed process for determining the accepted value.
These characteristics are particularly important because Master and Reference Data is reused widely. An incorrect Product classification, Customer identifier, Country code, or Supplier status can therefore propagate defects across many systems and business processes.
DAMA also emphasizes that shared Master and Reference Data belongs to the organization rather than to a single application or department. This creates a strong requirement for enterprise stewardship and governance.
Reference and Master Data Management consequently interacts directly with Chapter 13. MDM can consolidate and distribute shared data, but it does not guarantee quality automatically. Matching, survivorship, validation, standardization, stewardship, and continuous monitoring are required to ensure the resulting records remain trustworthy.
Reference Topics: DAMA-DMBOK2 Chapter 10 — Reference and Master Data Management Goals; Shared Data; Authoritative Sources; Stewardship; Chapter 13 — Completeness, Consistency and Currency.
===============
The primary reason for identifying Critical Data Elements is to:
Options:
Apply identical controls to every field in every system
Focus governance and quality resources on data with the greatest business impact
Eliminate the need for metadata
Replace all non-critical data
Answer:
BExplanation:
Critical Data Elements are identified so that organizations can concentrate governance and Data Quality effort where failure would create the greatest business impact.
Not every attribute deserves the same level of profiling, monitoring, stewardship, lineage documentation, control, and remediation. Applying identical controls to every field would usually be economically inefficient and may divert resources away from information that supports regulation, financial reporting, key operations, customer outcomes, or strategic decisions.
The DMBOK2 maintenance revision explicitly adds and clarifies the concept of a Critical Data Element within Chapter 13.
Once a CDE is identified, the organization can define applicable quality dimensions, measurable rules, thresholds, ownership, authoritative sources, lineage, issue escalation, and monitoring frequency.
Criticality is contextual. An attribute may be critical to one process and relatively insignificant to another. The decision should therefore reflect documented business use and risk rather than technical prominence.
Metadata remains essential because it links the CDE to definitions, systems, lineage, owners, and quality controls.
Reference Topics: DAMA-DMBOK2 Chapter 13 — Critical Data Elements; Prioritization; Business Impact; Risk; Data Governance; Metadata.
===============
The main difference between a System of Record and a System of Reference is:
Options:
The data does not originate in the system of reference.
The data does not originate in the system of record.
They are the same thing
A system of record is the source of master data; a system of reference is the source of reference data
A system of reference is the source of transaction data; the system of record is the source of master data
Answer:
AExplanation:
DAMA-DMBOK2 distinguishes the two concepts according to origination versus authoritative consumption. A System of Record (SoR) is an authoritative system in which data is created, captured, or maintained according to defined rules and expectations. A System of Reference (SoRef) is an authoritative location from which consumers obtain reliable information for transactions or analysis even though that information may have originated elsewhere.
Therefore, option A expresses the essential distinction most accurately. For example, an operational CRM may be the System of Record for customer data because customer information is captured and maintained there. An MDM hub or enterprise data-sharing platform can subsequently become the System of Reference used by other applications, even though the original data was created in the CRM.
This distinction is important for Data Quality and lineage. Consumers need to know where values originated, where authoritative corrections are performed, which system distributes trusted values, and which stewardship process governs conflicts between sources. Metadata should therefore record source lineage, system roles, transformations, and authoritative status.
Option D is incorrect because “System of Record” and “System of Reference” do not correspond respectively to master data and reference data categories. Either architectural role can participate in managing different categories of enterprise data.
Reference Topics: DAMA-DMBOK2 Chapter 10 — System of Record and System of Reference; Trusted Sources; MDM Architecture; Metadata Lineage; Chapter 13 — Data Quality and Reference/Master Data Management.
===============
A Data Quality score is calculated from Completeness, Accuracy, and Timeliness. Why might the dimensions be weighted differently?
Options:
Because business impact and importance can differ by dimension
Because all Data Quality dimensions always have equal importance
To eliminate Data Governance
To avoid defining thresholds
Answer:
AExplanation:
Dimensions may be weighted differently because their business impact is not necessarily equal for a particular dataset or process.
For an emergency-response system, Timeliness may be more critical than completeness of optional descriptive fields. For regulatory reporting, Accuracy and Integrity may carry substantially greater risk than minor delays. For a marketing contact list, completeness and currency may dominate.
A composite Data Quality score should therefore reflect business priorities rather than assuming that each dimension contributes identical value. Weighting must be transparent and governed; otherwise a high score in low-impact dimensions could hide serious failure in a critical one.
The first step remains defining business requirements and Critical Data Elements. Once those are established, dimensions, thresholds, and weights can be linked to documented business consequences.
A score should also retain underlying component metrics. A single aggregate percentage is insufficient for diagnosis because two datasets with the same overall score may have very different risk profiles.
Reference Topics: DAMA-DMBOK2 Chapter 13 — Metrics; Scorecards; Business Impact; Critical Data Elements; Quality Dimensions; Thresholds.
===============
A team uses a fishbone diagram during investigation of recurring missing customer email addresses. What is the primary purpose of the diagram?
Options:
Organize potential root causes into categories
Encrypt customer information
Calculate database storage
Create master records automatically
Answer:
AExplanation:
A fishbone diagram, also known as an Ishikawa or cause-and-effect diagram, is used to organize and explore potential root causes of a problem.
For recurring missing email addresses, categories might include People, Process, Technology, Data, Policy, Training, and External Sources. Potential causes could include optional form design, unclear business requirements, API mapping defects, missing supplier data, or inconsistent onboarding procedures.
The technique helps prevent teams from prematurely assuming that the most visible symptom is the actual cause. It encourages structured investigation across multiple dimensions of the process.
Once hypotheses are identified, evidence should be collected to confirm or reject them. The diagram itself does not prove causation.
In Data Quality programs, root-cause analysis is essential because repeated cleansing without process correction allows defects to recur. DAMA's Chapter 13 revision explicitly retains and strengthens the treatment of common causes and the improvement lifecycle.
Reference Topics: DAMA-DMBOK2 Chapter 13 — Root-Cause Analysis; Cause-and-Effect Diagram; Issue Management; Continuous Improvement.
===============
A Data Quality incident affects several downstream systems. What should be determined before individual teams independently correct their copies?
Options:
The root cause and authoritative point of remediation
Which team has the largest budget
Which system contains the most records
Which copy is easiest to delete
Answer:
AExplanation:
The organization should determine the root cause and authoritative remediation point before multiple teams independently modify downstream copies.
If a defective value originates in a source system and is distributed to five downstream applications, correcting those five copies independently may provide temporary relief but leaves the upstream defect intact. The incorrect value may simply be redistributed again.
Lineage should be used to trace the defect through source systems, transformations, integration layers, Master Data hubs, warehouses, and reports. Once the origin is understood, governance can determine which system or process is authoritative and where correction should occur.
This approach minimizes inconsistent local fixes and reduces the risk that different teams apply incompatible interpretations of the same issue.
DAMA's Chapter 13 revision explicitly strengthens the relationship between Data Quality and Metadata Management, Reference/Master Data Management, Modeling, and Data Integration. Those connections are precisely what enable cross-system issue resolution.
Downstream correction may still be required after the authoritative source is fixed, but it should be coordinated.
Reference Topics: DAMA-DMBOK2 Chapter 13 — Root-Cause Analysis; Issue Management; Metadata Lineage; Authoritative Sources; Data Integration.
===============
Two departments use the term "Active Customer" but apply different definitions. Which Data Management capability should be addressed first?
Options:
Business glossary governance
Storage compression
Index rebuilding
Network segmentation
Answer:
AExplanation:
The immediate requirement is Business Glossary governance. The issue is semantic: two departments use the same term but assign different meanings to it.
A governed business glossary establishes agreed terminology, definitions, synonyms, related concepts, ownership, and usage context. Resolving the definition does not necessarily mean forcing every business process to use one operational rule; there may be legitimate variants. The critical requirement is that those variants be explicitly named and documented so consumers understand the distinction.
Metadata Management provides the structures needed to preserve and distribute these definitions. DAMA's public Metadata Management guidance identifies business glossaries and data dictionaries as core mechanisms for improving shared understanding.
This semantic clarity is fundamental to Data Quality. A completeness or accuracy score for "Active Customer" is meaningless if departments measure different populations under the same label.
After the definition is governed, technical metadata should link the glossary concept to physical fields, calculations, reports, and quality rules.
Reference Topics: DAMA-DMBOK2 — Business Glossary; Metadata Management; Data Stewardship; Semantic Consistency; Data Quality Rules.
===============
A customer's date of birth is stored as 12/04/1980. The value conforms to the database datatype and accepted date format, but the customer's verified date of birth is 21/04/1980. Which Data Quality dimension is primarily violated?
Options:
Completeness
Accuracy
Validity
Timeliness
Answer:
BExplanation:
The primary failure is Accuracy. Accuracy concerns whether a stored value correctly represents the real-world entity, event, or fact it is intended to describe. The recorded date is syntactically acceptable and conforms to the expected datatype and format, so it may satisfy Validity while still being factually wrong.
This distinction is fundamental in Data Quality assessment. A validity rule can determine whether a value is structurally permissible—for example, whether a date conforms to an approved pattern or whether a month lies between 1 and 12. It cannot by itself prove that the date belongs to the correct person. Government guidance based on DAMA dimensions makes the same distinction: a value can be valid while remaining inaccurate.
The strongest accuracy control would compare the value with an authoritative or independently verified source. Metadata should document the authoritative source and lineage, while governance should assign responsibility for resolving discrepancies.
The scenario therefore demonstrates why Data Quality programs must avoid assuming that format compliance equals correctness.
Reference Topics: DAMA-DMBOK2 Chapter 13 — Accuracy; Validity; Authoritative Sources; Data Quality Rules; Metadata Lineage.
===============
Compound authorization groups provide a means to:
Options:
Distract the data security officer
Precisely configure an individual's access to a system
Obfuscate a user's actual access to a system
Encrypt sensitive transmissions of data
Effectively prepare for data security audits
Answer:
BExplanation:
Compound authorization groups allow access rights from multiple groups or roles to be combined so that an individual's effective permissions can be configured with greater precision. The user may inherit one set of privileges from an organizational role, another from a functional group, and additional permissions from a specialized operational responsibility. The resulting authorization can therefore be more granular than assigning every privilege individually.
DAMA's Data Security framework separates authentication—establishing identity—from authorization, which determines what an authenticated identity is permitted to access or perform. Group-based authorization is a practical mechanism for implementing those decisions. CDMP-oriented references for this specific item identify “precisely configure an individual's access to a system” as the intended answer.
The principle must nevertheless be governed carefully. Excessive overlapping group memberships can make effective permissions difficult to review and can create segregation-of-duties conflicts. Periodic access reviews, least-privilege design, role ownership, and audit trails are therefore necessary complementary controls.
Encryption addresses confidentiality of data in transit or storage and is unrelated to how permissions are assigned. Audit preparation may benefit from structured authorization, but it is not the principal purpose.
Reference Topics: DAMA-DMBOK2 Chapter 7 — Authorization; Access Control; Least Privilege; Security Roles; Audit and Monitoring.
===============
Integrating data security with document and content management knowledge areas, guides the implementation of:
Options:
Appropriate access and authorization to structured data
Fitness for purpose metrics for unstructured data
Straight-through processing for NoSQL queries
Appropriate access and authorization to unstructured data
Appropriate privacy controls on data marts
Answer:
DExplanation:
Document and Content Management focuses on information stored outside conventional relational databases, including documents, images, multimedia, email, and other semi-structured or unstructured assets. Integrating this knowledge area with Data Security therefore guides the implementation of appropriate access and authorization controls for unstructured data.
DAMA's framework treats security as a cross-cutting discipline rather than something applicable only to database tables. Organizational documents can contain personally identifiable information, intellectual property, contracts, financial records, or other confidential material and therefore require the same disciplined approach to authentication, authorization, classification, retention, and monitoring as structured data. DAMA-aligned references explicitly identify appropriate access and authorization to unstructured data as the relevant interaction between these knowledge areas.
Metadata is also important because document classifications, ownership, retention category, confidentiality level, and permitted audiences provide the information needed to enforce controls.
Option A refers to structured data and therefore misses the specific contribution of Document and Content Management. Fitness-for-purpose measurement belongs primarily to Data Quality, while data-mart privacy addresses a narrower structured analytical environment.
Reference Topics: DAMA-DMBOK2 Chapter 7 — Data Security; Chapter 9 — Document and Content Management; Unstructured Data; Access Control; Authorization; Information Classification.
===============
The DMBoK ‘Environmental Factors hexagon' shows the relationship between:
Options:
Inputs, activities and deliverables
People, process and technology
People, software and tools
DMBoK knowledge areas
Business, application and technology architecture
Answer:
BExplanation:
The DAMA-DMBOK2 Environmental Factors Hexagon illustrates the relationship between People, Process, and Technology. It provides a visual key for interpreting the Knowledge Area Context Diagrams and emphasizes that effective Data Management depends on the coordinated interaction of these three dimensions.
DMBOK2 places Goals and Principles at the center of the hexagon because they guide how people perform activities and how technology is selected and used. People-related factors include roles, responsibilities, organization, and culture. Process-related factors include activities, techniques, and methods. Technology-related factors include tools and the mechanisms that support Data Management deliverables.
This model is especially relevant to Data Quality. A profiling or cleansing platform alone cannot establish sustainable quality. The organization also needs accountable Data Owners and Data Stewards, repeatable issue-management and improvement processes, business-defined rules, and governance mechanisms. Conversely, well-designed processes will fail if supporting technologies cannot monitor or enforce required controls.
Option A relates more closely to the structure of DMBOK Knowledge Area Context Diagrams. The DAMA Wheel represents the Knowledge Areas, while the Environmental Factors Hexagon specifically emphasizes the People–Process–Technology relationship.
Reference Topics: DAMA-DMBOK2 Chapter 1 — DAMA-DMBOK Framework; Environmental Factors Hexagon; People, Process and Technology; Chapter 13 — Data Quality Organization, Processes and Tools.
===============
A financial transaction is captured correctly at 9:00 AM but does not become available to the fraud-monitoring system until 6:00 PM, although the business requirement is availability within five minutes. Which Data Quality dimension is primarily violated?
Options:
Accuracy
Timeliness
Uniqueness
Completeness
Answer:
BExplanation:
The primary failure is Timeliness. The transaction may be completely accurate and complete, but it is not available within the period required by the consuming business process.
Timeliness evaluates whether data is available when needed for its intended use. The relevant threshold must therefore come from the business requirement rather than from an arbitrary technical target. In this scenario, the fraud-monitoring process requires the transaction within five minutes, while delivery occurs approximately nine hours later.
The root cause could exist in extraction frequency, integration queues, batch processing, network delays, source-system availability, or downstream ingestion. Lineage and operational metadata should be used to identify where the latency occurs.
Timeliness must also be distinguished from Currency. Currency asks whether information reflects a sufficiently recent real-world state; Timeliness asks whether data is delivered or available within the required period. A current transaction that arrives too late can therefore fail Timeliness even though the underlying value accurately represented reality when captured.
DAMA's revised DMBOK2 Chapter 13 recognizes both Timeliness and Currency as separate standard dimensions.
Reference Topics: DAMA-DMBOK2 Chapter 13 — Timeliness; Currency; Data Quality Requirements; Data Integration; Operational Monitoring.
===============
Following the rollout of a data issue process, there have been no issues recorded in the first month. The reason for this might be:
Options:
The automatic deletion of all issues in the database
There are no data issues in the enterprise
Lack of credibility in the data governance process to effect changes
The denial of overtime requests
Staff staying back late to enter the issues into the system
Answer:
CExplanation:
A complete absence of reported issues immediately after introducing an enterprise Data Issue process is more likely to indicate lack of confidence in the governance process than genuinely flawless enterprise data. The certification material explicitly identifies lack of credibility in the process's ability to effect change as the plausible explanation.
Effective issue management depends on organizational trust. Employees need to believe that documenting an issue will lead to triage, ownership, escalation, root-cause investigation, remediation, and appropriate communication. If previous problems disappeared into a queue without action—or if raising defects creates organizational friction—users may simply stop reporting them.
DAMA-DMBOK2 treats Data Governance implementation as an organizational-change challenge rather than a purely procedural exercise. Governance must demonstrate authority, responsiveness, transparency, and measurable outcomes to establish credibility.
For Data Quality, issue volumes must also be interpreted carefully. “Zero issues reported” is not equivalent to “zero defects.” Complementary evidence should come from profiling, automated monitoring, quality metrics, user feedback, reconciliation, and operational outcomes.
Management should investigate reporting barriers, communicate resolved cases, establish clear escalation paths, and demonstrate that identified problems produce tangible improvements.
Reference Topics: DAMA-DMBOK2 Chapter 3 — Governance Adoption and Credibility; Data Issue Management; Chapter 13 — Issue Identification, Escalation, Root-Cause Analysis and Remediation.
===============
Adoption of a Data Governance program is most likely to succeed:
Options:
With an incremental rollout strategy
When the entire enterprise is partaking at once
When dictated by senior executives
When the CDO is a charismatic leader
In 1 or 2 months with a large consulting team
Answer:
AExplanation:
DAMA-DMBOK2 recommends an incremental implementation strategy for Data Governance because governance introduces changes in accountability, decision rights, standards, processes, and organizational behaviour. Attempting an enterprise-wide implementation immediately creates unnecessary cultural and operational risk.
The implementation guidance is explicit that most governance rollout strategies are incremental, commonly beginning with a significant initiative such as Master Data Management or with a particular region, business unit, or domain. Enterprise-wide deployment as the initial step is described as uncommon.
Incremental implementation provides several control advantages. The organization can validate roles and decision mechanisms, establish stewardship practices, prove business value, refine policies, develop metrics, and correct weaknesses before expanding the governance framework. This aligns closely with Data Quality management, where organizations normally prioritize Critical Data Elements and high-value domains rather than attempting to measure and remediate every data element simultaneously.
Executive sponsorship is important, but a mandate alone does not produce sustainable adoption. Likewise, individual leadership charisma cannot substitute for operating processes, accountability, metrics, and change management. A short consultant-driven exercise also conflicts with DAMA's treatment of governance as an ongoing organizational capability.
Incremental rollout therefore offers the strongest mechanism for embedding governance permanently while demonstrating measurable value.
Reference Topics: DAMA-DMBOK2 Chapter 3 — Implementation Guidelines; Organization and Culture; Adjustment and Communication; Chapter 13 — Data Quality Improvement and Governance.
===============
A source application is modified so that a mandatory product identifier can no longer be left blank. Which type of Data Quality action is this?
Options:
Preventive control
Detective control only
Historical archiving
Data obfuscation
Answer:
AExplanation:
The application change is a preventive Data Quality control because it prevents a known defect from being created in the first place.
A mandatory-field control ensures that records cannot be accepted without the required Product Identifier. This differs from a detective control, which would identify missing identifiers after records had already entered the system.
Preventive controls are generally preferable where the organization controls the point of data creation and the business rule is sufficiently clear. They reduce downstream cleansing, exception handling, reconciliation, and operational rework.
However, making the field technically mandatory is appropriate only if the business requirement genuinely applies to every relevant record. Governance and stewardship should confirm the rule before implementation. If certain product categories legitimately lack the identifier, the validation should incorporate those conditions instead of enforcing an overly broad requirement.
The Product Identifier may also link the transaction to governed Product Master Data, making integrity and consistency important alongside completeness.
DAMA's Data Quality framework emphasizes defining rules, detecting defects, implementing improvement, and integrating quality with Governance and Master Data disciplines rather than relying solely on after-the-fact cleansing.
Reference Topics: DAMA-DMBOK2 Chapter 13 — Preventive Controls; Completeness; Data Quality Improvement Lifecycle; Chapter 10 — Product Master Data; Governance.
===============
One way of defining ethics is:
Options:
Doing it right when no one is looking
Doing it wrong, and then expertly covering it up
Doing it wrong, and failing to covering it up
Doing it wrong, and then apologizing
Doing it right when someone is looking
Answer:
AExplanation:
The correct principle is “Doing it right when no one is looking.” The statement captures the essential distinction between ethical behaviour and mere compliance. Ethical conduct does not depend on observation, enforcement, or the probability of being caught; it requires responsible action because the action itself is appropriate. The answer wording is presented directly in the PDF on page 4.
DAMA-DMBOK2 treats data ethics as an essential component of professional Data Management because organizations routinely make choices about collecting, combining, analyzing, retaining, sharing, and monetizing data. A technically permissible activity may still create inappropriate effects on individuals or expose data to potential misuse.
Data ethics therefore extends beyond security and regulatory compliance. It requires consideration of the impact on people, potential for misuse, and economic value of data. Ethical handling also requires transparency concerning data provenance, intended use, quality limitations, and the consequences of decisions based on data.
Data Quality has an ethical dimension as well. Knowingly using inaccurate, incomplete, misleading, or poorly understood data in consequential decisions can harm customers and other stakeholders. Governance should therefore establish not only compliance controls but also principles for responsible use.
Reference Topics: DAMA-DMBOK2 Chapter 2 — Data Handling Ethics; Ethical Principles; Impact on People; Potential for Misuse; Chapter 13 — Reliable and Fit-for-Purpose Data.
===============
What is the ideal data role combination for assignments per subject area and even to each entity within subject areas?
Options:
Business Analyst and Data Architect
Data Architect and DBA
Data Architect and Data Modeller
Data Architect and Data Analyst
Data Architect and Data Steward
Answer:
EExplanation:
The ideal combination is a Data Architect and a Data Steward. DAMA-DMBOK2 states explicitly that, ideally, both roles should be assigned to each subject area and even to individual entities within a subject area. This arrangement integrates architectural control with business accountability.
The Data Architect contributes enterprise-wide structural knowledge: subject-area boundaries, entities, relationships, integration requirements, architectural standards, and alignment with the broader Enterprise Data Architecture. The Data Steward contributes authoritative business knowledge and accountability for terminology, business rules, valid values, quality expectations, and appropriate use of the data.
DMBOK2 also describes the enterprise data model as something that should be developed and maintained jointly by Data Architects and Data Stewards working together in subject-area teams.
This pairing is especially valuable for Data Quality because structural correctness alone does not guarantee fitness for purpose. A technically valid model may still contain ambiguous definitions or inappropriate business rules. Conversely, business requirements without architectural discipline can create duplicated or inconsistent structures.
Working together, the Architect and Steward ensure that definitions, models, metadata, lineage, quality rules, and governance decisions remain aligned. DBAs, analysts, modellers, and business analysts are important contributing roles, but they do not provide the same combined architectural and governance accountability.
Reference Topics: DAMA-DMBOK2 Chapter 4 — Data Architecture Governance; Subject Areas; Chapter 3 — Data Stewardship; Enterprise Data Models; Chapter 13 — Data Quality Accountability.
===============
Big data management requires:
Options:
More discipline than relational data management
Less discipline than relational data management
Big ideas with big budgets
No discipline at all
A certification in data science
Answer:
AExplanation:
DAMA-DMBOK2 establishes the guiding principle that Big Data management requires more discipline than relational data management. The reason is not simply data volume. Big Data environments combine large volumes with substantial variation in structure, source, velocity, semantics, and reliability. These characteristics increase the probability of uncontrolled duplication, inconsistent interpretation, poor provenance, inappropriate use, and undetected quality defects. DAMA's Big Data guidance specifically emphasizes disciplined management of metadata describing Big Data sources, their origins, and their value.
From a Data Quality perspective, scale does not make data fit for purpose. Large datasets still require defined quality expectations, profiling, monitoring, lineage, controlled transformations, ownership, and governance. Metadata becomes particularly important because analysts must understand where datasets originated, how they were transformed, their meaning, and whether they are appropriate for a particular analytical objective.
Data Governance must consequently establish accountability, acceptable-use policies, security requirements, quality expectations, and escalation mechanisms. Statistical and automated controls are also essential because manual inspection becomes impractical at Big Data scale.
Neither larger budgets nor data-science certification substitutes for sound data-management discipline. Likewise, reducing controls because data is large creates greater—not lower—operational and analytical risk.
Reference Topics: DAMA-DMBOK2 — Big Data and Data Science; Big Data Management Principles; Metadata Management; Data Governance; Chapter 13 — Fitness for Purpose and Data Quality Controls.
===============
A DMZ is bordered by 2 firewalls. These are between the DMZ and the:
Options:
Internet and internal systems
Internet and intranet
Internet, for added security
Korean peninsula
Internet and extranet
Answer:
AExplanation:
A Demilitarized Zone (DMZ) is a controlled network segment positioned between an organization's trusted internal environment and an external, untrusted environment such as the Internet. In the classic architecture described in DAMA-DMBOK2, the DMZ is separated from the Internet by an external firewall and from internal organizational systems by another firewall. Therefore, the correct answer is Internet and internal systems.
DMBOK2 describes the DMZ as an area on the organization's perimeter, with firewall protection separating it from the organization and firewall protection between the DMZ and the Internet. It is commonly used for services or transient data exchanges that must interact with external parties without providing direct access to internal systems.
This arrangement implements defense in depth. Public-facing services can operate in the DMZ while internal databases and sensitive systems remain behind an additional security boundary. A compromise of a DMZ host should therefore not automatically expose the internal network.
For Data Quality, security architecture is relevant because unauthorized modification or corruption can compromise integrity and accuracy. Protecting interfaces and repositories supports trustworthy data processing as well as confidentiality and availability.
Reference Topics: DAMA-DMBOK2 Chapter 7 — Data Security; Network Security; Perimeter; DMZ; Firewalls; Integrity Protection.
===============