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

Questions 26–27

1. 26application · medium

   A data analyst is investigating a specific slow query and needs to see detailed execution statistics, including the time spent in each stage and the number of tasks. Which tool should the analyst use to get this granular level of detail for a single query?

   • AThe workspace's audit log
   • BThe cluster's autoscaling metrics
   • CQuery Insights
   • DThe Query Profiler log
   Reveal Solution Discussion Select an answer first
2. 27application · medium

   A data analyst is reviewing the Query Profiler log for a query that joins two large tables. The log shows a very high number of records being shuffled between tasks, and the 'Shuffle Write' and 'Shuffle Read' times are significant. What common performance issue does this pattern most strongly suggest?

   • AThe query is CPU-bound, and the cluster needs more cores.
   • BThe query is suffering from data skew, where some partitions have more data than others.
   • CThe query is performing an excessive number of shuffles, likely due to a join on non-distributed keys or a missing partition.
   • DThe query is waiting on I/O, and the storage layer is the bottleneck.
   Reveal Solution Discussion Select an answer first