As a Microsoft Fabric Analytics Engineer Associate working with a Spark notebook in Azure Databricks, you are tasked with optimizing the performance of a complex SQL query that involves multiple subqueries and temporary tables. The query is part of a critical reporting process that must complete within a tight SLA, and the dataset is expected to grow significantly over time. Considering the need for scalability, maintainability, and performance, which of the following approaches would you take to improve the performance of the query? (Choose one option.)