Identity the true statement about a data warehouse

Identity the true statement about a data warehouse

Identity the true statement about a data warehouse

A.
The data warehouse is typically refreshed as often as a transactional system,

B.
Data warehouse queries are simpler than OLTP queries.

C.
A data warehouse typically contains historical data.

D.
Queries against a data warehouse never need summarized information.

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *