
Ultimate access to all questions.
An engineering manager is overseeing the performance of a newly released project and is interested in monitoring it using a Databricks SQL query. The manager requests that for the first week post-release, the query results should be refreshed every minute. Nevertheless, there is a concern that continuous compute resource usage beyond the initial one-week period could incur significant costs to the organization. Which of the following strategies can the engineering team implement to ensure that the query only runs and incurs costs for the first week following the release, thereby preventing unnecessary expenses thereafter?
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 any 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.