Which SCD type is the passive method that always retains the original value?

Which SCD type is the passive method that always retains the original value?

• A. Type 0 SCD
• B. Type 2 SCD
• C. Type 3 SCD
• D. Type 1 SCD

Answer: (A)

Retaining the original value without applying updates defines this method. Type 0 SCD is configured so that once a value is loaded, it stays the same; subsequent source changes don’t alter the stored value and there is no history tracking. This makes it a passive approach that always preserves the original value. Other approaches handle changes differently: Type 1 overwrites the old value with the new one, so the original is lost. Type 2 adds new rows to capture every change and keep full history. Type 3 keeps a limited history by storing a previous value in an extra column on the same row. Among these, the one that simply keeps the initial value unchanged is Type 0 SCD.

Retaining the original value without applying updates defines this method. Type 0 SCD is configured so that once a value is loaded, it stays the same; subsequent source changes don’t alter the stored value and there is no history tracking. This makes it a passive approach that always preserves the original value.

Other approaches handle changes differently: Type 1 overwrites the old value with the new one, so the original is lost. Type 2 adds new rows to capture every change and keep full history. Type 3 keeps a limited history by storing a previous value in an extra column on the same row. Among these, the one that simply keeps the initial value unchanged is Type 0 SCD.