Databricks Certified Data Engineer Associate — Question 73

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 approach 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 can set the query’s refresh schedule to end on a certain date in the query scheduler.
• D. They can set a limit to the number of individuals that are able to manage the query’s refresh schedule.

Correct answer: C

Explanation

The correct answer is C because setting a specific end date for the query's refresh schedule ensures that it will cease operation automatically after the first week, preventing unnecessary costs. Options A and D do not directly address the timing of the refresh, while option B limits refreshes but does not guarantee a stop after the desired week.