Databricks Certified Data Engineer Associate — Question 17

A data engineer wants to schedule their Databricks SQL dashboard to refresh once per day, but they only want the associated SQL endpoint to be running when it is necessary.
Which of the following approaches can the data engineer use to minimize the total running time of the SQL endpoint used in the refresh schedule of their dashboard?

Answer options

• A. They can ensure the dashboard’s SQL endpoint matches each of the queries’ SQL endpoints.
• B. They can set up the dashboard’s SQL endpoint to be serverless.
• C. They can turn on the Auto Stop feature for the SQL endpoint.
• D. They can reduce the cluster size of the SQL endpoint.
• E. They can ensure the dashboard’s SQL endpoint is not one of the included query’s SQL endpoint.

Correct answer: C

Explanation

The correct answer is C because enabling the Auto Stop feature allows the SQL endpoint to automatically shut down when not in use, minimizing costs and resource consumption. Option A does not necessarily reduce running time, option B may not be applicable if serverless is not supported, option D might maintain the endpoint running longer than necessary, and option E does not address the requirement of minimizing running time.