Data ce 2017 Question 1. Concepts of Data Warehouse Total 14 marks The following words are provided to you 1. data warehouse 2. preferred 3. data marts 4 normalised 5. snowflake 6. de-normalized 7. constellation Using the keywords provided above to fill in the spaces in the following sentences: Star-schema is amultidimensional data modelling technique for data warehouses design. However, there are other design techniques used for multidimensional modelling such as and There are two types of Data Warehouse Architectures advocated by Ralph Kimball and Bill Inmon respectively. Inmon's architecture provides two layers of access: one is the data warehouse (a mandatory construct in the architecture), another layer is the data marts layer for queries. While Kimball's architecture only provides one layer of access for both are and Kimball advocates star schema where dimension tables for improving query performance Total 10 marks