DQ-1220 Exam Dumps - DAMA CDMP Questions and Answers

A primary business driver for establishing a Data Quality Management program is to reduce the risks and costs associated with poor-quality data. DAMA-DMBOK2 treats low-quality data as a direct source of operational cost and organizational risk. The Chapter 13 business drivers include increasing the value of organizational data, reducing risks and costs caused by poor quality, improving efficiency and productivity, and protecting organizational reputation.

Poor-quality data generates both visible and hidden costs. Examples include rework, manual correction, incorrect invoices, failed customer interactions, regulatory exposure, inappropriate decisions, integration delays, missed opportunities, and reputational damage. DMBOK2 further emphasizes that low-quality data represents cost and risk rather than value, making Data Quality management necessary throughout the data lifecycle.

A formal DQ program addresses these consequences through defined requirements, profiling, measurement, root-cause analysis, corrective and preventive action, monitoring, and governance. The purpose is therefore broader than making the DQ team efficient or supporting a specific technology initiative such as warehouse consolidation.

The economic and risk-reduction argument also provides the strongest basis for executive sponsorship because improvements can be linked directly to measurable business outcomes.

Reference Topics: DAMA-DMBOK2 Chapter 13 — Business Drivers; Costs of Poor Data Quality; Risk Reduction; Data Quality Program; Data Quality Lifecycle.

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

The strongest preventive control is to restrict data entry to the approved country-code domain. Prevention at the point of creation is generally more effective and less costly than repeatedly correcting invalid values downstream.

A controlled drop-down list, validated API, or reference-domain lookup ensures that users can select only permitted codes. This directly supports Validity and improves Consistency across applications.

The rule should be linked to centrally governed Reference Data rather than hard-coded independently in each application. That allows changes to the permitted domain to be managed systematically.

Downstream cleansing remains useful for historical defects or external data, but it should not be the primary control when the organization controls the source-entry process.

DAMA's framework links Reference/Master Data Management to consistency of shared values and Chapter 13 to defining and monitoring Data Quality controls.

Reference Topics: DAMA-DMBOK2 Chapter 13 — Preventive Controls; Validity; Data Creation; Chapter 10 — Reference Data; Controlled Domains.

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

The process is Encryption. DAMA-DMBOK2 defines encryption as converting readable plaintext into coded information so that privileged or sensitive content cannot be understood without the appropriate decryption mechanism. The DMBOK2 security section specifically describes encryption as translating plain text into complex codes to hide privileged information and also notes its use in protecting transmission integrity and validating identity.

Encryption supports confidentiality both at rest and in transit. Depending on implementation, organizations may use symmetric encryption, asymmetric or public-key encryption, hashing for particular integrity or authentication functions, and other cryptographic mechanisms.

The crucial distinction is that encryption deliberately changes the representation of information according to a cryptographic algorithm and key structure. Encapsulation, enhancement, elimination, and exaggeration are not substitutes for cryptographic protection.

Within the wider DAMA framework, encryption should be applied according to classification and risk. Highly sensitive information may require stronger cryptographic controls, restricted key management, rotation procedures, and separation of duties.

Data Quality and Data Security intersect at integrity: unauthorized changes may produce inaccurate data even when availability remains unaffected. Security controls therefore protect not merely secrecy but the reliability and trustworthiness of managed information.

Reference Topics: DAMA-DMBOK2 Chapter 7 — Encryption; Confidentiality; Data Integrity; Cryptographic Controls; Security Classification.

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

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.

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

Discovering and documenting metadata about physical data assets provides visibility into how data moves and is transformed between systems. This is a core function of technical metadata and data lineage.

DAMA-DMBOK2 states that technical metadata describes the technical characteristics of data, the systems that store it, and the processes that move it within and between systems. Examples include physical table and column names, ETL job information, source-to-target mappings, and lineage documentation with upstream and downstream impact information. The certification question therefore points directly to option D; the same interpretation is independently reflected in published CDMP-oriented material.

This capability is critical to Data Quality because a defect observed in a report or downstream application may not originate in the current system. It may have been introduced through extraction logic, transformation rules, reference-data conversion, aggregation, or loading.

Documented physical metadata allows analysts to trace the affected value backward, identify its source, inspect each transformation, and isolate the point at which the defect occurred. It also supports change-impact analysis: modifying a source field or mapping can reveal which downstream assets may be affected.

Metadata therefore provides the evidence required for systematic root-cause analysis rather than symptom-based correction.

Reference Topics: DAMA-DMBOK2 Metadata Management — Technical Metadata; Source-to-Target Mapping; Data Lineage; Data Integration and Interoperability; Chapter 13 — Root-Cause Analysis and Quality Monitoring.

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

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.

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

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 definition describes Data Policies. DAMA-DMBOK2 states that data policies are directives that translate organizational principles and management intent into fundamental rules controlling how data is created, acquired, protected, maintained, assured for quality, and used.

The distinction between governance and policy is important. Data Governance is the broader authority and decision-making framework. Policies are one of the principal instruments produced or sponsored through that framework. They define what must or must not occur. Standards and procedures subsequently translate those policies into specific implementation requirements and operational methods.

For Data Quality, a policy might require business-critical data to have designated ownership, documented definitions, measurable quality rules, monitored thresholds, and formal remediation processes. The detailed thresholds themselves may reside in standards or rule repositories rather than in the high-level policy.

Metadata Management makes policy operational by documenting definitions, classifications, ownership, lineage and applicable quality rules. Master Data Management applies those policies to shared business entities and controlled reference values. Data Stewards then monitor compliance and escalate violations through governance mechanisms.

Data asset valuation is concerned with determining economic value, while Data Management encompasses the complete discipline. Neither provides the specific “directive” definition stated in the question.

Reference Topics: DAMA-DMBOK2 Chapter 3 — Data Policies; Governance Principles; Standards and Procedures; Chapter 13 — Data Quality Governance; Metadata and Master Data interactions.

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

The principal risk is inconsistent customer-name values across systems. When multiple applications can independently update the same business fact without an authoritative source or coordinated Master Data process, conflicting representations are likely to emerge.

The problem is architectural and governance-related as much as it is a Data Quality issue. The organization must determine where the authoritative value is created, who is responsible for approving changes, how updates propagate, and how conflicts are resolved.

DAMA's public framework emphasizes a single trusted or consistent approach to shared core entities through Reference and Master Data Management.

The relevant Data Quality dimensions include Consistency, Accuracy, Currency, and potentially Uniqueness. An application may hold a technically valid legal name but still contain an outdated or conflicting value.

Metadata and lineage should document which systems create, master, distribute, or merely consume the attribute.

Reference Topics: DAMA-DMBOK2 — Authoritative Sources; Master Data Management; Data Architecture; Consistency; Lineage; Stewardship.

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

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.

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