Your question is Design SCD Type 1 and 2. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
You're working on a dimensional model for analytics and need to track changes in business entities over time. Some attributes should always reflect the latest value, while others need full history for reporting and audit use cases.
How do you design and implement Slowly Changing Dimensions (SCD Type 1 and Type 2)?