Which of the following approaches can the engineering team use to ensure the query does not cost the organization any money beyond the first week of the project’s release?

An engineering manager wants to monitor the performance of a recent project using a Databricks SQL query. For the first week following the project’s release, the manager wants the query results to be updated every minute. However, the manager is concerned that the compute resources used for the query will be left running and cost the organization a lot of money beyond the first week of the project’s release.

Which of the following approaches can the engineering team use to ensure the query does not cost the organization any money beyond the first week of the project’s release?
A . They can set a limit to the number of DBUs that are consumed by the SQL Endpoint.
B . They can set the query’s refresh schedule to end after a certain number of refreshes.
C . They cannot ensure the query does not cost the organization money beyond the first week of the project’s release.
D . They can set a limit to the number of individuals that are able to manage the query’s refresh schedule.
E . They can set the query’s refresh schedule to end on a certain date in the query scheduler.

View Answer

Answer: E

Explanation:

In Databricks SQL, you can use scheduled query executions to update your dashboards or enable routine alerts. By default, your queries do not have a schedule. To set the schedule, you can use the dropdown pickers to specify the frequency, period, starting time, and time zone. You can also choose to end the schedule on a certain date by selecting the End date checkbox and picking a date from the calendar. This way, you can ensure that the query does not run beyond the first week of the project’s release and does not incur any additional cost. Option A is incorrect, as setting a limit to the number of DBUs does not stop the query from running. Option B is incorrect, as there is no option to end the schedule after a certain number of refreshes. Option C is incorrect, as there is a way to ensure the query does not cost the organization money beyond the first week of the project’s release. Option D is incorrect, as setting a limit to the number of individuals who can manage the query’s refresh schedule does not affect the query’s execution or cost.

Reference: Schedule a query, Schedule a query – Azure Databricks – Databricks SQL