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…

Question

Options

• AThey can ensure the dashboard's SQL endpoint matches each of the queries' SQL endpoints.
• BThey can set up the dashboard's SQL endpoint to be serverless.
• CThey can turn on the Auto Stop feature for the SQL endpoint.
• DThey can reduce the cluster size of the SQL endpoint.
• EThey can ensure the dashboard's SQL endpoint is not one of the included query's SQL endpoint.

• C
  92% (24)
• D
  4% (1)
• E
  4% (1)

Explanation

The Auto Stop feature automatically shuts down a SQL endpoint (warehouse) after a configurable period of inactivity. Since the dashboard only refreshes once per day, the endpoint will be idle for most of the day. With Auto Stop enabled, the endpoint will terminate itself shortly after the daily refresh completes, minimizing the time it runs and therefore the cost. Serverless (option B) changes the billing model but does not minimize runtime. Reducing cluster size (option D) reduces cost per minute but does not reduce total runtime. Matching or not matching endpoints (options A/E) affects routing but not runtime.

No community discussion yet for this question.