I85PREP
⌘ K
ICCP CDP study materials
ICCP CDP study resources

ICCP CDP practice questions

One question at a time. Build your ICCP CDP understanding.

First 50 of 200 questions. Each one lists the choices, the correct answer, and an explanation. The checker at the top of this page saves progress in this browser when it is available.

Continue in the practice tool above to load more questions, 50 at a time.

Question 1Data Management

In a data governance operating model, which artifact most directly assigns accountability for a specific data domain to a named individual?

  1. A retention schedule approved by legal counsel
  2. A data quality dashboard published to business users
  3. A data ownership assignment recorded in the governance charter or RACI Correct answer.
  4. A data steward role description in the HR job catalog

Explanation

Accountability for a data domain is established through formal ownership assignment, typically documented in a governance charter, policy, or RACI matrix naming a specific accountable owner. Role descriptions describe capabilities rather than assigning accountability for a named domain, and dashboards and retention schedules are operational or compliance outputs rather than ownership instruments.

Question 2Data Management

Which characteristic distinguishes a data dictionary from a data catalog?

  1. A dictionary stores data values, while a catalog stores only data definitions
  2. A dictionary applies only to relational databases, while a catalog applies only to unstructured content
  3. A dictionary is maintained only by IT, while a catalog is maintained only by business users
  4. A dictionary documents technical metadata for individual data elements, while a catalog indexes and describes data assets across the enterprise Correct answer.

Explanation

A data dictionary focuses on element-level definitions, formats, and technical attributes for a database or system, whereas a data catalog provides an inventory of data assets with business context, lineage, and searchable metadata across the organization. The distinction is scope and purpose, not ownership by IT versus business or the type of storage technology.

Question 3Data Management

A retail bank wants to track the full journey of a customer identifier from the mobile app through the data warehouse to a regulatory report. Which metadata capability directly supports this requirement?

  1. Data profiling statistics
  2. Data masking policy enforcement
  3. Column-level data lineage Correct answer.
  4. Master data versioning

Explanation

Column-level lineage records how a data element moves and transforms across systems, which is exactly what is needed to trace an identifier from source to report. Profiling describes data content and quality, versioning tracks changes to master records, and masking controls exposure rather than documenting flow.

Question 4Data Management

Which activity is the primary purpose of a data quality profiling assessment on a new source system?

  1. Archiving historical records to reduce storage cost
  2. Establishing a baseline of completeness, uniqueness, and validity for the data Correct answer.
  3. Assigning data ownership to the source system manager
  4. Encrypting sensitive columns before ingestion

Explanation

Profiling measures the actual state of data, such as null rates, duplicate rates, and conformance to formats and domains, producing a baseline against which future quality can be compared. It does not encrypt data, assign ownership, or manage archival.

Question 5Data Management

What is the defining purpose of master data management?

  1. To consolidate all transactional records into a single physical database
  2. To enforce referential integrity constraints inside each operational application
  3. To provide consistent, governed definitions and values for core business entities shared across systems Correct answer.
  4. To replace data warehouses with real-time streaming pipelines

Explanation

Master data management creates governed, shared reference versions of core entities such as customer, product, and supplier so that systems use consistent definitions and values. It does not require physical consolidation of all transactions, does not replace application-level integrity controls, and is not a warehouse replacement strategy.

Question 6Data Management

Which statement best describes the role of a data steward in day-to-day data management?

  1. Performs penetration testing on production databases
  2. Resolves data quality issues and maintains definitions within an assigned domain Correct answer.
  3. Approves enterprise-wide data architecture standards
  4. Owns the budget for the analytics platform

Explanation

Data stewards work within an assigned domain to remediate quality issues, curate definitions, and apply governance decisions in practice. Architecture approval, platform budgeting, and security testing belong to other roles such as architects, technology owners, and security teams.

Question 7Data Management

A data management team needs to define acceptable ranges and formats for a customer birth date field so downstream systems can reject invalid entries. Which artifact should they create?

  1. A business glossary term approval workflow
  2. A data domain constraint specification Correct answer.
  3. A data retention policy
  4. A disaster recovery plan

Explanation

Domain constraints specify permissible values, ranges, and formats for a data element and are used to validate incoming records. Retention policies govern lifecycle duration, glossary workflows govern terminology approval, and disaster recovery plans address continuity, none of which define value validity.

Question 8Data Management

Which metric best indicates that a data quality control is effective over time?

  1. The count of users with access to the quality dashboard
  2. The volume of records loaded each night
  3. The trend of defect rates for the monitored dimension after remediation Correct answer.
  4. The number of rules configured in the quality tool

Explanation

Effectiveness is demonstrated by measurable improvement, such as declining defect rates for the targeted quality dimension after corrective action. Rule counts, dashboard users, and load volumes are activity indicators that do not show whether data quality actually improved.

Question 9Data Management

An organization discovers that the same customer appears under three different identifiers in CRM, billing, and support systems. Which data management practice addresses this directly?

  1. Applying column-level encryption to the customer table
  2. Shortening the retention period for customer records
  3. Increasing the refresh frequency of the reporting warehouse
  4. Entity resolution and matching to create a unified customer identifier Correct answer.

Explanation

Entity resolution uses matching rules and algorithms to determine when records from different sources refer to the same real-world entity, then links or merges them under a unified identifier. Encryption, retention changes, and refresh frequency do not reconcile identity across systems.

Question 10Data Management

A team is designing a data model for a reporting layer where query simplicity and denormalized structures are prioritized. Which modeling approach fits best?

  1. Object-role modeling for ontology capture
  2. Third normal form entity-relationship modeling
  3. Hierarchical modeling for fixed record structures
  4. Dimensional modeling with fact and dimension tables Correct answer.

Explanation

Dimensional modeling organizes data into fact and dimension tables optimized for analytical query simplicity and performance. Normalized entity-relationship models reduce redundancy for transaction processing, while object-role and hierarchical models serve different design goals.

Question 11Data Management

Which control most directly limits the risk of sensitive data being exposed through a self-service analytics environment?

  1. Storing all datasets in a single centralized schema
  2. Applying dynamic data masking based on the querying user's role Correct answer.
  3. Requiring analysts to sign an acceptable use policy annually
  4. Running nightly backups of the analytics environment

Explanation

Dynamic masking enforces protection at query time so that users without the required entitlement see redacted values, which directly limits exposure. Policy attestation is a preventive awareness measure, centralization does not restrict access, and backups address availability rather than confidentiality.

Question 12Data Management

A data architect needs to record how a source attribute is transformed before it lands in a curated table, including the transformation logic. Which metadata type is required?

  1. Descriptive metadata capturing business definitions
  2. Administrative metadata recording access logs
  3. Structural metadata describing table layout
  4. Transformational metadata capturing derivation logic Correct answer.

Explanation

Transformational metadata documents the rules and logic by which source data becomes target data, which is what the architect needs to record derivation. Structural metadata describes layout, administrative metadata covers operational records such as access logs, and descriptive metadata covers business meaning.

Question 13Data Management

When defining a data quality rule for a mandatory regulatory field, which combination of dimensions should be specified to detect both missing and malformed values?

  1. Consistency and provenance
  2. Timeliness and volatility
  3. Uniqueness and granularity
  4. Completeness and validity Correct answer.

Explanation

Completeness detects missing values in a mandatory field, and validity detects values that fail to conform to the required format or domain. Timeliness, volatility, uniqueness, granularity, consistency, and provenance address different aspects and would not jointly detect missing and malformed entries.

Question 14Data Management

A global manufacturer needs product hierarchies to be consistent across regional ERP instances while allowing local attributes. Which MDM implementation style best fits this requirement?

  1. A consolidated analytical hub that only reports on product data
  2. A coexistence style that avoids any shared identifier
  3. A registry style that leaves records in source systems and links them
  4. A centralized authoritative hub that enforces global attributes with local extensions Correct answer.

Explanation

A centralized hub that mandates global attributes while permitting local extensions balances enterprise consistency with regional flexibility. A reporting-only hub does not govern source data, a registry links but does not enforce shared attributes, and a coexistence approach without shared identifiers fails to deliver consistency.

Question 15Data Management

Which practice best supports defensible disposition of records at the end of their retention period?

  1. Moving expired records to an unmanaged archive without documentation
  2. Extending retention indefinitely to avoid legal risk
  3. Deleting records manually whenever storage thresholds are reached
  4. Applying automated, logged disposition rules tied to the approved schedule Correct answer.

Explanation

Defensible disposition requires automated execution of approved retention rules with an audit trail proving that deletion occurred as scheduled. Ad hoc manual deletion, indefinite retention, and undocumented archiving all undermine defensibility and can create legal exposure.

Question 16Data Management

A data management office must prioritize remediation across many quality issues. Which approach provides the most defensible prioritization?

  1. Fixing the issues that are technically easiest to resolve first
  2. Scoring issues by business impact and likelihood of error to guide remediation order Correct answer.
  3. Ranking issues by the number of complaints received from any source
  4. Deferring all remediation until the next annual audit

Explanation

Impact and likelihood scoring links remediation to business consequence and probability of occurrence, producing a defensible, risk-based order of work. Complaint volume alone is biased, ease of fix ignores consequence, and deferral allows risk to accumulate.

Question 17Data Management

Which element is essential in a data sharing agreement between two business units to make obligations enforceable?

  1. A statement of the sending unit's preferred analytics tools
  2. A list of all employees authorized to view the shared data
  3. The target warehouse schema naming convention
  4. Defined permitted uses, security requirements, and breach notification duties Correct answer.

Explanation

Enforceable sharing agreements define permitted purposes, required safeguards, and obligations such as breach notification, which create clear duties for both parties. Tool preferences, full user lists, and naming conventions are operational details that do not establish enforceable obligations.

Question 18Data Management

An organization wants a single agreed definition of "active customer" used consistently in finance and marketing reporting. Where should this definition be governed?

  1. In the ETL job naming conventions
  2. In each team's local spreadsheet documentation
  3. In a business glossary with an approved, versioned definition linked to stewards Correct answer.
  4. In the source application's database comments

Explanation

A governed business glossary provides an approved, versioned definition with assigned stewardship so that all teams reference the same meaning. Local spreadsheets, database comments, and job naming conventions are inconsistent and uncontrolled sources of definition.

Question 19Data Management

A data modeler must represent a many-to-many relationship between products and suppliers in a relational design. What is the standard resolution?

  1. Create an associative table containing keys from both entities Correct answer.
  2. Remove the relationship because it cannot be modeled relationally
  3. Duplicate the supplier attributes in the product table
  4. Embed both foreign keys in the product table as repeating groups

Explanation

A many-to-many relationship is resolved with an associative, or bridge, table whose rows pair product and supplier keys, optionally with relationship attributes. Repeating groups violate first normal form, duplicating attributes causes inconsistency, and the relationship can be modeled relationally.

Question 20Data Management

Which approach best governs the quality of reference data such as country codes and currency codes used across many applications?

  1. Publishing a centrally governed reference data set with change control and distribution Correct answer.
  2. Allowing each application to maintain its own local code list
  3. Encoding codes directly into application source code
  4. Storing codes only in the reporting layer

Explanation

Reference data should be centrally governed, versioned through change control, and distributed so all consuming applications use the same valid values. Local lists, reporting-only storage, and hard-coded values create divergence and maintenance problems.

Question 21Data Management

A data engineer observes that a nightly load sometimes produces duplicate rows because the source system resends records after a failure. Which design change most directly prevents duplicates in the target?

  1. Adding more indexes to the target table
  2. Implementing idempotent upserts keyed on a stable business key Correct answer.
  3. Compressing the source extract files
  4. Increasing the load batch size

Explanation

Idempotent upserts keyed on a stable business key ensure that reprocessing the same record updates rather than duplicates it. Batch size, additional indexes, and compression affect performance or storage but do not prevent duplicate insertion.

Question 22Data Management

An organization needs to reconcile conflicting customer records across systems where no single system is authoritative for all attributes. Which MDM pattern is most appropriate?

  1. A consolidated pattern where the hub is read-only for reporting
  2. A coexistence pattern where the hub and source systems both persist and synchronize governed attributes Correct answer.
  3. A registry pattern with no attribute persistence in the hub
  4. A migration pattern that decommissions all source systems

Explanation

Coexistence supports bidirectional synchronization between the hub and source systems, which fits a situation where authority is distributed across systems. Consolidated hubs are read-only for analytics, registries do not persist attributes, and full migration is not feasible when sources must remain authoritative for some data.

Question 23Data Management

A privacy regulation requires that data subjects be able to obtain the personal data held about them within a defined period. Which data management capability is most critical to meet this obligation reliably?

  1. A nightly full backup of all production databases
  2. A data catalog with lineage linking subject identifiers to downstream stores Correct answer.
  3. A quarterly manual survey of system owners
  4. A retention schedule that deletes records after five years

Explanation

Fulfilling access requests reliably requires knowing where subject data resides and how it flows, which a catalog with identifier-level lineage provides. Backups restore systems but do not locate subject records, manual surveys are slow and error-prone, and retention schedules govern lifecycle rather than access fulfillment.

Question 24Data Management

A data quality program finds that a KPI differs between two reports because each applies a different aggregation rule to the same source. Which control most directly prevents recurrence?

  1. Requiring business users to reconcile reports manually each month
  2. Adding a second source system to cross-check results
  3. Increasing the frequency of report refresh
  4. Codifying the approved calculation logic as shared, governed metric definitions Correct answer.

Explanation

Governed metric definitions establish one approved calculation that all reports consume, eliminating divergent aggregation logic at the source. Additional sources, faster refresh, and manual reconciliation treat symptoms rather than standardizing the calculation.

Question 25Data Management

When designing retention for data derived from personal information, which consideration most affects the lawful retention period?

  1. The number of downstream reports that consume the dataset
  2. The purpose for which the derived data is processed and any legal obligation to retain it Correct answer.
  3. The database engine used to store the derived data
  4. The storage cost of the derived dataset

Explanation

Retention periods for derived personal data must be justified by the processing purpose and any applicable legal retention obligation, since derived data can remain personal data. Storage cost, report counts, and database technology are operational factors that do not establish lawful retention.

Question 26Data Management

In a data management program, which artifact defines the business meaning, allowed values, and ownership of a data element such as 'customer status'?

  1. A capacity utilization report
  2. A data dictionary entry Correct answer.
  3. A network topology diagram
  4. A backup retention schedule

Explanation

A data dictionary documents each data element's business definition, format, permissible values, and accountable owner, which is exactly what describing 'customer status' requires. It is the core metadata reference that keeps definitions consistent across systems.

Question 27Data Management

Which data management function is primarily responsible for assigning accountability for a data domain and resolving cross-functional data decisions?

  1. Help desk operations
  2. Vendor procurement
  3. Application release management
  4. Data governance Correct answer.

Explanation

Data governance establishes decision rights, assigns accountability such as data owners for domains, and provides the forum to resolve cross-functional data issues. It is distinct from day-to-day operational or IT service functions.

Question 28Data Management

A data modeler needs to represent a relationship where each order line belongs to exactly one order and an order can have many lines. Which structure implements this in a relational model?

  1. A foreign key on the order table referencing the order line table
  2. A foreign key on the order line table referencing the order table Correct answer.
  3. A many-to-many junction table between orders and lines
  4. A single table combining orders and lines with no key

Explanation

A one-to-many relationship from order to order line is implemented by placing a foreign key on the 'many' side, the order line table, pointing to the primary key of the order table. This enforces that each line references exactly one parent order.

Question 29Data Management

Which data quality dimension is violated when a customer record lists a ship date that precedes its order date?

  1. Consistency Correct answer.
  2. Timeliness
  3. Uniqueness
  4. Completeness

Explanation

Consistency checks whether values agree with one another under business rules, such as a ship date not preceding its order date. A violated cross-field rule is a consistency defect rather than a missing or duplicated value.

Question 30Data Management

Which activity is a core responsibility of a data owner rather than a data custodian?

  1. Running nightly backup jobs for the database
  2. Applying operating system security patches
  3. Provisioning storage volumes for the warehouse
  4. Approving who may access a data domain and for what purpose Correct answer.

Explanation

The data owner holds business accountability for a data domain, including approving access decisions and acceptable use. Custodians carry out the technical implementation of those decisions, such as backups, storage, and patching.

Question 31Data Management

An organization wants to track the lineage of a report field back to its source columns. Which metadata type does this describe?

  1. Technical lineage metadata Correct answer.
  2. Data quality scorecard metrics
  3. Retention policy metadata
  4. Business glossary terminology

Explanation

Lineage metadata records how data moves and transforms from source to target, including report fields back to source columns. It is a technical metadata category distinct from glossaries, scorecards, and retention rules.

Question 32Data Management

Which practice best protects the integrity of a production data warehouse during a large data migration?

  1. Load all tables in parallel without staging
  2. Validate row counts and key reconciliations before and after each load Correct answer.
  3. Skip backups to shorten the migration window
  4. Disable all constraints to speed up the load

Explanation

Reconciling row counts and key values before and after loads confirms that data arrived completely and without loss or duplication. This control provides evidence that the migration preserved integrity.

Question 33Data Management

Which characteristic distinguishes master data from transactional data?

  1. Master data describes core entities shared across processes, while transactional data records events Correct answer.
  2. Master data is always unstructured, while transactional data is always structured
  3. Master data is deleted after each day, while transactional data is kept forever
  4. Master data is generated only by external partners, while transactional data is internal

Explanation

Master data represents the core business entities, such as customers, products, and suppliers, that many processes reference. Transactional data records discrete business events, such as orders or payments, that occur against those entities.

Question 34Data Management

A retail firm wants one authoritative record for each product that downstream systems subscribe to. Which capability most directly delivers this?

  1. A data lake storing raw clickstream events
  2. A dashboard showing daily sales totals
  3. A master data management hub with match-and-merge and distribution services Correct answer.
  4. A file share where each department stores its own product list

Explanation

An MDM hub consolidates product records, applies matching and merging to create a golden record, and distributes it to subscribers. That directly produces a single authoritative product record for downstream systems.

Question 35Data Management

Which technique most directly reduces false positives when matching customer records across two source systems?

  1. Matching only on exact equality of the full name
  2. Increasing the number of records loaded per batch
  3. Tuning match thresholds using a validated sample of known pairs Correct answer.
  4. Removing all standardization of addresses and names

Explanation

Match thresholds control how similar records must be before they are linked, so calibrating them against a validated sample balances false positives against missed matches. This evidence-based tuning is the standard way to improve match precision.

Question 36Data Management

An organization must prove to auditors that a financial figure shown in a regulatory report came from a specific source system and passed its quality checks. Which combination best supports this?

  1. The database backup taken on the report date
  2. End-to-end lineage plus documented quality results for the report field Correct answer.
  3. A verbal confirmation from the report developer
  4. A screenshot of the report at the time it was published

Explanation

Auditable provenance requires lineage that traces the report field to its source and retained quality results showing the checks it passed. Together they provide verifiable evidence of origin and control effectiveness.

Question 37Data Management

A data steward finds that a required field is populated in 98 percent of records but 15 percent of those values fail a format rule. Which statement best characterizes the quality position?

  1. Uniqueness is the primary defect
  2. Both completeness and validity are fully met
  3. Timeliness is the primary defect
  4. Completeness is high but validity is materially deficient Correct answer.

Explanation

Completeness measures presence of values and is high at 98 percent, while validity measures conformance to the format rule and is failing for a significant share of populated records. The two dimensions must be assessed separately.

Question 38Data Management

Which design choice best supports consistent reference data for currency codes across many applications?

  1. Allowing business users to edit currency codes in production tables
  2. Hard-coding currency values into application source code
  3. Each application maintaining its own local currency list
  4. A centrally governed reference data set published through a controlled distribution service Correct answer.

Explanation

Central governance with controlled distribution ensures every consuming application uses the same approved reference values and receives updates consistently. Local copies and hard-coding create divergence over time.

Question 39Data Management

A team must document the business rules that determine how 'revenue' is calculated for reporting. Where does this documentation most appropriately belong?

  1. A business glossary entry linked to the calculation rule Correct answer.
  2. A firewall configuration record
  3. A server inventory spreadsheet
  4. An employee payroll ledger

Explanation

A business glossary captures agreed business definitions and can link to the calculation rules that operationalize them. This keeps the meaning and the computation traceable to one governed source.

Question 40Data Management

Which control is most effective for preventing unapproved changes to a critical master data attribute in production?

  1. Relying on users to report suspicious changes
  2. Enforcing change approval workflow with an audit trail before updates are applied Correct answer.
  3. Granting broad update rights to all analysts for speed
  4. Sending a monthly summary email of changes after they occur

Explanation

A pre-change approval workflow with an audit trail stops unapproved modifications before they reach production and records who approved what. Post-hoc reporting and broad access only detect or enable improper changes.

Question 41Data Management

An analyst needs to join a sales fact table to a date dimension to report by fiscal quarter. Which modeling concept does the date dimension represent?

  1. A bridge table resolving a many-to-many relationship
  2. A slowly changing dimension of type three
  3. A conformed dimension usable across multiple fact tables Correct answer.
  4. A degenerate dimension stored only in the fact table

Explanation

A date dimension is a standard conformed dimension that many fact tables reference, enabling consistent time-based reporting across subject areas. Conformed dimensions are shared and reusable by design.

Question 42Data Management

A privacy officer asks how long customer interaction data may be retained. Which input most directly determines the lawful maximum retention period?

  1. The database vendor's default settings
  2. The documented purpose and applicable legal retention requirements for that data Correct answer.
  3. The number of analysts who query the data
  4. The storage cost of the data platform

Explanation

Retention limits should be derived from the documented business purpose and any applicable legal or regulatory requirements that set minimum or maximum periods. Storage cost and technical defaults are not lawful bases for retention.

Question 43Data Management

Two source systems assign different customer identifiers and neither is authoritative. Which approach best produces a durable cross-reference for downstream use?

  1. Maintain a cross-reference table mapping source identifiers to a governed master identifier Correct answer.
  2. Overwrite both source identifiers with a new value in each system
  3. Ask each downstream team to match records manually
  4. Delete records that do not match automatically

Explanation

A governed cross-reference table preserves the original identifiers while providing a stable master key for downstream joins. This avoids destructive changes to source systems and removes repeated manual matching.

Question 44Data Management

A data engineer must ensure that a nightly aggregation can be reproduced for audit six months later. Which practice most directly supports this?

  1. Documenting only the final aggregated totals
  2. Version-controlling the transformation logic and recording the source snapshot used Correct answer.
  3. Recomputing with whatever code is currently deployed
  4. Relying on the developer's memory of the logic

Explanation

Reproducibility requires both the exact logic version and the source data state used at run time. Recording these together allows the aggregation to be recreated and verified later.

Question 45Data Management

An organization wants to reduce duplicate customer creation at the point of entry across multiple CRM front ends. Which control addresses the root cause most directly?

  1. A policy asking staff to be careful
  2. Real-time duplicate search against the master record during data entry Correct answer.
  3. A quarterly report of duplicates found after the fact
  4. A manual cleanup project run once a year

Explanation

Preventing duplicates at entry requires a real-time check against existing master records so users see and reuse matches before creating a new record. This is a preventive control at the point where defects originate.

Question 46Data Management

A firm must reconcile product attributes from three regional ERP systems into a single golden record where each region can override only locally relevant attributes. Which design best meets this requirement?

  1. A central hub with global attributes mastered centrally and local attributes delegated by region Correct answer.
  2. Independent regional records with no central reconciliation
  3. A single global record overwriting all regional values
  4. A data lake where all attributes are stored without ownership

Explanation

The hub pattern masters shared global attributes centrally while delegating locally relevant attributes to regional owners, preserving both consistency and local flexibility. This resolves conflicting sources through explicit ownership rules.

Question 47Data Management

A team discovers that a quality rule flags valid records whenever the source sends a legitimate status value not yet in the reference list. Which action best addresses the root cause?

  1. Suppress all alerts from the rule
  2. Disable the quality rule permanently
  3. Formalize change management for the reference data so new valid values are added under control Correct answer.
  4. Increase the batch size of the load

Explanation

The false positives stem from reference data that lags behind legitimate business values, so a controlled change process for reference data prevents recurrence. Disabling or suppressing the rule hides genuine defects along with the false alarms.

Question 48Data Management

An organization must decide whether to retain derived analytical datasets built from personal data after the source records are deleted. Which consideration is most decisive?

  1. Whether the derived data still permits identification and remains within the original lawful purpose Correct answer.
  2. Whether analysts find the derived dataset convenient
  3. Whether the derived dataset is smaller than the source
  4. Whether the derived dataset is stored in a cloud service

Explanation

Derived data that still identifies individuals remains personal data, so retention must stay justified by the original purpose and applicable requirements. Storage location, size, and user convenience do not establish a lawful basis.

Question 49Data Management

A governance council must resolve a dispute where finance and marketing define 'active customer' differently, causing conflicting KPIs. Which action best resolves the underlying cause?

  1. Approve a single governed definition with named ownership and publish it for adoption Correct answer.
  2. Remove the KPI from both reports
  3. Let each function keep its own definition and label the reports separately
  4. Average the two definitions into one blended metric

Explanation

Conflicting KPIs trace to competing definitions, so a governance decision that approves one definition, assigns an owner, and publishes it for adoption addresses the root cause. Simply labeling or blending definitions leaves ambiguity in place.

Question 50Data Management

A data management team must choose between two remediation projects: one fixes a defect affecting regulatory reporting, the other fixes a cosmetic display issue. Which prioritization approach is most defensible?

  1. Prioritize the issue with the largest number of tickets
  2. Prioritize whichever team raised the issue first
  3. Prioritize the issue that is easiest to fix first
  4. Score each issue by business impact, regulatory exposure, and affected record volume Correct answer.

Explanation

Defensible prioritization weighs the business and regulatory consequences of a defect along with its reach across records. This transparent scoring lets stakeholders compare issues on consistent criteria rather than convenience or volume alone.