As a Microsoft Fabric Analytics Engineer Associate, you are tasked with optimizing the performance of a complex SQL query in a Spark notebook within Azure Databricks. The query involves multiple joins and aggregations across large datasets. Your goal is to ensure the query executes as efficiently as possible, considering factors such as cost, scalability, and the need to minimize recomputation. Which of the following approaches would BEST improve the performance of the query under these constraints? (Choose one option)