A data analyst is troubleshooting a slow query that runs on a shared cluster. Query Insights shows the query has a high 'Wait Time' but a low 'Execution Time'. The analyst suspects resource contention from other workloads on the cluster. What is the most effective way to confirm this hypothesis?

Re-run the query on a single-user cluster to see if the wait time decreases.

Check Query Insights for other queries that were running concurrently and see if they also had high wait times.

Open the Query Profiler log for the query and look for a specific stage with a long duration.

Review the cluster's autoscaling metrics to see if the cluster was at capacity.

In Query Insights, which of the following is a valid way to filter queries to find poorly performing ones?

Filter by the SQL text of the query

Filter by the number of rows returned

Filter by the cluster's IP address

Filter by execution time to show only queries that took longer than a specified duration

A data analyst is looking at the Query Profiler log for a query and wants to understand the sequence of operations that the query performed. The log shows a tree-like structure with operators like 'Filter', 'Join', and 'Aggregate'. What is this structure called, and what is its primary purpose?

The task list, which shows the individual tasks that ran on each node.

The shuffle map, which shows how data was partitioned and moved between nodes.

The stage timeline, which shows the start and end times of each stage.

The execution plan, which shows the logical and physical steps the query engine took to process the data.

DatabricksCertified Data Analyst Associate

Domain 5Objective 2

Identify Poorly Performing Queries in the Databricks Intelligence Platform, Such as Query Insights, Query Profiler Log, Etc. DATA-ANALYST-ASSOCIATE Practice Questions (Page 4)

Part of the Section 5: Analyzing Queries domain, which makes up ~17% of our current practice bank. Databricks does not publish an official question count, but from its 90-minute exam (~35–60 total, ~6–10 in this domain), expect 1–2 from this objective — we provide 27 practice questions to prepare you well beyond it. (estimate)

27questions here

6free pages

7concepts

Questions 16–20

16expert · hard
A data analyst is troubleshooting a slow query that runs on a shared cluster. Query Insights shows the query has a high 'Wait Time' but a low 'Execution Time'. The analyst suspects resource contention from other workloads on the cluster. What is the most effective way to confirm this hypothesis?
Select an answer first
17foundation · easy
Which Query Insights metric would you examine to understand how much compute and memory a query consumed?
Select an answer first
18foundation · easy
In the Query Profiler log, which component represents a unit of work that is executed on a single node?
Select an answer first
19foundation · easy
In Query Insights, which of the following is a valid way to filter queries to find poorly performing ones?
Select an answer first
20application · medium
A data analyst is looking at the Query Profiler log for a query and wants to understand the sequence of operations that the query performed. The log shows a tree-like structure with operators like 'Filter', 'Join', and 'Aggregate'. What is this structure called, and what is its primary purpose?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DATA-ANALYST-ASSOCIATE

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Databricks. “DATA-ANALYST-ASSOCIATE” is a trademark of its owner, used for identification only.

Identify Poorly Performing Queries in the Databricks Intelligence Platform, Such as Query Insights, Query Profiler Log, Etc. DATA-ANALYST-ASSOCIATE Practice Questions (Page 4)

Questions 16–20

A data analyst is troubleshooting a slow query that runs on a shared cluster. Query Insights shows the query has a high 'Wait Time' but a low 'Execution Time'. The analyst suspects resource contention from other workloads on the cluster. What is the most effective way to confirm this hypothesis?

Which Query Insights metric would you examine to understand how much compute and memory a query consumed?

In the Query Profiler log, which component represents a unit of work that is executed on a single node?

In Query Insights, which of the following is a valid way to filter queries to find poorly performing ones?

A data analyst is looking at the Query Profiler log for a query and wants to understand the sequence of operations that the query performed. The log shows a tree-like structure with operators like 'Filter', 'Join', and 'Aggregate'. What is this structure called, and what is its primary purpose?

Keep studying — Section 5: Analyzing Queries