ExpertMedium1 markMultiple Choice
CPA · Question 51 · Area I: Information Systems
What is the primary purpose of a 'Data Warehouse' compared to an operational database (OLTP)?
What is the primary purpose of a 'Data Warehouse' compared to an operational database (OLTP)?
Answer options:
A.
To process real-time transactions faster.
B.
To support business intelligence and analytical queries (OLAP) without impacting operational performance.
C.
To store unstructured data like videos and images.
D.
To act as a backup for disaster recovery.
How to approach this question
OLTP (Online Transaction Processing) = Day-to-day work. OLAP (Online Analytical Processing) = Analysis/Reporting. Warehouse = OLAP.
Full Answer
B.To support business intelligence and analytical queries (OLAP) without impacting operational performance.✓ Correct
Data Warehouses are designed for Online Analytical Processing (OLAP). They aggregate data from various sources to support reporting and decision-making, separating this heavy load from the transactional systems.
Common mistakes
Confusing Warehouse with Database or Backup.
Practice the full CPA ISC Practice Exam
82 questions · hints · full answers · grading
More questions from this exam
Q01A CPA is performing a risk assessment for a client that uses a public cloud provider for its core...HardQ02During a walkthrough of a client's change management process, the auditor notes that developers h...HardQ03A service organization provides a real-time transaction processing platform. The service level ag...HardQ04An auditor is reviewing a SQL query used by the finance team to generate a report of all sales tr...HardQ05A healthcare clearinghouse is preparing for a SOC 2® engagement. They utilize a private cloud dep...Hard