LeetQuiz Logo
Privacy Policy•contact@leetquiz.com
© 2025 LeetQuiz All rights reserved.
Databricks Certified Data Engineer - Associate

Databricks Certified Data Engineer - Associate

Get started today

Ultimate access to all questions.


When setting up a SQL Endpoint, you observe that query performance degrades during peak hours as the number of concurrent users increases, causing the same queries to take longer to run. Which of the following actions can help resolve this issue?

Real Exam




Explanation:

The correct action is to increase the maximum bound of the SQL endpoint’s scaling range. This allows more clusters to be added, enabling queries to run on available clusters instead of waiting in the queue. This approach is effective for improving throughput during peak usage times by scaling out (adding more clusters). Scaling up (increasing cluster size) is more suited for improving the performance of individual queries rather than handling increased concurrency. The Serverless feature and Auto Stop feature do not directly address the issue of concurrent query performance degradation.

Powered ByGPT-5