Answer-first summary for fast verification
Answer: Use Query History, click the name of the query and then click View Query Profile to see the time spent in each step
The correct answer involves using the Query Profile feature in Databricks SQL to troubleshoot performance bottlenecks. The Query Profile allows you to visualize each query task and its related metrics, such as time spent, number of rows processed, and memory consumption. This helps in identifying the slowest part of a query execution and assessing the impacts of modifications to the query. To view a query profile, you must either be the owner of the query or have the 'Can Manage' permission on the SQL warehouse that executed the query. The process involves viewing the query history, clicking the name of the query, and then selecting 'View Query Profile' to see an overview of basic query metrics. This method is effective for discovering and fixing common mistakes in SQL statements, such as exploding joins or full table scans.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
A data analyst has created a dashboard using Databricks SQL. One of the queries inside it takes a long time to execute, causing the visualization on the dashboard to refresh slowly. What steps can the data analyst take to identify the root cause of this issue?
A
Upgrade the existing SQL warehouse to a serverless SQL warehouse
B
Perform Optimization and Z-Ordering on the table which is used by the query
C
Limit the amount of data fetched by the query
D
Restart the SQL warehouse and then manually refresh the dashboard
E
Use Query History, click the name of the query and then click View Query Profile to see the time spent in each step