Databricks Certified Data Engineer Associate Exam - Topic 2 Question 60 Discussion

Actual exam question for Databricks's Databricks Certified Data Engineer Associate exam

Question #: 60
Topic #: 2

[All Databricks Certified Data Engineer Associate Questions]

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 approach can the data engineer use to minimize the total running time of the SQL endpoint used in the refresh schedule of their dashboard?

AO They can reduce the cluster size of the SQL endpoint.

BQ They can turn on the Auto Stop feature for the SQL endpoint.

CO They can set up the dashboard's SQL endpoint to be serverless.

D0 They can ensure the dashboard's SQL endpoint matches each of the queries' SQL endpoints.

Show Suggested Answer

Suggested Answer: B

To minimize the total running time of the SQL endpoint used in the refresh schedule of a dashboard in Databricks, the most effective approach is to utilize the Auto Stop feature. This feature allows the SQL endpoint to automatically stop after a period of inactivity, ensuring that it only runs when necessary, such as during the dashboard refresh or when actively queried. This minimizes resource usage and associated costs by ensuring the SQL endpoint is not running idle outside of these operations.

Reference: Databricks documentation on SQL endpoints: SQL Endpoints in Databricks

by Rosalind at Mar 08, 2026, 05:33 AM

Limited Time Offer

25%

Off

Get Premium Databricks Certified Data Engineer Associate Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Olga

2 days ago

I practiced a similar question where reducing cluster size was mentioned, but I feel like that might not be the best choice for performance.

upvoted 0 times

...

Bernardo

7 days ago

I think serverless SQL endpoints could be a good option since they scale automatically, but I’m not completely confident about how they work with scheduled refreshes.

upvoted 0 times

...

Isaiah

12 days ago

I remember something about the Auto Stop feature being useful for saving costs, but I'm not sure if it actually minimizes running time.

upvoted 0 times

...