Ultimate access to all questions.
As a Microsoft Fabric Analytics Engineer working on a data warehouse project, you are tasked with implementing a star schema that includes slowly changing dimensions (SCD). The project requires maintaining historical data accuracy for compliance reporting, while also ensuring the solution is scalable and cost-effective. Considering these requirements, which approach would you choose to handle SCD in this schema? (Choose one correct option)