Question
A business wants to compare each employee’s current department with only the immediately previous department. Which SCD method fits best?
Select an option. Your answer will be checked instantly.
Correct Answer: B. Type 3 additional previous-value attribute
Explanation:
Type 3 stores limited history in additional columns on the same row.
It is useful when only a small, predefined number of previous values is needed.
Leave a Reply