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

Questions 21–25

1. 21application · medium

   A data analyst is new to the Databricks Intelligence platform and wants to understand which queries in the workspace are consuming the most resources. The analyst needs a single, high-level view that lists queries with their execution times and resource usage, without having to inspect each query individually. What should the analyst use?

   • AThe account's billing dashboard
   • BThe Query Insights page
   • CThe Query Profiler log for each query
   • DThe cluster's Spark UI
   Reveal Solution Discussion Select an answer first
2. 22foundation · easy

   What is the main purpose of the Query Profiler log?

   • ATo automatically tune query performance
   • BTo provide detailed execution statistics for diagnosing query performance issues
   • CTo manage user access to queries
   • DTo store the query results for business reporting
   Reveal Solution Discussion Select an answer first
4. 23application · medium

   A data analyst wants to find all queries run by the finance team in the last 24 hours that took longer than 10 minutes. The analyst is using Query Insights. What is the most efficient way to narrow down the list?

   • ACheck the cluster's Spark UI for queries run by the finance team.
   • BApply a filter for the finance team, set the time range to the last 24 hours, and sort by execution time.
   • CExport all queries from the last 24 hours to a CSV and filter by the finance team in a spreadsheet.
   • DOpen the Query Profiler log for each query run by the finance team in the last 24 hours.
   Reveal Solution Discussion Select an answer first
5. 24foundation · easy

   What is the primary purpose of Query Insights in the Databricks Intelligence platform?

   • ATo automatically rewrite queries to improve their performance
   • BTo provide a centralized view of query performance metrics for monitoring and troubleshooting
   • CTo store the results of all queries for later retrieval
   • DTo provide a SQL editor for writing and executing queries
   Reveal Solution Discussion Select an answer first
6. 25expert · hard

   A data analyst is reviewing the Query Profiler log for a query that is running slowly. The log shows that a 'Sort' operation is taking a very long time. The analyst notices that the sort is happening on a column that is not used in any subsequent operation. What is the most likely cause of this inefficiency?

   • AThe query has an unnecessary ORDER BY clause that is forcing a global sort, which is expensive.
   • BThe query is suffering from data skew, causing the sort to be unevenly distributed.
   • CThe sort is a side-effect of a join operation, which is required for the join to work.
   • DThe cluster is too small, causing the sort to run slowly.
   Reveal Solution Discussion Select an answer first