Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Ultimate access to all questions.
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?
Explanation:
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.