Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

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

Actual exam question for Databricks's Databricks Certified Data Engineer Associate Exam exam
Question #: 36
Topic #: 2
[All Databricks Certified Data Engineer Associate Exam 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?

Show Suggested Answer Hide 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 Cecil at Sep 13, 2024, 11:28 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
Honey
1 days ago
Serverless, huh? Sounds like something straight out of a sci-fi movie. Next thing you know, they'll be running the dashboard on a quantum computer or something.
upvoted 0 times
...
Asuncion
22 days ago
Matching the SQL endpoints to the queries? Hmm, I don't know, that sounds like a lot of work. I'd rather just go with the Auto Stop option and let the system handle it.
upvoted 0 times
...
Luisa
23 days ago
That's a good point, Giovanna. Option C does sound like a good solution as well. It's all about optimizing the process.
upvoted 0 times
...
Glenn
24 days ago
Serverless is the way to go! No need to worry about cluster size or anything, it'll just scale up and down as needed.
upvoted 0 times
...
Giovanna
25 days ago
I disagree, I believe option C is more efficient. Setting up the SQL endpoint to be serverless will also help minimize running time.
upvoted 0 times
...
Joanna
25 days ago
The Auto Stop feature sounds like a great way to minimize the running time of the SQL endpoint. That way, it won't be wasting resources when it's not needed.
upvoted 0 times
Florinda
4 days ago
B) They can turn on the Auto Stop feature for the SQL endpoint.
upvoted 0 times
...
...
Luisa
1 months ago
I think option B is the best choice. Turning on Auto Stop feature will only run the SQL endpoint when needed, reducing total running time.
upvoted 0 times
...

Save Cancel