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