How might a Slowly Changing Dimension Type 2 implementation typically be structured in a table?

A With columns like effective_start_date, effective_end_date, and an is_current flag alongside the changed attribute B By deleting the entire dimension table whenever any value changes C By storing the new value only and discarding the old value with no trace D By creating a brand new database for every change