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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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 practicingFree to start. No account needed.