10.1k views
5 votes
A data warehouse extracts current and historical data from multiple operational systems in an organization. What is the primary purpose of this extraction?

a. Enhancing real-time processing
b. Facilitating data backups
c. Improving data security
d. Supporting analytical reporting

User Pixeltrix
by
8.8k points

1 Answer

2 votes

Final answer:

The primary purpose of using a data warehouse to extract and store data from various systems is to support analytical reporting. This centralized data storage enables sophisticated analysis that aids decision-making within an organization.

Step-by-step explanation:

The primary purpose of extracting current and historical data from multiple operational systems in an organization and storing it in a data warehouse is d. Supporting analytical reporting. The consolidation of data in a centralized location allows for more sophisticated analysis, supporting decision-making processes throughout the organization. Data warehouses are optimized for read access and complex queries, which benefits reporting and analytical tasks rather than enhancing real-time processing, facilitating data backups, or improving data security directly.

User Cetnar
by
8.1k points