Which of the following best describes the primary purpose of a data warehouse?
- Providing real-time analytics
- Storing historical data for analysis
- Storing raw data for operational processes
- Supporting online transaction processing (OLTP)
The primary purpose of a data warehouse is to store historical data for analysis, enabling organizations to make informed decisions based on trends and patterns over time.
Loading...
Related Quiz
- In an ERD, what does a double-lined relationship indicate?
- What is the primary purpose of a physical data model in database design?
- A ________ is a dimension table that contains hierarchies, such as time, geography, or product.
- How can parallel processing be utilized in ETL optimization?
- What is the role of a leader election algorithm in distributed systems?