Microsoft Fabric Analytics Engineer Associate DP-600
Get started today
Ultimate access to all questions.
Ultimate access to all questions.
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 on large tables, and you need to ensure the solution is cost-effective, scalable, and complies with data governance policies. Considering these constraints, which of the following approaches would you choose to significantly improve the query performance? (Choose one option)