Answer to Question 1
A data warehouse is a non-operational database intended for use by Business Intelligence applications. A data warehouse is a database system that has data, programs and personnel who specialize in the preparation of data for Business intelligence processing. Databases in data warehouses are frequently denormalized to speed up BI processes. The components of a data warehouse include programs for data extraction/cleaning/preparation, data warehouse DBMSs, data warehouse metadata and data warehouse data. The data warehouse metadata database records the date warehouse data's source, format assumptions, constraints and other relevant facts.
Answer to Question 2
A