Databricks Certified Data Analyst Associate — Question 27

A data analyst has set up a SQL query to run every four hours on a SQL endpoint, but the SQL endpoint is taking too long to start up with each run.
Which of the following changes can the data analyst make to reduce the start-up time for the endpoint while managing costs?

Answer options

• A. Reduce the SQL endpoint cluster size
• B. Increase the SQL endpoint cluster size
• C. Turn off the Auto stop feature
• D. Increase the minimum scaling value
• E. Use a Serverless SQL endpoint

Correct answer: E

Explanation

The correct answer is E, as utilizing a Serverless SQL endpoint allows for on-demand execution without the need for pre-provisioning resources, which significantly reduces startup time and helps manage costs effectively. The other options either increase resource allocation or do not address the startup time issue directly, which may lead to higher costs or continued delays.