How will you model a Type II Slowly-Changing Dimension?
A.
Do Nothing
B.
Add a new row to the dimension table with a new key for the changed record
C.
Add an additional column to the dimension table to capture a version of change
D.
Overwrite an existing dimension table record with the changed record
Ans= B
Type I means overwrite
Type II means add new row for changed/newversion, and mark old one as history
B