You design a Business Intelligence (BI) solution by using SQL Server 2008. At the end of every business day, an application records the inventory to the Products table. The business solution for the application must accommodate the following features:
-The content of the Products table varies every day.
-Historical product attributes are not stored.
You need to identify an appropriate dimensional model to meet the business solution.
Which model should you use?
A.
Degenerate Dimension
B.
Parent�Child Dimension
C.
Type I Slowly Changing Dimension
D.
Type II Slowly Changing Dimension
Explanation:
Tip: "Historical product attributes are not stored" = "Type I"Type 1 Slowly Changing Dimensions
When a dimension is implemented as a Type 1 SCD, we dont keep track of its history as it changes. The members of the dimension represent the way things are right now. With a Type 1 SCD, it is impossible to go back and determine the state of the dimension members at any time in the past.