Answer-first summary for fast verification
Answer: Raise the maximum limit of the SQL endpoint's scaling range
Databricks SQL warehouses, formerly known as SQL endpoints, are designed to meet all your data warehousing needs within the Lakehouse Platform. Key configurable properties include Cluster Size, Auto Stop, Scaling, and Type. In scenarios where the cluster size is already at its maximum but performance issues persist due to increased concurrent users, enhancing the maximum bound of the SQL endpoint's scaling range is the optimal solution. This adjustment allows for smoother query execution across more users by distributing the workload over additional clusters. Learn more about SQL Endpoint Properties at Databricks.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
A data analysis team of 5 members initially experienced satisfactory query performance on a SQL endpoint. However, after increasing the number of concurrent users from 5 to 50, query performance significantly degraded, despite the cluster size being set to its maximum. Which approach should the team adopt to improve query performance for all users?
A
Enable the Auto Stop feature for the SQL endpoint
B
Activate the Serverless feature for the SQL endpoint and adjust the Spot Instance Policy to 'Reliability Optimized'
C
Expand the cluster size of the SQL endpoint
D
Raise the maximum limit of the SQL endpoint's scaling range
E
Switch on the Serverless feature for the SQL endpoint