Databricks Certified Data Engineer Associate — Question 70

A data analysis team has noticed that their Databricks SQL queries are running too slowly when connected to their always-on SQL endpoint. They claim that this issue is present when many members of the team are running small queries simultaneously. They ask the data engineering team for help. The data engineering team notices that each of the team’s queries uses the same SQL endpoint.

Which approach can the data engineering team use to improve the latency of the team’s queries?

Answer options

• A. They can increase the cluster size of the SQL endpoint.
• B. They can increase the maximum bound of the SQL endpoint’s scaling range.
• C. They can turn on the Auto Stop feature for the SQL endpoint.
• D. They can turn on the Serverless feature for the SQL endpoint.

Correct answer: B

Explanation

Increasing the maximum bound of the SQL endpoint’s scaling range allows for more resources to be utilized during peak usage times, which can reduce latency for concurrent queries. Simply increasing the cluster size (option A) might not address the underlying capacity limits of the SQL endpoint. Turning on the Auto Stop feature (option C) would actually hinder performance by stopping the endpoint during inactivity, while the Serverless feature (option D) is not designed specifically to address the performance issues related to concurrent small queries.