PracticeISCFree practice exam

ISC · Information Systems and Data Management · 7 practice questions

MDM Address Changes: When Is Steward Approval Required?

A non-authoritative source cannot change the golden record without the required data-steward authorization. Below, compare AlphaCo's same address submission with only the stewardship case disposition changed.

The ruleUnder AlphaCo's governance policy, a lower-tier address submission requires steward validation and authorization before modifying the golden record. An approved change also requires coordinated updates to Billing and CRM.

Try one first

AlphaCo maintains an MDM hub that stores the golden customer record and distributes updates to downstream systems. Data governance defines the authoritative-system hierarchy for the mailing address attribute as: Billing System (highest) > CRM > Web Portal (lowest). Governance policy states that changes to the golden record originating from lower-tier (non-authoritative) sources must be reviewed and authorized by a data steward before the golden record is modified. AlphaCo's MDM also performs a nightly sync that ingests Billing System data (the authoritative feed for addresses) and will overwrite lower-tier values during that process. A customer submitted a change-of-address through the Web Portal and attached a scanned utility bill that appears to validate the new address. The Web Portal now shows the new address, but the Billing System and CRM still show the old address. What is the most appropriate immediate action for the MDM team?
Hint

Identify that the mailing address is master data and apply the governance rule about how changes from non-authoritative sources must be handled, who must validate and authorize before the golden record is changed.

Side by side

Pending reviewApproved after validationRejected after review
Same AlphaCo submissionPortal address change with a scanned utility bill that appears valid.Portal address change with a scanned utility bill that appears valid.Portal address change with a scanned utility bill that appears valid.
Same mailing-address hierarchyBilling > CRM > Web Portal.Billing > CRM > Web Portal.Billing > CRM > Web Portal.
Same source values before actionPortal shows the new address; Billing and CRM show the old address.Portal shows the new address; Billing and CRM show the old address.Portal shows the new address; Billing and CRM show the old address.
Same nightly syncBilling's authoritative feed overwrites lower-tier address values.Billing's authoritative feed overwrites lower-tier address values.Billing's authoritative feed overwrites lower-tier address values.
Only changed fact: case dispositionReview and authorization are pending.The steward validated the evidence and authorized the change.The steward reviewed the evidence and rejected the change.
Immediate actionVerify the evidence and obtain authorization before modifying the golden record.Update the golden record and coordinate Billing and CRM corrections.Do not apply the submitted address; document the rejection.
Golden-record treatmentNo change while authorization is pending.Apply the authorized new address.Do not apply the rejected address.
Billing and CRM coordinationArrange corrections only if the steward authorizes the change.Coordinate corrections so Billing's nightly feed preserves the approved address.Do not propagate the rejected address to Billing or CRM.
Stewardship audit trailRecord submitted evidence and pending status; record validation and authorization or rejection before any golden-record modification.Record submitted evidence, successful validation, and authorization before updating the golden record.Record submitted evidence, validation result, and rejection; make no golden-record change.

Key points

  • Remember: Supporting evidence starts the review; steward authorization permits the golden-record change.
  • Billing is AlphaCo's authoritative source for mailing addresses.
  • Record the evidence, validation result, and authorization or rejection in the stewardship case before any golden-record modification.

How the exam traps you

  • Automatically accept the Portal address because a utility bill is attached. Verify the evidence and obtain steward authorization first.
  • Leave a pending submission unresolved because Billing will sync tonight. Complete the stewardship review instead of relying on the sync.
  • Update only the golden record after approval. Coordinate Billing and CRM corrections so the nightly sync does not restore the old address.

6 more, each from a different angle

0 of 6 answered · 0 correct

Question 2

A mid-sized company uses locally maintained Excel spreadsheets in sales, procurement, and accounts payable to supplement the ERP's customer and supplier master records. Multiple departments maintain their own copies, producing duplicate records, inconsistent tax-ID formats, and missing bank details, which have caused duplicate vendor payments and reconciliation errors. Management has no formal data governance, no named data stewards, and no documented data-quality rules. Which action should management take FIRST to most effectively address these master-data quality problems?
Hint

Which first step establishes accountability and measures the scope and causes of the problems before choosing technical controls or consolidation?

Question 3

Company Alpha operates several autonomous business units, each maintaining its own customer database. Management procured ETL tools, data profiling and matching software, and a central MDM repository and plans to create a single enterprise 'golden record' for each customer to support reporting and operations. Enterprise-level data governance (standard definitions, authoritative-source rules) has not yet been established. Assume there are no legal or regulatory barriers to centralizing customer data. Which of the following conditions would most limit the MDM's ability to produce accurate, enterprise-wide customer golden records?
Hint

Decide whether the obstacle prevents deciding which source value is the authoritative 'truth' (an organizational/governance issue) or merely makes matching, ingestion, or freshness technically harder.

Question 4

A company is building a customer analytics warehouse by combining data from its CRM, billing, and service-ticket systems. Management has already approved a common reporting glossary for dashboard terms, and IT has documented the ETL field mappings. Backups are tested, role-based access is in place, and the retention schedule is not under dispute. However, the same customer often exists under different IDs in different source systems, multiple source records can load for the same customer on the same night, and the warehouse currently keeps whichever source value loads last for shared fields such as address and status. As a result, customer-level reports frequently disagree across departments even though the dashboard formulas are consistent. Assuming the main concern is the reliability of ongoing enterprise reporting, what is the primary data management issue?
Hint

Focus on whether the problem is definitions, detection, retention, or deciding which shared customer record should be treated as the enterprise source of truth.

Question 5

A company maintains customer master data in three integrated applications. Sales staff update customer name and billing address in the CRM, credit staff update legal entity name and tax ID in the ERP, and customers can update shipping address directly in the e-commerce platform. Each night, interfaces synchronize customer master data across all three systems using a blanket "last update wins" rule at the record level. During 20X6, management observed that legal names entered in ERP were sometimes replaced by informal trade names entered in CRM, tax IDs occasionally reverted to blank after a customer changed only a shipping address in the e-commerce platform, and duplicate customer records continued because each system used different matching logic. Management wants the single Year 1 action that most directly addresses the root data-management weakness without replacing any application. Assume access controls, uptime, and general change-management processes are adequate. Which response is most appropriate?
Hint

Focus on whether the weakness is mainly about speed, input validation, approval, or ownership of specific data attributes across systems.

Question 6

Company Apex is launching a customer master data improvement initiative. The organization has designated a data owner (business unit director), a data steward (business analyst team), and IT operations. Which of the following tasks is most appropriately the primary responsibility of the data steward?
Hint

Distinguish who sets policy (owners/governance), who operates and maintains data quality (stewards), and who handles technical infrastructure (IT).

Question 7

A mid-sized retail chain operates 70 stores, an e-commerce site, a loyalty program, a marketing CRM, and a separate finance/returns system. Management wants a reliable single view of customers for analytics and operational uses, but there is no consistent enterprise customer identifier: each system issues its own customer ID, name and address formats vary, loyalty numbers are missing on some transactions, and duplicate customer records appear across systems, causing repeated marketing sends and inconsistent lifetime-value reports. With limited budget, which conclusion about addressing the company's customer data problems is best supported by these facts?
Hint

Decide whether the needed solution must produce and sustain a single enterprise customer identifier and governance across systems, or whether it merely centralizes or periodically cleans reporting data.

Drill all 170 Data management questionsMixed across every rule in the topic, so you have to spot which one applies. That is how the exam does it.

Common questions

Can a utility bill let a Web Portal address override the MDM golden record?

Not automatically. AlphaCo requires the data steward to validate the evidence and authorize the change before modifying the golden record.

What happens after a data steward approves an address change?

Update the golden record and coordinate corrections to Billing and CRM. Billing's nightly feed could otherwise overwrite the approved address with the old value.

What happens if a data steward rejects an address change?

Do not apply the submitted address. Record the reviewed evidence, validation result, and rejection in the stewardship case.

Watch it solved

A full CPA ISC task-based simulation on Data management, worked step by step.

Data Quality Defects & ETL Reconciliation | CPA ISC Simulation (TBS) on YouTube

Practice ISC like the real exam

The free ChatCPA simulator: real exam layout, timed testlets, starting with a question on this topic. No account needed to start.

Open the free simulator →

More on Data management

All Data management practice →

Questions from the ChatCPA bank of 17,658 CPA exam questions, each with a written reason for every wrong answer. ChatCPA is built by Nicholas Miller, CPA (Oregon #14907). How these pages are made. Spot an error? Tell us.