Databricks Certified Data Engineer Associate — Question 74

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 approach 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 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 will automatically shut down the SQL endpoint when it is not in use, thus minimizing its running time. Options A and D do not address the need to reduce runtime effectively, and option B, while useful, does not guarantee the SQL endpoint will stop when not in use.