Knowledge check

Completed

1.

Which SCD type would you use to keep history of changes in dimension members by adding a new row to the table for each change?

Type 1 SCD.

Type 2 SCD.

Type 3 SCD.

2.

Which SCD type would you use to update the dimension members without keeping track of history?

Type 1 SCD.

Type 2 SCD.

Type 3 SCD.

You must answer all questions before checking your work.