SQL Server Data Warehouse design best practice for Analysis Services (SSAS)

3. (Exercise 4.7 in Chapter 4 of the textbook) Design a data warehouse (i.e. create a multidimensionalmodel such as a star schema or a snowflake schema) for a regional weather bureau. The weather bureauhas about 1000 probes, which are scattered throughout various land and ocean locations in the regionto collect basic weather data, including air pressure, temperature, and precipitation at each hour. Alldata are sent to the central station, which has collected such data for more than 10 years. You