Which statement best describes the purpose of a data warehouse in relation to an operational database?

Which statement best describes the purpose of a data warehouse in relation to an operational database?

• A. It is developed to analyze specific business subject areas, whereas an operational database supports specific operations
• B. It is used for real-time transaction processing
• C. It stores only metadata
• D. It is designed for high-speed updates

Answer: (A)

Understanding why a data warehouse exists vs. an operational database comes down to purpose: analysis versus day-to-day operations. A data warehouse is built to support analysis across specific business subject areas, collecting and consolidating data from multiple sources so you can run complex queries, generate reports, and spot trends over time. It emphasizes stability and historical context, making it easier to compare periods and understand long-term patterns. An operational database, by contrast, is designed to handle the daily activities of the business, processing transactions in real time and updating records quickly. Because of this difference in use, the statement that a data warehouse is developed to analyze specific business subject areas, whereas an operational database supports specific operations, best captures their roles. Real-time transaction processing belongs to operational databases, not warehouses, and warehouses are not typically optimized for high-speed updates or limited to metadata.

Understanding why a data warehouse exists vs. an operational database comes down to purpose: analysis versus day-to-day operations. A data warehouse is built to support analysis across specific business subject areas, collecting and consolidating data from multiple sources so you can run complex queries, generate reports, and spot trends over time. It emphasizes stability and historical context, making it easier to compare periods and understand long-term patterns. An operational database, by contrast, is designed to handle the daily activities of the business, processing transactions in real time and updating records quickly. Because of this difference in use, the statement that a data warehouse is developed to analyze specific business subject areas, whereas an operational database supports specific operations, best captures their roles. Real-time transaction processing belongs to operational databases, not warehouses, and warehouses are not typically optimized for high-speed updates or limited to metadata.