Question: what are the key characteristics of a data warehouse?
Answer: Some data is denormalized for simplification and to improve performance. Large amounts of historical data are used. Queries often retrieve large amounts of data. Both planned and ad hoc queries are common. The data load is controlled.