CPA ISC Practice Test

CPA ISC Data Management & SQL Practice Questions

Data Management & SQL makes up 4 of every 50 questions on a Tigertest CPA ISC practice test. Here are 10 of the 16 questions on it, each with the answer and the reason.

Updated by the Tigertest team. Based on the AICPA's 2026 ISC blueprint. Original multiple-choice questions; 50 per test, weighted like the real section's three areas, 75% target. Not affiliated with the AICPA or NASBA.

  1. 1. Which data store keeps raw data in any format, structured or not, until someone needs to use it?

    • A.Operational database
    • B.Data lake
    • C.Data warehouse
    • D.Data mart

    Answer: B. A data lake holds raw data in its native format. A data warehouse holds data that has already been cleaned and structured for reporting.

  2. 2. A subset of a data warehouse built for the needs of one department is a:

    • A.Staging area
    • B.Transaction log
    • C.Data lake
    • D.Data mart

    Answer: D. A data mart serves a single business area, such as sales. A staging area is where data sits temporarily during loading.

  3. 3. A central fact table joined directly to denormalized dimension tables forms which schema?

    • A.Star
    • B.Network
    • C.Snowflake
    • D.Hierarchical

    Answer: A. In a star schema each dimension is a single table linked straight to the fact table. A snowflake schema breaks the dimensions into further normalized tables.

  4. 4. Dimension tables that are split into further normalized sub-tables form which schema?

    • A.Flat file
    • B.Document store
    • C.Snowflake
    • D.Star

    Answer: C. The snowflake schema normalizes dimensions, which saves space but needs more joins. The star schema keeps each dimension in one table.

  5. 5. In the data life cycle, which stage comes last?

    • A.Active business use
    • B.Data creation and capture
    • C.Final disposition
    • D.Archival storage

    Answer: C. The life cycle runs from creation through active use and storage to final disposition. Archiving keeps data; disposition ends its life.

  6. 6. A sales table repeats the customer's full address on every order line. This mainly shows the table is not:

    • A.Normalized
    • B.Encrypted
    • C.Partitioned
    • D.Indexed

    Answer: A. Normalization removes redundant data by storing the address once in a customer table. Repeating it invites update anomalies when an address changes.

  7. 7. A date column rejects the value 2026-02-30 because it is not a valid date. Which integrity rule is this?

    • A.Transaction atomicity
    • B.Entity integrity
    • C.Referential integrity
    • D.Domain integrity

    Answer: D. Domain integrity limits a column to valid values of its type and range. Referential integrity is about foreign keys matching existing primary keys.

  8. 8. A rule that every row must have a unique primary key that is never null enforces:

    • A.Data lineage rules
    • B.Entity integrity
    • C.Referential integrity
    • D.Domain integrity

    Answer: B. Entity integrity makes each row identifiable. Referential integrity instead requires foreign keys to match existing primary keys.

  9. 9. Where would an auditor look to find each field's name, data type, length and allowed values?

    • A.Backup catalog
    • B.Data dictionary
    • C.Audit trail
    • D.Query execution plan

    Answer: B. A data dictionary documents the definition of every data element. An audit trail records who changed data and when.

  10. 10. Pulling data from source systems, reshaping it and loading it into a warehouse is called:

    • A.Data mirroring
    • B.CRUD
    • C.OLTP
    • D.ETL

    Answer: D. Extract, transform and load moves data into a warehouse. OLTP is day-to-day transaction processing in the source systems.

Practice all 16 data management & sql questions, and the rest of the 200-question bank, in the free CPA ISC training sets. Questions you miss come back until you have mastered them.

Start practicing

Free to start. No account needed.