As a Microsoft Fabric Analytics Engineer Associate, you are designing a data pipeline that requires complex data transformations to meet the business requirements of a global retail company. The solution must ensure data accuracy, support high scalability, and minimize operational costs. Given these constraints, which of the following approaches is the BEST to implement complex data transformations in the pipeline? (Choose one option)