Exam Databricks-Certified-Data-Engineer-Associate Topic 2 Question 86 Discussion
Actual exam question for Databricks's Databricks-Certified-Data-Engineer-Associate exam
Question #: 86
Topic #: 2
Question #: 86
Topic #: 2
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?
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?
Suggested Answer: B Vote an answer
A serverless SQL endpoint is a compute resource that is automatically managed by Databricks and scales up or down based on the workload. A serverless SQL endpoint can be used to run queries and dashboards without requiring manual configuration or management. A serverless SQL endpoint is only active when it is needed and shuts down automatically when idle, minimizing the total running time and cost. A serverless SQL endpoint can be created and assigned to a dashboard using the Databricks SQL UI or the SQL Analytics API. Reference:
Create a serverless SQL endpoint
Assign a SQL endpoint to a dashboard
SQL Analytics API
Create a serverless SQL endpoint
Assign a SQL endpoint to a dashboard
SQL Analytics API
by Mick at Nov 11, 2024, 04:28 PM
0
0
0
10
Comments
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Report Comment
Commenting
You can sign-up / login (it's free).