Databricks Certified Data Analyst Associate — Question 47

Query History provides Databricks SQL users with a lot of benefits. A data analyst has been asked to share all of these benefits with their team as part of a training exercise. One of the benefit statements the analyst provided to their team is incorrect.

Which statement about Query History is incorrect?

Answer options

• A. It can be used to troubleshoot slow running queries.
• B. It can be used to view the query plan of queries that have run.
• C. It can be used to debug queries.
• D. It can be used to automate query execution on multiple warehouses (formerly endpoints).

Correct answer: D

Explanation

The correct answer is D because Query History does not have the capability to automate query execution across multiple warehouses; its primary function is to provide insights into past queries. Options A, B, and C are accurate as they describe legitimate features of Query History that assist users in troubleshooting and analyzing query performance.