Answer-first summary for fast verification
Answer: They can increase the maximum bound of the SQL endpoint’s scaling range.
The most effective method to reduce query latency in this scenario is to increase the maximum bound of the SQL endpoint’s scaling range. This allows the SQL endpoint to automatically scale up its resources during periods of high demand, providing more computing power to handle the increased query load and leading to faster query execution times. Other options like turning on the Serverless feature or Auto Stop feature, or increasing the cluster size, may not be as effective or cost-efficient for this specific scenario.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
The 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?
A
They can increase the cluster size of the SQL endpoint.
B
They can turn on the Auto Stop feature for the SQL endpoint.
C
They can increase the maximum bound of the SQL endpoint’s scaling range.
D
They can turn on the Serverless feature for the SQL endpoint and change the Spot Instance Policy to “Reliability Optimized.”
E
They can turn on the Serverless feature for the SQL endpoint.
No comments yet.