What is a disadvantage of Type 3 slowly changing dimension?

• A. Preserves full history of changes
• B. Keeps limited history about changed data
• C. Requires separate history table
• D. Overwrites latest data

Answer: (B)

Type 3 slowly changing dimensions test how history is kept when an attribute changes. In this design, only a limited slice of history is kept: the current value and the most recent previous value sit in the same row. Because you store only that one prior state, you don’t retain a full history of all changes. This makes it fast and simple to query the present value and recent change, but it’s not suitable when you need a complete audit trail or long-term trend analysis. So the disadvantage is the limited history you can track. By contrast, other approaches preserve full history (Type 2) or use separate history structures, which is why those options describe different trade-offs.