ISC · Information Systems and Data Management · 170 practice questions
Data management: master data, governance, retention and archives
Most exam questions boil down to three moves: know which data is master vs reference vs transactions, fix cross‑system identity with governance and MDM, and let law and purpose drive retention and legal holds.
Mixed drill
Questions from every rule below, shuffled. You get the explanation after each one, and at the end, the rules to review.
The rules, one page each
- Master Data vs Reference Data vs Transactional Data vs MetadataSort it
Master data describe persistent core business entities. Reference data supply controlled classification or validation values; transactional data record business events; metadata describe data's structure, meaning, or lineage.
- Customer MDM After a Merger: Fix Duplicate IDs Across SystemsWhat next?
Use an MDM hub with governed enterprise identifiers, matching and survivorship rules, and attribute-level systems of record to reconcile customer masters. Preserve source-ID mappings and synchronize authoritative updates to operational systems.
- MDM Address Changes: When Is Steward Approval Required?Side by side
Under 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.
- How Poor Master Data Management Distorts AR ReportsWhat next?
When AR reports aggregate balances by customer ID, duplicate customer records can fragment balances and undermine aging and allowance estimates. Duplicate master records alone do not establish duplicate sales postings.
- OLTP vs data warehouse vs data lake: where transactions and analytics belongSide by side
Process transactions in a normalized OLTP database with enforced referential integrity to avoid redundancy and orphaned records; feed data (batch or CDC) to a read-optimized, often denormalized, data warehouse for curated reporting, or to a data lake for raw data of any structure; do not run heavy analytics against the OLTP system.
- What Governs Data Retention Periods?What next?
Applicable legal, regulatory, and contractual requirements govern retention and deletion. North's invoices have a seven-year minimum. Documented business needs may justify longer retention only when permitted; they cannot shorten a binding minimum.
- Legal Hold vs Retention Schedule: Archives and BackupsContrasting cases
A legal hold, reasonably anticipated litigation, or binding retention requirement overrides scheduled deletion for relevant records. Preserve accessible, complete records; rotating recovery backups are not a substitute for preservation.
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 data management. No account needed to start.
Open the free simulator →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.