Certified Data Engineer Associate Exam

Exam Certified Data Engineer Associate All QuestionsBrowse all questions from this exam

Question 40

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?

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

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

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

They can reduce the cluster size of the SQL endpoint.

They can ensure the dashboard’s SQL endpoint is not one of the included query’s SQL endpoint.

Correct Answer: C

Turning on the Auto Stop feature for the SQL endpoint allows for automatic termination of the endpoint when it is idle. This minimizes the total running time of the SQL endpoint, ensuring it runs only when necessary and reducing associated costs.

Discussion

4be8126Option: C

The data engineer can use the Auto Stop feature to minimize the total running time of the SQL endpoint used in the refresh schedule of their dashboard. The Auto Stop feature allows the SQL endpoint to automatically shut down when there are no active connections, which will minimize the total running time of the SQL endpoint. By scheduling the dashboard to refresh once per day, the SQL endpoint will only be running for a short period of time each day, which will minimize the total running time and reduce costs.

XiltroXOption: C

Correct answer

vctrhugoOption: C

C. They can turn on the Auto Stop feature for the SQL endpoint. To minimize the total running time of the SQL endpoint used in the refresh schedule of their dashboard while ensuring that it only runs when necessary, the data engineer can turn on the Auto Stop feature for the SQL endpoint. This feature will automatically stop the SQL endpoint when it is idle for a specified period, reducing costs by avoiding unnecessary running time. Option C allows you to efficiently manage the SQL endpoint's lifecycle, ensuring it's active only when needed, which aligns with the goal of minimizing running time and associated costs. Option B (setting the dashboard's SQL endpoint to be serverless) can also be a valid approach, as it allows the SQL endpoint to be provisioned on-demand and incurs costs only when queries are executed. However, it depends on the specific requirements of your dashboard and queries. Options A, D, and E do not directly address the goal of minimizing the SQL endpoint's running time while ensuring it runs when necessary.

AtnafuOption: C

C The Auto Stop feature automatically terminates the compute resources (cluster) associated with the SQL endpoint after a specified period of inactivity. By enabling this feature, the SQL endpoint will be automatically stopped when it is no longer needed, reducing the total running time and associated costs.

SerGreyOption: C

C is correct

mokraniOption: B

Why it can't be B ? . They can set up the dashboard’s SQL endpoint to be serverless. ? they can use a serverless endpoint and it will only be active when required.

awofalusOption: C

correct : C

vikas555Option: C

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

ArindamNathOption: C

C is correct.

AndreFROption: C

https://docs.databricks.com/en/clusters/clusters-manage.html#automatic-termination