DAMA DQ-1220 - DAMA Data Quality Specialist

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.

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

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.

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

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.

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

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.

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

DAMA-DMBOK2 states three principal goals for Data Storage and Operations: managing data availability throughout the lifecycle, ensuring the integrity of data assets, and managing the performance of data transactions. Option A corresponds directly to those goals.

Availability means that required data and database services are accessible when business processes need them. This requires capacity planning, backup and recovery, business continuity, monitoring, and resilient infrastructure.

Integrity means protecting data assets from corruption or inappropriate alteration and maintaining reliable technical structures. Operational controls such as recovery procedures, transaction management, and controlled changes contribute directly to integrity.

Performance concerns the efficiency and responsiveness of database transactions and related storage operations. Capacity, cache behaviour, indexing, workload patterns, and system resources must therefore be monitored.

Glossary management belongs primarily to Metadata Management, while authorized access is principally a Data Security responsibility. User experience is not one of the stated core objectives for this knowledge area.

The relationship to Data Quality is direct: technically corrupted or unavailable information cannot be fit for purpose even when its business definitions are correct.

Reference Topics: DAMA-DMBOK2 Chapter 6 — Goals and Principles of Data Storage and Operations; Availability; Integrity; Performance; Chapter 13 — Data Reliability and Timeliness.

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

A business-data-driven roadmap translates the desired enterprise data architecture into an executable sequence of initiatives. DAMA-DMBOK2 explains that business capabilities consume and produce data, which creates dependencies between capabilities. The roadmap begins with relatively independent capabilities and progresses toward capabilities whose execution depends on data generated elsewhere. The architecture therefore establishes a coherent dependency chain before implementation work is organized.

The decisive final planning action is to turn that dependency sequence into implementable projects. Consequently, establishing the sequence of projects that will establish the data value chain is the best answer. Describing the data value chain, analysing data flows, identifying dependency challenges, and resequencing capabilities are analytical steps that precede portfolio sequencing.

DMBOK2 states that the roadmap should move from capabilities with the least dependency toward those with progressively greater dependencies, thereby providing the implementation order. It also emphasizes integrating the Enterprise Data Architecture roadmap with enterprise milestones, resources, and business-capability workstreams.

From a Data Quality perspective, sequencing matters because upstream master and reference data must reach an acceptable quality state before downstream transactional processes can depend on it.

Reference Topics: DAMA-DMBOK2 Chapter 4 — Data Architecture; Develop a Roadmap; Data Dependencies; Data Value Chain; Chapter 13 — Data Quality and other Knowledge Areas.

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