Databricks Certified Data Engineer Associate — Question 44

A data engineering team has noticed that their Databricks SQL queries are running too slowly when they are submitted to a non-running SQL endpoint. The data engineering team wants this issue to be resolved.

Which of the following approaches can the team use to reduce the time it takes to return results in this scenario?

Answer options

• A. They can turn on the Serverless feature for the SQL endpoint and change the Spot Instance Policy to "Reliability Optimized."
• B. They can turn on the Auto Stop feature for the SQL endpoint.
• C. They can increase the cluster size of the SQL endpoint.
• D. They can turn on the Serverless feature for the SQL endpoint.
• E. They can increase the maximum bound of the SQL endpoint's scaling range.

Correct answer: D

Explanation

Turning on the Serverless feature for the SQL endpoint (Option D) allows for more efficient resource management, which can significantly speed up query execution. Options A and E involve configurations that may not directly address the slow query performance in a non-running endpoint scenario. Option B, enabling Auto Stop, could actually delay performance since it would stop the endpoint after inactivity. Option C, increasing the cluster size, may help but is not as effective as leveraging the Serverless feature in this specific context.