Databricks Certified Data Engineer Associate — Question 23

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?

Answer options

• 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.

Correct answer: E

Explanation

The correct answer is E, as it allows the team to specify an end date for the query's refresh schedule, ensuring no costs are incurred after the first week. Option A does not directly address the duration of the query execution, while B limits refreshes but could still lead to costs after the specified number. Option C incorrectly states that no measures can be taken to avoid costs, and D does not affect the query's execution timeframe.