Databricks Exam Databricks-Certified-Data-Engineer-Associate Topic 1 Question 7 Discussion

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

Question #: 7
Topic #: 1

[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 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?

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

BThey can ensure the dashboard's SQL endpoint is not one of the included query's SQL endpoint.

CThey can reduce the cluster size of the SQL endpoint.

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

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

Show Suggested Answer

Suggested Answer: C

by Elvera at Apr 20, 2023, 12:25 PM

Limited Time Offer

25%

18 days ago

I think option A is the best choice. Auto Stop feature can help minimize running time.

upvoted 0 times

...