Exam Certified Data Engineer Associate topic 1 question 132 discussion

Actual exam question from Databricks's Certified Data Engineer Associate

Question #: 132
Topic #: 1

[All Certified Data Engineer Associate Questions]

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?

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.

Show Suggested Answer

Suggested Answer: C 🗳️

by 9d4d68a at Aug. 26, 2024, 8:07 p.m.

Comments

Submit Cancel

MultiCloudIronMan

1 month, 3 weeks ago

Selected Answer: C

The correct answer is C. They can turn on the Auto Stop feature for the SQL endpoint. This feature ensures that the SQL endpoint automatically stops when it is not in use, minimizing the total running time and reducing costs.

upvoted 1 times

...

Exam Certified Data Engineer Associate All Questions

View all questions & answers for the Certified Data Engineer Associate exam

Exam Certified Data Engineer Associate topic 1 question 132 discussion

Comments

MultiCloudIronMan

SY0-701