DAMA DQ-1220 - DAMA Data Quality Specialist

DAMA-DMBOK2 distinguishes the two concepts according to origination versus authoritative consumption. A System of Record (SoR) is an authoritative system in which data is created, captured, or maintained according to defined rules and expectations. A System of Reference (SoRef) is an authoritative location from which consumers obtain reliable information for transactions or analysis even though that information may have originated elsewhere.

Therefore, option A expresses the essential distinction most accurately. For example, an operational CRM may be the System of Record for customer data because customer information is captured and maintained there. An MDM hub or enterprise data-sharing platform can subsequently become the System of Reference used by other applications, even though the original data was created in the CRM.

This distinction is important for Data Quality and lineage. Consumers need to know where values originated, where authoritative corrections are performed, which system distributes trusted values, and which stewardship process governs conflicts between sources. Metadata should therefore record source lineage, system roles, transformations, and authoritative status.

Option D is incorrect because “System of Record” and “System of Reference” do not correspond respectively to master data and reference data categories. Either architectural role can participate in managing different categories of enterprise data.

Reference Topics: DAMA-DMBOK2 Chapter 10 — System of Record and System of Reference; Trusted Sources; MDM Architecture; Metadata Lineage; Chapter 13 — Data Quality and Reference/Master Data Management.

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

DAMA-DMBOK2 states that Data Modeling tools and model repositories are necessary for managing the Enterprise Data Model at all levels. This includes maintaining relationships among conceptual, logical, and physical representations and controlling how models created for different purposes fit into the wider enterprise architecture.

An enterprise modeling repository provides more than diagramming. It supports version control, definitions, lineage between model layers, comparison of changes, reuse of standard entities and attributes, enforcement of modelling conventions, and communication across projects. Many modelling tools also provide relationship and lineage capabilities that enable architects to trace how concepts represented at a high level are implemented in detailed models.

Option C describes one important capability—visualizing and communicating database designs—but it is narrower than the DMBOK2 purpose stated in the question. Similarly, modelling tools support governance and architectural visualization but are not solely established for either function.

For Data Quality, governed models provide the structural metadata from which rules can be derived. Keys support uniqueness; relationships support integrity; domains support validity; mandatory attributes support completeness; and standardized definitions support consistency.

The repository therefore becomes an important bridge between Data Architecture, Metadata Management, Data Governance, and Data Quality.

Reference Topics: DAMA-DMBOK2 Chapter 5 — Data Modeling Tools and Repositories; Enterprise Data Model; Conceptual/Logical/Physical Models; Chapter 13 — Structural Quality Rules.

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

DAMA-DMBOK2 explicitly identifies a core goal of Reference and Master Data Management as ensuring that shared Master and Reference Data is complete, consistent, current, and authoritative across organizational processes.

Complete means required shared entities and attributes are sufficiently populated for their intended use. Consistent means equivalent data has compatible meaning and representation wherever it is consumed. Current means the information reflects an acceptably recent state. Authoritative means the organization recognizes a trusted source or governed process for determining the accepted value.

These characteristics are particularly important because Master and Reference Data is reused widely. An incorrect Product classification, Customer identifier, Country code, or Supplier status can therefore propagate defects across many systems and business processes.

DAMA also emphasizes that shared Master and Reference Data belongs to the organization rather than to a single application or department. This creates a strong requirement for enterprise stewardship and governance.

Reference and Master Data Management consequently interacts directly with Chapter 13. MDM can consolidate and distribute shared data, but it does not guarantee quality automatically. Matching, survivorship, validation, standardization, stewardship, and continuous monitoring are required to ensure the resulting records remain trustworthy.

Reference Topics: DAMA-DMBOK2 Chapter 10 — Reference and Master Data Management Goals; Shared Data; Authoritative Sources; Stewardship; Chapter 13 — Completeness, Consistency and Currency.

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

The 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.

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

An address beginning with HTTPS indicates that the website uses an encrypted security layer for communications between the client and server. DAMA-DMBOK2 explicitly identifies HTTPS as a security technology and states that the https:// prefix indicates that a website is equipped with an encrypted security layer.

HTTPS uses TLS to protect information while it is transmitted across the network. Its principal security objectives include confidentiality of the communication channel, integrity of transmitted information, and authentication of the server through digital certificates. This is especially important when transmitting credentials, personal information, payment details, or other sensitive data.

HTTPS does not indicate what database technology the website uses, whether a content management system is installed, whether third-party cookies are present, or whether language-translation functionality exists. Those characteristics are independent of transport-layer encryption.

From a Data Management standpoint, encryption in transit is one component of a broader Data Security framework. Sensitive data must also be protected at rest, appropriately classified, access-controlled, monitored, and governed throughout its lifecycle.

Data Quality also benefits indirectly because integrity protection helps prevent unauthorized alteration of values during transmission.

Reference Topics: DAMA-DMBOK2 Chapter 7 — HTTPS; Encryption; Data in Transit; Authentication; Confidentiality; Integrity.

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

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.

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

DAMA-DMBOK2 recommends an incremental implementation strategy for Data Governance because governance introduces changes in accountability, decision rights, standards, processes, and organizational behaviour. Attempting an enterprise-wide implementation immediately creates unnecessary cultural and operational risk.

The implementation guidance is explicit that most governance rollout strategies are incremental, commonly beginning with a significant initiative such as Master Data Management or with a particular region, business unit, or domain. Enterprise-wide deployment as the initial step is described as uncommon.

Incremental implementation provides several control advantages. The organization can validate roles and decision mechanisms, establish stewardship practices, prove business value, refine policies, develop metrics, and correct weaknesses before expanding the governance framework. This aligns closely with Data Quality management, where organizations normally prioritize Critical Data Elements and high-value domains rather than attempting to measure and remediate every data element simultaneously.

Executive sponsorship is important, but a mandate alone does not produce sustainable adoption. Likewise, individual leadership charisma cannot substitute for operating processes, accountability, metrics, and change management. A short consultant-driven exercise also conflicts with DAMA's treatment of governance as an ongoing organizational capability.

Incremental rollout therefore offers the strongest mechanism for embedding governance permanently while demonstrating measurable value.

Reference Topics: DAMA-DMBOK2 Chapter 3 — Implementation Guidelines; Organization and Culture; Adjustment and Communication; Chapter 13 — Data Quality Improvement and Governance.

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

The scenario describes a many-to-many relationship: one Person may use several Addresses, while one Address may be associated with several Persons. In relational modelling, this should be resolved using an associative entity—here, Person Address Usage—between Person and Address. The original many-to-many relationship is thereby replaced with two one-to-many relationships. DAMA-oriented references identify this approach directly under the addition of associative entities.

The associative entity normally contains foreign keys referencing both parent entities and may also contain attributes describing the association itself, such as address type, usage purpose, effective date, end date, or primary-address indicator.

Simply modifying the primary keys of Person or Address does not resolve the semantic relationship. Changing foreign-key role names also changes terminology rather than cardinality. The term “partnership entity” is not the appropriate modelling construct.

This design has important Data Quality consequences. It permits explicit integrity constraints between the association and both parent entities, prevents ambiguous repeated columns, and allows the organization to validate rules such as valid effective periods and permitted address-use types.

Reference Topics: DAMA-DMBOK2 Chapter 5 — Relationships; Cardinality; Associative Entities; Resolving Many-to-Many Relationships; Chapter 13 — Referential Integrity and Consistency.

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

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.

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