What is the primary purpose of a 'Data Warehouse' compared to an operational database (OLTP)?

Answer options:

To process real-time transactions faster.

To support business intelligence and analytical queries (OLAP) without impacting operational performance.

To store unstructured data like videos and images.

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.

Question 50 All questions Question 52

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...Hard Q02During a walkthrough of a client's change management process, the auditor notes that developers h...Hard Q03A service organization provides a real-time transaction processing platform. The service level ag...Hard Q04An auditor is reviewing a SQL query used by the finance team to generate a report of all sales tr...Hard Q05A healthcare clearinghouse is preparing for a SOC 2® engagement. They utilize a private cloud dep...Hard

View all 82 questions →