
Answer-first summary for fast verification
Answer: They can set the query’s refresh schedule to end on a certain date in the query scheduler.
The correct answer is E. Databricks offers a Query Scheduler that allows users to schedule the execution of SQL queries at specific intervals or for specific durations. By configuring the query's refresh schedule to conclude or end on a certain date within the first week of the project's release, the query will automatically stop refreshing after that date. This action ensures that compute resources aren't continuously utilized beyond the specified timeframe, preventing unnecessary costs.
Author: LeetQuiz Editorial Team
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.
No comments yet.