Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
One of the queries in the Databricks SQL Dashboard is taking a long time to refresh. What steps can you take to identify the root cause of this issue?
A
Change the Spot Instance Policy from “Cost optimized” to “Reliability Optimized.”
B
Run optimize and Z ordering
C
Restart the SQL endpoint
D
Select the SQL endpoint cluster, spark UI, SQL tab to see the execution plan and time spent in each step
E
Use Query History, to view queries and select query, and check query profile to time spent in each step
