Microsoft Fabric Analytics Engineer Associate DP-600
Get started today
Ultimate access to all questions.
As a Microsoft Fabric Analytics Engineer Associate, you are optimizing a Spark notebook in Azure Databricks that includes a SQL query with performance issues. The query's prolonged execution is delaying the entire data processing pipeline. Considering the need for cost efficiency, compliance with data governance policies, and scalability, which of the following steps would you prioritize to enhance the SQL query's performance? (Choose one option)
As a Microsoft Fabric Analytics Engineer Associate, you are optimizing a Spark notebook in Azure Databricks that includes a SQL query with performance issues. The query's prolonged execution is delaying the entire data processing pipeline. Considering the need for cost efficiency, compliance with data governance policies, and scalability, which of the following steps would you prioritize to enhance the SQL query's performance? (Choose one option)
Simulated