Reduce Latency Of SQl queries

[Ranganathan]

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

[szymon_dybczak · Accepted solution]

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"