Ultimate access to all questions.
You are designing a data warehouse solution for a retail company that requires tracking changes to product information over time to support historical reporting. The company has specific requirements: they need to minimize storage costs while ensuring compliance with data retention policies, and they must be able to quickly retrieve the current state of any product. Considering these constraints, which Slowly Changing Dimension (SCD) type would be the MOST appropriate to implement, and why? Choose the best option from the following: