1Z0-515 · Question #58
Identity the true statement about a data warehouse
The correct answer is C. A data warehouse typically contains historical data. A data warehouse is a relational database that is designed for query and analysis rather than for transaction processing. It usually contains historical data derived from transaction data, but it can include data from other sources. It separates analysis workload from…
Question
Identity the true statement about a data warehouse
Options
- AThe data warehouse is typically refreshed as often as a transactional system,
- BData warehouse queries are simpler than OLTP queries.
- CA data warehouse typically contains historical data.
- DQueries against a data warehouse never need summarized information.
How the community answered
(42 responses)- A2% (1)
- B5% (2)
- C81% (34)
- D12% (5)
Explanation
A data warehouse is a relational database that is designed for query and analysis rather than for transaction processing. It usually contains historical data derived from transaction data, but it can include data from other sources. It separates analysis workload from transaction workload and enables an organization to consolidate data from several sources.
Topics
Community Discussion
No community discussion yet for this question.