Databricks Certified Data Engineer Associate — Question 32

A data engineer wants to schedule their Databricks SQL dashboard to refresh every hour, but they only want the associated SQL endpoint to be running when it is necessary. The dashboard has multiple queries on multiple datasets associated with it. The data that feeds the dashboard is automatically processed using a Databricks Job.

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 turn on the Auto Stop feature for the SQL endpoint.
• B. They can ensure the dashboard's SQL endpoint is not one of the included query's SQL endpoint.
• C. They can reduce the cluster size of the SQL endpoint.
• D. They can ensure the dashboard's SQL endpoint matches each of the queries' SQL endpoints.
• E. They can set up the dashboard's SQL endpoint to be serverless.

Correct answer: A

Explanation

The correct option A is right because enabling the Auto Stop feature allows the SQL endpoint to automatically shut down when not in use, thus minimizing running time. The other options either do not address the running time effectively or may lead to issues with query execution and endpoint management.