Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all 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 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?
Real Exam
Community
KKeng
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 reduce the cluster size of the SQL endpoint.
E
They can ensure the dashboard's SQL endpoint is not one of the included query's SQL endpoints.
Explanation:
The correct answer is C - They can turn on the Auto Stop feature for the SQL endpoint.
Explanation:
In Databricks SQL, the Auto Stop feature automatically stops SQL endpoints after a period of inactivity. This is the most direct approach to minimize the total running time of a SQL endpoint when it's only needed for scheduled dashboard refreshes.
Why other options are incorrect:
- A: Ensuring the dashboard's SQL endpoint matches each query's SQL endpoints doesn't reduce running time - it just ensures consistency but doesn't control when the endpoint runs.
- B: Serverless SQL endpoints are always available and don't help minimize running time for infrequent refreshes.
- D: Reducing cluster size affects performance and cost per hour, but doesn't reduce the total time the endpoint is running.
- E: Ensuring the dashboard's SQL endpoint is not one of the included query's SQL endpoints would actually increase complexity and potentially increase running time if multiple endpoints need to run.
Key Concept: The Auto Stop feature is specifically designed to optimize costs by automatically stopping SQL endpoints when they're not in use, making it ideal for scheduled dashboard refreshes that only need the endpoint to be active during the refresh period.
Comments
Loading comments...