DAMA DQ-1220 DAMA Data Quality Specialist Exam Practice Test

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.

===============

This is Reference Data Management. Country codes represent a controlled set of values used to classify or contextualize other data. Managing them centrally helps ensure that all systems interpret the same codes consistently.

Without centralized governance, one system might use GB, another UK, and another proprietary numeric values. Those differences create mapping complexity, failed integrations, inaccurate aggregation, and inconsistent reporting.

Reference Data Management establishes authoritative sources, stewardship, allowed values, mappings, effective dates, distribution processes, and change control. DAMA's public framework describes Reference and Master Data Management as ensuring consistency in core shared information across organizational units.

The Data Quality dimensions most directly supported are Validity and Consistency. Validity ensures values belong to an approved domain; consistency ensures equivalent concepts are represented compatibly across systems.

Metadata should document the standard, meaning, owner, and version of each reference domain.

Reference Topics: DAMA-DMBOK2 Chapter 10 — Reference Data; Controlled Code Sets; Authoritative Sources; Chapter 13 — Validity and Consistency.

===============

GARP stands for Generally Accepted Recordkeeping Principles. ARMA International developed the framework to describe the characteristics of an effective records and information-management program. The principles address accountability, transparency, integrity, protection, compliance, availability, retention, and disposition.

These principles align closely with DAMA-DMBOK2's treatment of Document and Content Management. Information must be created, organized, protected, maintained, retrieved, retained, and ultimately disposed of according to business, legal, regulatory, and historical requirements. Records management is therefore not simply about long-term storage. It establishes controls throughout the information lifecycle.

For example, the Integrity principle addresses the authenticity and reliability of records. Availability requires information to be retrievable accurately and efficiently. Retention requires organizations to keep records for justified periods, while Disposition governs appropriate final handling after those obligations expire.

These controls interact directly with Data Quality. Records that cannot be found, trusted, interpreted, or demonstrated to be authentic are not fit for their intended purpose even if they physically exist.

Metadata Management supplies classification, retention, provenance, ownership, and lifecycle metadata necessary to implement these principles consistently.

Reference Topics: DAMA-DMBOK2 — Document and Content Management; Records Management; GARP; Retention; Disposition; Integrity; Metadata Management.

===============

Source-to-target mapping enables Transformation. DAMA-DMBOK2 treats mapping as closely synonymous with transformation because a mapping defines how data in one source structure will be converted into the structure, format, representation, or value required by the target.

A mapping specification typically identifies the source attribute, target attribute, extraction conditions, target population rules, intermediate staging transformations, calculations, lookup requirements, and any changes required to make the source data conform to the target representation. DMBOK2 specifically explains that mapping sources to targets involves defining the rules for transforming information from one location and format into another.

Extraction simply retrieves data from the source. Loading places data into the target. Transformation is the activity that applies structural, syntactic, semantic, or value-level modifications between those stages.

The Data Quality connection is substantial. Mappings may standardize dates, convert units, harmonize codes, resolve reference values, remove duplicates, or enforce business rules. If mapping metadata is incomplete or incorrect, the transformation process can introduce rather than correct quality defects.

For this reason, source-to-target mapping should be governed, version-controlled, documented as metadata, traceable through lineage, and validated against agreed business definitions and Data Quality requirements.

Reference Topics: DAMA-DMBOK2 Chapter 8 — Map Data Sources to Targets; Transformation; ETL/ELT; Metadata Lineage; Chapter 13 — Data Cleansing and Standardization.

===============

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.

===============

The Party pattern generalizes Person and Organization under a common supertype so that both can participate consistently in shared business relationships and processes. The major benefit is that persons and organizations can act in roles in agreements, share address structures, and participate in common interaction processes, making option E correct.

For example, a Customer, Supplier, Account Holder, Employee, or Contracting Party may be either a person or an organization. Without the Party abstraction, separate relationships may need to be constructed repeatedly for Person and Organization. With Party, common concepts such as Agreement, Address, Contact Point, Role, and Interaction can reference a single generalized entity.

This is particularly relevant to Master Data Management because Party is a common enterprise modelling pattern for Customer, Supplier, and related master-data domains. It supports entity resolution while preserving distinctions between individuals and organizations through subtype structures.

From a Data Quality perspective, the approach improves consistency by reducing duplicated relationship definitions and business rules. However, governance must still establish subtype-specific requirements—for example, organization registration identifiers versus personal names and dates of birth.

The abstraction is therefore primarily about reusable semantic relationships and roles, not security concealment or faster package implementation.

Reference Topics: DAMA-DMBOK2 Chapter 5 — Data Modeling and Design; Generalization and Specialization; Party Model; Chapter 10 — Master Data; Chapter 13 — Consistency and Integrity.

===============

The mechanism is designed to meet confidentiality and privacy requirements. Customer bank-account details constitute sensitive financial information. Inspecting outgoing email for such values is a form of Data Loss Prevention control intended to identify or prevent inappropriate disclosure before sensitive information leaves the organization's controlled environment.

DAMA-DMBOK2 treats confidentiality and privacy as fundamental Data Security requirements. Its electronic-communication guidance warns that restricted or confidential information should not be sent through insecure communication channels because messages can be intercepted, forwarded, or otherwise disclosed after leaving the sender's control. DAMA International's own privacy practices likewise classify bank-account and similar financial information as protected personal/financial data requiring security safeguards against unauthorized disclosure.

The other responses concern transparency, definitions, user experience, or availability and do not address the security objective demonstrated in the scenario.

Data Governance determines the classifications and policies governing such information; Metadata Management can record sensitivity classifications against physical data elements; and security technology then enforces the resulting controls.

Data Quality remains relevant because confidentiality controls must distinguish genuinely sensitive values accurately. Poor classification or inaccurate detection rules may either expose protected information or unnecessarily block legitimate communication.

Reference Topics: DAMA-DMBOK2 Chapter 7 — Confidentiality and Privacy; Electronic Communication Security; Sensitive Data; Data Loss Prevention; Data Governance.

===============

DAMA-DMBOK2 assigns primary responsibility for business glossary content to Business Data Stewards. Business Data Stewards are typically subject-matter experts who understand how data is defined, created, interpreted, and consumed within their business domain. DMBOK2 explicitly states that Data Stewards are generally responsible for business glossary content and identifies Business Data Stewards as professionals who work with stakeholders to define and control data.

A business glossary is not simply a technical dictionary. It establishes agreed business terminology, definitions, synonyms, business rules, responsible stewards, and relationships between business concepts. This makes stewardship involvement essential because definitions must reflect operational and business meaning rather than merely database structures.

Data Architects may contribute candidate definitions and structural context from subject-area and conceptual models, but they do not generally own the business meaning. Business users provide valuable input, while Coordinating Data Stewards help reconcile definitions across domains, yet the normal accountability remains with Business Data Stewards.

This relationship is particularly important for Data Quality. Quality rules depend on unambiguous definitions of data elements. If “Customer,” “Active Account,” or “Order Date” has inconsistent meanings, measurements of completeness, accuracy, and validity cannot be consistently interpreted.

Reference Topics: DAMA-DMBOK2 Chapter 3 — Develop a Business Glossary; Business Data Stewardship; Metadata Management; Chapter 13 — Data Quality Rules and Business Definitions.

===============

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.

===============

Although Data Lakes and Data Warehouses have materially different architectures, both support the broader objective of making organizational data available for reporting, analysis, analytics, and decision support. Therefore, option B identifies their legitimate conceptual overlap.

A traditional Data Warehouse generally contains integrated, curated, structured data designed for repeatable Business Intelligence, reporting, and analytical workloads. A Data Lake typically retains larger volumes of raw or less-structured information and supports flexible processing, exploration, Data Science, and advanced analytics. Both can therefore participate in analytical data pipelines even though their approaches to schema, transformation, governance, and consumption differ.

They do not inherently duplicate every item of operational data. Nor must a Data Lake produce dimensional or star-schema models; that modeling approach is more closely associated with traditional warehouse implementations. Governance is required for both rather than being the defining difference between them.

From a Data Quality standpoint, warehouses typically apply substantial cleansing and conformity before consumption. Lakes may retain raw values and defer interpretation, which increases the importance of metadata, provenance, cataloging, profiling, and consumer awareness.

Reference Topics: DAMA-DMBOK2 — Data Warehousing and Business Intelligence; Big Data; Data Lakes; Analytical Data; Metadata; Chapter 13 — Data Preparation and Fitness for Purpose.

===============

A Business Data Steward, working with relevant business stakeholders and governance bodies, is the appropriate role to define or coordinate business meaning and quality expectations.

Quality requirements cannot be derived solely from database structures. The organization must understand what the attribute means, how it is used, what values are acceptable, which source is authoritative, and what consequences arise when it is wrong.

Data Stewards bridge business knowledge and formal Data Management controls. They commonly participate in maintaining glossary definitions, defining business rules, resolving issues, clarifying ownership, and establishing Data Quality expectations.

Technical specialists contribute implementation knowledge. A DBA may identify datatype constraints, while an integration specialist can implement transformations. Neither should independently determine business meaning.

DAMA's public framework describes Metadata Management as supporting definitions, lineage, and governance, while Reference and Master Data Management ensures consistency in shared core entities.

The strongest operating model therefore combines business accountability with technical execution.

Reference Topics: DAMA-DMBOK2 Chapter 3 — Data Stewardship; Chapter 11 — Business Metadata; Chapter 13 — Data Quality Requirements; Critical Data Elements.

===============

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.

===============

Pname is Metadata because it is the name assigned to a database column and therefore describes the structure in which the actual Family Name values are stored. A value such as Smith or Patel would be data; Pname is structural information describing that data.

DAMA-DMBOK2 defines Metadata broadly as information about data and data-related processes. Technical metadata includes physical database characteristics such as table names, column names, datatypes, lengths, indexes, constraints, and related structural properties. The interpretation of Pname as metadata is also consistent with the published version of this exact certification question.

The fact that Pname may be an unclear abbreviation does not change its classification. It may represent a poor naming convention from a usability or governance perspective, but technically it remains metadata. A stronger physical name might be FamilyName, while the metadata repository could additionally map that field to the authoritative business glossary term.

This distinction matters to Data Quality because rules are frequently attached to metadata objects. For example, the Family Name attribute might have completeness, permitted-character, maximum-length, and standardization requirements.

Effective Metadata Management connects the technical column to its business meaning, system lineage, stewardship, and applicable Data Quality controls.

Reference Topics: DAMA-DMBOK2 Chapter 11 — Technical Metadata; Database Metadata; Business Glossary; Chapter 13 — Data Quality Rules and Metadata.

===============

DAMA-DMBOK2 defines obfuscation or redaction as making information anonymous or removing sensitive information. The purpose is to reduce the risk that protected, confidential, or personally identifiable information can be exposed to users or processes that do not require access to the original values.

Obfuscation can involve masking, substitution, shuffling, temporal variation, partial display, or other methods that change what the recipient sees while preserving sufficient utility for the intended activity. For example, a customer-service agent may see only the final digits of an account identifier, or a development team may receive realistic but anonymized production-derived test data.

Redaction may remove information entirely from a representation when there is no legitimate requirement to expose it.

The technique is therefore a Data Security and privacy control, not database compression, publication, or classification.

There is also an important Data Quality consideration. Masked or obfuscated data used for testing must remain structurally valid and retain required relationships so that applications behave realistically. Metadata should indicate that a dataset has been transformed for privacy purposes so consumers do not mistake masked values for authoritative production data.

Reference Topics: DAMA-DMBOK2 Chapter 7 — Obfuscation; Redaction; Data Masking; Privacy; Sensitive Information; Chapter 13 — Fitness for Purpose and Controlled Transformation.

===============

The defect is measured using Completeness. Completeness evaluates whether all required records or values that should be present are actually present. In this scenario, the mandatory Tax Identification Number is absent from 2,500 of 50,000 customer records.

A straightforward attribute-level completeness metric would be calculated as the number of populated required values divided by the number expected. Therefore, 47,500 of 50,000 records contain the required value, producing a completeness result of 95%.

Completeness does not establish that populated values are accurate. A record may contain a Tax Identification Number and therefore pass the completeness rule while containing the wrong number. This separation between completeness and accuracy is essential when designing Data Quality scorecards. DAMA-aligned guidance defines completeness as the presence of required values and explicitly distinguishes it from factual correctness.

Governance should also determine whether the attribute is genuinely mandatory for every customer type. Quality rules must reflect business applicability rather than blindly requiring every field for every record.

Reference Topics: DAMA-DMBOK2 Chapter 13 — Completeness; Data Quality Metrics; Business Rules; Critical Data Elements; Scorecards.

===============

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.

===============

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.

===============

This is cross-column dependency profiling. The issue cannot be identified merely by counting null values in Closure_Date because some nulls may be legitimate for active accounts. The defect becomes meaningful only when the relationship between two attributes is examined.

The implied business rule is: if Account_Status = Closed, then Closure_Date must be populated. Dependency profiling examines relationships among values and can reveal conditional completeness, inconsistent combinations, functional dependencies, and other multi-attribute patterns.

The next step is to confirm the inferred pattern with business stakeholders rather than automatically converting it into an enforced rule. There may be exceptional account categories where a closed status legitimately lacks a closure date.

Once approved, the rule should be documented as metadata, assigned to a Data Steward, measured against an agreed threshold, and monitored. Root-cause investigation can then determine whether missing dates arise from source-screen design, process bypass, conversion defects, or integration failures.

DAMA's revised Chapter 13 places Data Quality techniques in a more practical sequence and strengthens their linkage with Data Modeling and Metadata Management.

Reference Topics: DAMA-DMBOK2 Chapter 13 — Data Profiling; Dependency Analysis; Completeness; Business Rules; Metadata Management.

===============

The concept described is Data Lineage. Data lineage records how data originates, moves, transforms, and is consumed across the information landscape. DAMA-oriented architecture guidance explicitly links implementation of Data Architecture with visibility into transformations occurring as data traverses systems and identifies this as lineage.

Lineage can operate at several levels. At a high level, it may identify that customer information moves from CRM into an integration platform, Master Data hub, warehouse, and reporting environment. At a detailed level, it may show that a particular report column derives from a specific source attribute through documented calculations, mappings, and transformation rules.

This capability is fundamental to Data Quality. When an incorrect result appears in a report, lineage helps analysts trace the defect upstream to the point where it originated or was introduced. It also supports root-cause analysis, impact assessment, regulatory traceability, change management, and reconciliation.

Metadata Management provides the repository structures needed to capture and maintain lineage. Data Governance determines which lineage must be documented and who is accountable for maintaining it.

ETL is one mechanism through which data may move and transform, but ETL is not the architectural concept describing the end-to-end history and derivation of the data.

Reference Topics: DAMA-DMBOK2 Chapter 4 — Data Architecture; Chapter 11 — Metadata Management; Data Lineage; Chapter 13 — Root-Cause Analysis and Data Quality Traceability.

===============

The appropriate dimension is Reasonableness. A value may comply with technical and business-domain constraints while still being implausible in its operating context. An individual customer purchasing 750,000 office chairs is technically possible, but it is sufficiently unusual that it should trigger review.

Reasonableness controls evaluate whether values and combinations of values fall within credible expectations. These controls often depend on business context, historical behaviour, peer comparisons, statistical limits, or relationships between multiple fields.

The current DMBOK2 revision standardizes the term Reasonableness within its nine standard dimensions. The broader DMBOK2 dimension framework links reasonableness to whether data should be regarded as credible within the operational context.

Useful controls might compare order quantity against customer type, historical maximums, product availability, typical basket size, or statistical deviation from normal purchasing behaviour.

Reasonableness rules are especially valuable for identifying errors that conventional validation cannot detect. However, unusual data should not automatically be treated as incorrect; it should usually be flagged for investigation.

Reference Topics: DAMA-DMBOK2 Chapter 13 — Reasonableness; Statistical Validation; Exception Detection; Business Rules.

===============

Remediation should principally be prioritized according to business impact and risk. Not all defects have equivalent consequences, even when they occur at similar frequencies.

A defect affecting regulatory reporting, customer payments, safety-critical operations, executive reporting, or high-value master data may require immediate remediation. A larger number of defects affecting a low-impact optional field may legitimately receive lower priority.

A robust prioritization model may consider financial loss, regulatory exposure, operational disruption, customer impact, reputational damage, number of dependent systems, recurrence rate, remediation cost, and whether a Critical Data Element is involved.

This risk-based approach prevents Data Quality programs from becoming simple defect-count reduction exercises. The objective is not merely to maximize the number of corrected records but to improve fitness for purpose where poor data creates material consequences.

Governance should approve prioritization criteria and resolve conflicts where different business areas assign different importance to the same issue. Metadata and lineage provide evidence about downstream dependencies and affected processes.

DAMA's revision of Chapter 13 adds a clearer Critical Data Element concept and clarifies responsibility within the Data Quality Improvement Lifecycle, reinforcing risk-based prioritization.

Reference Topics: DAMA-DMBOK2 Chapter 13 — Issue Prioritization; Business Impact; Critical Data Elements; Risk; Remediation.

===============

A candidate key is a minimal super key. A super key is any set of attributes sufficient to uniquely identify an entity instance, but it may contain attributes that are unnecessary for uniqueness. A candidate key removes that redundancy: if any attribute is removed from the candidate key, the remaining attributes no longer uniquely identify the entity.

DAMA-DMBOK2 makes this distinction explicitly: a candidate key is a minimal set of one or more attributes identifying an entity instance, and “minimal” means that no subset of the candidate key can perform the same unique-identification function.

Option B is incomplete because a set can uniquely identify an entity while still containing unnecessary attributes; that would qualify as a super key but not necessarily a minimal super key. A surrogate key is different: it is an artificial identifier introduced primarily for technical identification. Foreign-key composition and physical index structures likewise do not define candidate-key minimality.

This concept has direct Data Quality implications. Correctly defined candidate and primary keys support uniqueness and integrity, prevent duplicate entity instances, enable reliable referential relationships, and improve entity matching within Master Data Management. Key definitions should also be captured as structural metadata so profiling and quality rules can consistently test duplicate and orphan conditions.

Reference Topics: DAMA-DMBOK2 Chapter 5 — Data Modeling and Design; Keys; Candidate Keys; Chapter 13 — Uniqueness and Integrity; Metadata Management; Master Data Management.

===============

In a data model, entities are linked by relationships. An entity represents a distinguishable business concept or thing about which the organization stores information, while a relationship expresses how one entity is associated with another.

For example, a Customer places an Order, an Order contains Order Lines, and a Product appears on an Order Line. Relationships therefore capture business semantics rather than merely physical implementation details. Cardinality is an important characteristic of a relationship because it specifies how many instances of one entity may or must be associated with instances of another; however, cardinality is not itself the general mechanism by which entities are linked. DAMA-oriented modelling material identifies relationships as the correct linkage concept.

Indexes and triggers are physical database mechanisms. Processes describe business activities and may interact with entities, but they do not define entity-to-entity structure within a data model.

The Data Quality implications are significant. Properly defined relationships establish expectations for referential integrity. For example, an Order referencing a nonexistent Customer indicates an integrity defect. Profiling can test orphaned foreign keys, invalid relationship cardinalities, and inconsistent associations.

Relationships and their cardinalities should therefore be documented as metadata and enforced through appropriate database, application, or quality controls.

Reference Topics: DAMA-DMBOK2 Chapter 5 — Entities, Relationships and Cardinality; Logical Data Modeling; Chapter 13 — Integrity and Consistency; Metadata Management.

===============

DAMA-DMBOK2 explicitly states that a Data Governance program must be sustainable. Governance is not a temporary implementation project that ends after policies, committees, or stewardship roles are established. It is an ongoing organizational capability requiring continuing leadership, sponsorship, ownership, decision rights, and operational integration.

The DMBOK2 governance guidance describes sustainable governance as “sticky”: it must survive beyond its initial implementation and become embedded in normal business and Data Management practices. Sustainable governance depends specifically on business leadership, sponsorship, and ownership.

This distinction matters for Data Quality because quality improvement is likewise continuous. New applications, data sources, business processes, regulatory requirements, and transformations continually create new risks. Governance must therefore continue assigning accountability, approving definitions and quality rules, resolving cross-domain disputes, and overseeing remediation.

Options focused on financial registration or assigning a dollar value confuse data-as-an-asset thinking with formal accounting treatment. Data valuation can support investment decisions, but it is not a prerequisite for Data Governance. Likewise, treating governance as a fixed-duration initiative contradicts the operating model described by DAMA.

Reference Topics: DAMA-DMBOK2 Chapter 3 — Data Governance Goals and Principles; Sustainable Governance; Leadership; Sponsorship; Ownership; Chapter 13 — Data Quality Governance.

===============

Trend analysis is most useful because it shows how a quality metric changes over time rather than presenting a single isolated measurement.

A current defect rate of 4% has different implications depending on whether the previous months were 12%, 8%, and 6%, or 1%, 2%, and 3%. The first pattern indicates improvement; the second indicates deterioration.

Trend analysis therefore provides context for management decisions, helps determine whether remediation is producing sustained results, and can identify emerging degradation before thresholds are breached.

For stable, regularly measured processes, statistical control charts can add further value by distinguishing routine variation from signals that warrant investigation.

Metrics should be measured consistently over time. Changing definitions, populations, or calculation methods without documenting them can make apparent trends misleading.

Metadata should preserve metric definitions, threshold changes, and measurement logic to ensure comparability.

Reference Topics: DAMA-DMBOK2 Chapter 13 — Monitoring; Trend Analysis; Statistical Control; Metrics; Continuous Improvement.

===============

The process is Survivorship. In Master Data Management, survivorship determines which value should become the preferred or authoritative representation when multiple source records contain conflicting values for the same attribute.

Rules may prioritize particular systems, use recency, trust scores, verification status, completeness, or combinations of factors. For example, a verified customer-service update might outrank an older marketing-system telephone number.

Survivorship occurs after or in conjunction with matching and entity resolution. The organization first determines that records from different sources represent the same real-world customer and then determines which attribute values should populate the mastered representation.

The process requires governance because the "best" value is a business decision, not merely a technical one. Data Stewards should approve the rules, and metadata should record source priority, rule logic, and lineage.

DAMA's framework positions Reference and Master Data Management as the discipline responsible for ensuring consistent core entities across the organization.

Reference Topics: DAMA-DMBOK2 Chapter 10 — Master Data Management; Matching; Survivorship; Authoritative Values; Chapter 13 — Consistency and Accuracy.

===============

DAMA-DMBOK2 explicitly states that Data Governance represents an inherent separation of duty between oversight and execution. It illustrates the principle through an analogy with financial governance: an auditor exercises oversight over financial processes without personally executing financial management. Similarly, Data Governance ensures that data is properly managed but does not itself perform every operational Data Management activity.

This separation is fundamental because governance must retain sufficient independence to establish rules, monitor compliance, resolve conflicts, assign accountability, and evaluate whether operational teams are managing data according to approved policies and standards.

Option B describes activities in which governance and Data Quality practitioners may collaborate, but it is not the defining governance principle. Option D is also incorrect because federated governance is only one possible operating model; DMBOK2 also recognizes centralized and replicated approaches. Option E describes an organizational implementation, not the conceptual distinction.

Within Data Quality Management, this means that governance may approve quality policies, Critical Data Elements, acceptable thresholds, stewardship structures, and escalation procedures, while DQ analysts and operational teams perform profiling, cleansing, monitoring, and remediation.

Maintaining this division reduces conflicts of interest and establishes accountability for whether data-management activities achieve agreed business objectives.

Reference Topics: DAMA-DMBOK2 Chapter 3 — Essential Concepts; Oversight versus Execution; Governance Operating Models; Chapter 13 — Data Quality Governance and Operational Responsibilities.

===============

The organization should continue monitoring the quality metric. A successful remediation does not guarantee that the underlying process will remain controlled indefinitely.

Systems change, source applications are upgraded, personnel and suppliers change, reference values evolve, interfaces are modified, and business rules are revised. Any of these events can cause previously corrected defects to reappear.

A mature Data Quality lifecycle therefore treats improvement as continuous rather than as a one-time cleansing exercise. DAMA's revision of Chapter 13 specifically clarifies the Data Quality Improvement Lifecycle and links it to established continuous-improvement cycles.

Monitoring should confirm that the result remains within agreed thresholds and should provide trend information so deterioration can be detected before it creates significant business impact.

The frequency of monitoring may be reduced after a process demonstrates sustained stability, but the decision should be risk-based. Critical Data Elements generally justify stronger ongoing oversight.

The rule, threshold, owner, and measurement method should remain documented as metadata.

Reference Topics: DAMA-DMBOK2 Chapter 13 — Monitoring; Control; Continuous Improvement; Metrics; Thresholds; Data Quality Scorecards.

===============

A meaningful Data Quality metric begins with the business requirement and intended use. Quality is fundamentally contextual: data is considered fit for purpose only relative to the activity, decision, report, or process that depends on it.

For example, a delivery address used for same-day logistics may require stricter timeliness and completeness thresholds than an address retained solely for historical analysis. Without understanding the business use, a numerical quality target becomes arbitrary.

The business requirement should identify what failure matters, which dimension applies, how quality will be measured, the acceptable threshold, who owns the requirement, and what response is expected when the threshold is missed.

DAMA-aligned public guidance follows this same logic by recommending that quality rules and dimensions be prioritized according to user needs and purpose.

Technology selection comes later. Profiling tools help measure data, but they cannot determine the business meaning of an acceptable result.

Governance and stewardship should approve the requirement, while Metadata Management should preserve the definition, rule, owner, and lineage.

Reference Topics: DAMA-DMBOK2 Chapter 13 — Define Data Quality Requirements; Fitness for Purpose; Metrics; Thresholds; Business Rules.

===============

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.

===============

An MDM investment is justified when the business value obtained from centralized coordination of shared data exceeds the additional cost of managing and integrating another controlled representation of that data. This is the economic trade-off expressed by option C and is also the intended answer in published versions of this DAMA question.

DAMA-DMBOK2 positions Master Data Management as a mechanism for improving consistency and control over enterprise entities such as customers, products, suppliers, employees, and locations. Uncoordinated local copies create redundant maintenance, inconsistent definitions, duplicate records, reconciliation costs, and integration complexity. DAMA sources emphasize that controlling shared master and reference data reduces both cost and risk generated by inconsistencies between systems.

However, introducing an MDM repository also incurs costs: integration, stewardship, matching, survivorship logic, synchronization, governance, maintenance, and potentially another physical copy of shared information. The business case must therefore demonstrate that improved coordination, quality, reuse, reporting, and operational consistency outweigh those costs.

MDM does not require all contributing systems to be decommissioned, nor does it eliminate Reference Data Management. Similarly, “mining golden records” is not the fundamental economic basis for MDM.

Reference Topics: DAMA-DMBOK2 Chapter 10 — Master Data Management; Business Drivers; Shared Data; Central Coordination; Data Integration; Data Quality and Stewardship.

===============

All of these is correct because DAMA-DMBOK2 defines criticality according to the business use and impact of the data rather than by a particular technical characteristic. Critical Data Elements are commonly associated with regulatory, financial, or management reporting; operational business needs; measurement of product quality and customer satisfaction; and strategic initiatives such as competitive differentiation. DAMA's revised Chapter 13 also explicitly adds and clarifies the concept of Critical Data Elements within the Data Quality framework.

The purpose of identifying critical data is prioritization. Organizations cannot apply identical levels of profiling, monitoring, stewardship, remediation, and control to every data element. Data whose failure could create substantial operational, financial, legal, regulatory, customer, or reputational impact receives greater management attention.

For example, values feeding regulatory reports require stringent accuracy and traceability; operational data may require high availability and timeliness; customer-satisfaction measures require reliable and consistent inputs; and strategically important data can affect competitive decisions. Current DAMA-aligned material confirms these same usage categories for Critical Data Elements.

Once Critical Data Elements are identified, they should be linked to business definitions, Data Owners and Stewards, quality dimensions, measurable rules, lineage, authoritative sources, thresholds, and issue-management processes.

Reference Topics: DAMA-DMBOK2 Chapter 13 — Critical Data Elements; Business Drivers; Data Quality Requirements; Prioritization; Data Governance; Metadata Management.

===============

The primary issue is Data Integrity, specifically referential integrity. The Orders record references a Customer_ID that does not correspond to an existing Customer record, meaning the relationship defined by the data model has been violated.

Integrity concerns whether structural relationships and constraints among data elements remain valid. In relational environments, this commonly includes primary-key uniqueness, foreign-key relationships, mandatory relationships, and cardinality constraints.

A customer identifier could be syntactically valid and populated, yet still fail integrity because no corresponding parent entity exists. This illustrates why integrity is different from completeness or validity. The DMBOK2 dimension model explicitly associates integrity with unique identifiers, cardinality, and referential integrity concepts.

Remediation should determine why the orphan record occurred. Potential causes include incorrect load sequencing, deletion of the parent record, integration failure, transformation defects, or absence of database constraints.

Metadata and Data Modeling establish the expected relationship; Data Quality controls then measure whether operational data conforms to it.

Reference Topics: DAMA-DMBOK2 Chapter 13 — Data Integrity; Referential Integrity; Chapter 5 — Relationships and Keys; Data Integration Controls.

===============

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.

===============

DAMA-DMBOK2 defines Data Stewardship in terms of accountability and responsibility for data and for the processes that ensure its effective control and use. The wording in option E closely matches the DMBOK2 definition: stewardship describes accountability and responsibility for data and processes that ensure the effective control and use of data assets.

Stewardship may be formalized through named positions or responsibilities embedded within existing business roles. Its practical scope commonly includes managing business terminology, defining valid values and business rules, establishing or approving Data Quality requirements, resolving data issues, applying standards, and supporting governance decisions.

Option C is too narrow and also confuses stewardship with the broader policy-setting responsibilities of Data Governance. Stewards participate in developing and implementing policies and standards, but stewardship is not merely a policy-creation role. Similarly, it is not a privacy technology function or a project-management construct.

Within Data Quality Management, Data Stewards are critical because quality must be defined relative to business requirements. They help determine what “fit for purpose” means, establish acceptable thresholds, prioritize defects according to business impact, and participate in root-cause remediation.

Metadata Management records stewardship decisions, while Master Data Management uses those decisions to govern shared enterprise entities.

Reference Topics: DAMA-DMBOK2 Chapter 3 — Data Stewardship; Steward Responsibilities; Business Glossary; Chapter 13 — Data Quality Governance and Issue Management.

===============

In DAMA terminology, stewardship is based on the established concept of managing an asset on behalf of another party. DAMA-DMBOK2 defines the underlying term directly: “A steward is a person whose job it is to manage the property of another person.” It then applies that concept specifically to data: Data Stewards manage data assets on behalf of others and in the best interests of the organization.

A Data Steward is therefore much more than a stakeholder or sponsor. Stewardship carries explicit operational accountability. Typical responsibilities include defining and clarifying business data, participating in issue resolution, supporting standards and policies, establishing quality requirements, approving metadata definitions, and ensuring governance decisions are applied within the steward's data domain.

The relationship to Data Quality is particularly important. DMBOK2 identifies Data Stewards as participants in identifying and resolving data-related issues and in ensuring governance policies are followed. They frequently establish or approve Critical Data Elements, Data Quality rules, acceptable thresholds, business definitions, and remediation priorities. Metadata Management records those definitions and rules, while Master Data Management applies stewardship decisions to shared entities such as Customer, Product, Supplier, or Location.

A stakeholder may have an interest in the data, and a sponsor may provide authority or funding, but neither term inherently includes stewardship accountability.

Reference Topics: DAMA-DMBOK2 Chapter 3 — Types of Data Stewards; Stewardship; Data Quality Issue Management; Chapter 13 — Data Quality Governance and Responsibilities.

===============