Which of the following describes a type two update in a Slowly Changing Dimensions (SCD)
stage?

A.
An update that overwrites the existing column value.

B.
An update that replaces the existing column value if a specified condition is satisfied.

C.
An update that retains the existing column value in a list and adds the new value to the list.

D.
An update the retains the existing column value in an historical row and creates a new row with
the new value.

Explanation: