Reduce Query Latency

Ranganathan — Sat, 26 Jul 2025 20:55:19 GMT

While preparing for Databricks Engineer Associate exam, came across a below question.

Question: he data analysis team has reported slow Databricks SQL query performance when using their always-on SQL endpoint, especially during periods of high concurrency with many small queries. The data engineering team is looking into solutions to improve query latency, noting that all queries are directed to the same SQL endpoint. Which of the following methods could the data engineering team employ to reduce the latency of the team‘s queries?

They can turn on the Serverless feature for the SQL endpoint.
o They can turn on the Auto Stop feature for the SQL endpoint.
o They can turn on the Serverless feature for the SQL endpoint and change the Spot Instance Policy to “Reliability Optimized.”
o They can increase the maximum bound of the SQL endpoint’s scaling range.
o They can increase the cluster size of the SQL endpoint.

Ans) They can increase the maximum bound of the SQL endpoint’s scaling range or They can turn on the Serverless feature for the SQL endpoint.

Please suggest what will be the correct answer

Re: Reduce Query Latency

szymon_dybczak — Sun, 27 Jul 2025 17:18:48 GMT

Hi @Ranganathan ,

Since in this scenario we're dealing with high concurrency issue and sql endpoint is always-on the correct answer should be:
- "They can increase the maximum bound of the SQL endpoint’s scaling range"

Re: Reduce Query Latency

Ranganathan — Sun, 27 Jul 2025 20:57:56 GMT

Thanks a lot

topic Re: Reduce Query Latency in Data Engineering

Reduce Query Latency

Re: Reduce Query Latency

Re: Reduce Query Latency