Pass the DAMA CDMP DQ-1220 Questions and answers with Dumpstech

The metric demonstrates Validity because it measures whether address values conform to a defined format or standard.

Validity checks whether data satisfies specified rules concerning datatype, pattern, permitted values, ranges, or structures. Postal formatting rules might require approved postcode structure, valid country-code syntax, or required address components.

The metric does not prove that the address belongs to the correct customer. A perfectly formatted address may still be factually wrong. That would be an Accuracy problem.

DAMA-aligned government guidance defines validity in terms of conformity to expected format, type, range, and other predefined rules.

A mature address-quality program may combine validity with verification against authoritative postal reference data, duplication checks, completeness rules, and currency monitoring.

Quality scorecards should therefore label the metric precisely rather than calling the result a generic "accuracy score."

Reference Topics: DAMA-DMBOK2 Chapter 13 — Validity; Accuracy; Data Quality Metrics; Address Quality; Reference Data.

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

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.

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

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.

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

Pareto analysis is the appropriate technique because it identifies the relatively small number of causes responsible for a large proportion of observed problems.

The team should arrange defect categories in descending order by frequency or business impact and calculate their cumulative contribution. If four categories account for 78% of complaints, prioritizing those categories is likely to generate substantially greater benefit than spreading equal effort across all twenty.

The value of Pareto analysis in Data Quality is not that every problem follows an exact 80/20 relationship. Rather, it provides an evidence-based mechanism for focusing scarce remediation resources on the defect classes that generate the most significant outcomes.

Frequency should not be the only prioritization criterion. A rare defect could produce severe regulatory, safety, financial, or reputational consequences. Governance should therefore combine volume analysis with business impact and risk.

Once priority defects are selected, the team should perform root-cause analysis and introduce preventive controls instead of merely fixing individual records.

Reference Topics: DAMA-DMBOK2 Chapter 13 — Statistical Quality Tools; Pareto Analysis; Issue Prioritization; Business Impact; Root-Cause Remediation.

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

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.

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

A proliferation of independently implemented data warehouses, lakes, and poorly governed “data swamps” commonly indicates that the organization has emphasized technology acquisition over establishing an integrated, authoritative view of enterprise data. The issue is not the existence of multiple technologies by itself; distributed platforms can be justified by legitimate architectural requirements. The warning sign is uncontrolled duplication without clear authoritative sources, enterprise architecture, governance, lineage, and consistency controls.

DAMA-DMBOK2 treats Data Architecture as the mechanism for aligning data assets with enterprise strategy and reducing unnecessary fragmentation. A mature architecture identifies authoritative sources, data flows, integration patterns, shared definitions, and the required relationship between operational and analytical stores. The DAMA framework also emphasizes that technologies should support business and data-management objectives rather than dictate them.

From a Data Quality perspective, uncontrolled proliferation creates competing versions of values, inconsistent transformations, duplicate master records, contradictory metrics, and unclear ownership. These conditions undermine consistency and make root-cause analysis difficult.

A “single point of truth” does not necessarily require one physical database. It requires controlled authority and consistent semantics across the landscape.

Reference Topics: DAMA-DMBOK2 — Data Architecture; Data as an Asset; Authoritative Sources; Data Integration; Metadata; Data Quality Consistency.

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

The dataset can be complete while remaining inaccurate. Completeness measures whether the required records and values are present; Accuracy measures whether those values correctly represent reality.

If every customer has a telephone number, the field may achieve 100% completeness. However, if 8% of those numbers belong to other people, the values are inaccurate.

This distinction is one of the most important principles in Data Quality measurement. A populated field is not automatically trustworthy. Similarly, a syntactically valid value is not necessarily accurate.

DAMA-aligned guidance explicitly distinguishes these dimensions and notes that a complete dataset may still contain incorrect values.

The appropriate quality scorecard should therefore present completeness and accuracy separately rather than treating one as evidence of the other.

For high-risk customer contact processes, the business may define independent thresholds for both dimensions. Verification services, customer confirmation, authoritative sources, and exception handling may be needed to improve accuracy after basic completeness has already been achieved.

Reference Topics: DAMA-DMBOK2 Chapter 13 — Completeness; Accuracy; Data Quality Dimensions; Metrics; Fitness for Purpose.

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

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.

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

The need to manage data movement efficiently is a primary business driver for Data Integration and Interoperability (DII). DAMA-DMBOK2 states this directly. Modern organizations operate hundreds or thousands of databases, applications, files, services, data stores, external interfaces, and analytical platforms. Data must continually move among these environments, often across organizational boundaries.

Without disciplined integration management, data movement becomes fragmented, expensive, difficult to monitor, and highly dependent on duplicated point-to-point interfaces. DII addresses this problem by establishing controlled mechanisms for extraction, transformation, messaging, replication, orchestration, APIs, data virtualization, and other forms of information exchange.

From a Data Quality perspective, every movement of data presents an opportunity either to preserve quality or to damage it. Source-to-target mappings must maintain semantic meaning, transformations must be controlled, reference values must remain consistent, and lineage must show how values were altered.

Metadata Management therefore records mappings, interface definitions, transformation rules, and lineage. Master Data Management uses integration mechanisms to distribute governed master and reference data consistently between systems.

Data Warehousing is a major consumer of integration capabilities, but the broader discipline whose explicit driver is efficient movement across systems is Data Integration and Interoperability.

Reference Topics: DAMA-DMBOK2 Chapter 8 — Business Drivers; Data Integration and Interoperability; Data Movement; Chapter 13 — Consistency, Integrity and Transformation Quality.

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

The conventional flow is Extract, Transform, and Load (ETL). Data is extracted from source systems, placed in a staging environment where required transformations are performed, and then loaded into the target Data Warehouse. Consequently, the transformed staging data is made ready and loaded into the Data Warehouse. DAMA-oriented training material presents this exact progression.

The staging area provides a controlled environment in which source data can be integrated without imposing transformation workloads directly on operational systems. Typical activities include datatype conversion, standardization, code translation, matching, deduplication, validation, derivation, consolidation, and handling rejected records.

From a Data Quality perspective, staging is especially important because many quality controls can be applied before data reaches the analytical repository. Profiling can identify unexpected distributions, invalid values, missing records, duplicate entities, referential-integrity defects, and inconsistent reference values. Failed records can then be quarantined or remediated according to governed rules.

Although metrics and profiling may occur in staging, they are supporting activities rather than the final destination in the ETL sequence. Likewise, metadata repositories document the transformation rather than serving as the main target for the transformed business data.

Reference Topics: DAMA-DMBOK2 — Data Warehousing and Business Intelligence; ETL; Staging Areas; Data Integration; Chapter 13 — Profiling, Cleansing, Standardization and Validation.

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