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?

Real Exam

Change the Spot Instance Policy from “Cost optimized” to “Reliability Optimized.”

2.9%

Run optimize and Z ordering

6.2%

Restart the SQL endpoint

1.4%

Select the SQL endpoint cluster, spark UI, SQL tab to see the execution plan and time spent in each step

23.2%

Use Query History, to view queries and select query, and check query profile to time spent in each step

66.3%

Databricks Certified Data Engineer - Associate