What does data warehouse mean on the CPA exam?
Data warehouse. A separate store holding integrated historical data organized for analysis, rather than for running the business day to day. Loaded from operational systems on a schedule.
Which CPA exam sections use data warehouse?
Data warehouse appears in the ISC section of the CPA exam.
Related terms
- extract, transform, load: The sequence that moves data from source systems into a data warehouse: extract from the sources, transform into a common structure, then load into the target.
- online analytical processing: Processing optimized for querying accumulated data across many dimensions, as a data warehouse does.
- General Data Protection Regulation: The European Union regulation governing processing of personal data.
- encryption at rest: Protecting stored data so that reading the disk or the backup yields nothing usable.