Answer-first summary for fast verification
Answer: Use Query History, to view queries and select query, and check query profile to time spent in each step
The correct answer is to use Query History to view queries, select the query in question, and check the query profile to see the time spent in each step. The query profile in Databricks SQL provides detailed information on how time is being spent on different queries and the time spent on each step, which is more informative than the Spark UI. For more information, refer to the [Databricks SQL query profile documentation](https://docs.microsoft.com/en-us/azure/databricks/sql/admin/query-profile).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
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
No comments yet.