Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Ultimate access to all questions.
The data engineering team has observed that when they submit their Databricks SQL queries to a SQL endpoint that is not currently running, the response times are significantly slow. To address this issue and improve the time it takes to return query results, which of the following approaches can the team implement?
Explanation:
The key point in the scenario is that SQL queries are slow when submitted to a non-running SQL endpoint, which indicates that the issue is related to the start-up time of the endpoint. Turning on the Serverless feature for the SQL endpoint reduces the startup time significantly, as serverless endpoints start and scale faster than non-serverless endpoints. Other options, such as increasing the cluster size or adjusting the scaling range, do not directly address the start-up time issue.