Answer-first summary for fast verification
Answer: They can increase the maximum bound of the SQL endpoint’s scaling range.
Increasing the maximum bound of the SQL endpoint’s scaling range allows more resources to be allocated dynamically as the load increases. This can help improve query performance when multiple team members run queries simultaneously. Increasing the cluster size might help but it’s not as flexible and efficient as scaling. The Auto Stop feature would not address performance issues directly and is more related to cost management. Turning on the Serverless feature might help, but it's not necessarily available in every Databricks environment or the best first step to take.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
The data analysis team has observed that their Databricks SQL queries experience significant slowdowns when connected to their always-on SQL endpoint. This performance degradation becomes evident especially when numerous team members execute small queries simultaneously. Seeking assistance, they approach the data engineering team. Upon investigation, the data engineering team identifies that all of the team’s queries are utilizing the same SQL endpoint. What strategy can the data engineering team employ to reduce the query latency for the team?
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.
No comments yet.