Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
You've noticed that SQL queries in Azure Databricks notebooks have inconsistent execution times. What method would you use to automatically improve these queries' performance by analyzing past execution patterns?
A
Setting up an Azure Logic Apps workflow to periodically review query performance logs and suggest indexes or optimizations in a report.
B
Utilizing Azure Monitor to track query performance over time and manually adjusting queries based on observed trends.
C
Implementing Databricks' native support for adaptive query execution to dynamically optimize plans without explicit historical analysis.
D
Developing a machine learning model within Databricks to analyze query execution logs, predict optimal configurations, and apply adjustments.
