An engineering manager uses a Databricks SQL query to monitor ingestion latency for each data source. The manager checks the results of the query every day, but they are manually rerunning the query each day and waiting for the results.
Which of the following approaches can the manager use to ensure the results of the query are updated each day?
The manager can schedule the query to refresh every 1 day from the query's page in Databricks SQL. This approach ensures that the query results are updated daily without the need for manual intervention. The scheduling functionality in the query's page allows the user to specify the frequency and timing for automatic query execution, making it a suitable solution for the requirement.
The manager can schedule the query to refresh every 1 day from the query’s page in Databricks SQL (Option C). Here are the steps to do this: - In the Query Editor, click Schedule > Add schedule to open a menu with schedule settings. - Choose when to run the query. Use the dropdown pickers to specify the frequency, period, starting time, and time zone. - Click Create.
From the query editor page we have option to schedule the queries
Ans D : think option A might not be right since we are not doing scheduling in sql end points page
it is C, Question 41 of Practice Exam Databricks
Correct Answer is C
has to be every 1 day to run once day. https://docs.databricks.com/en/sql/user/queries/schedule-query.html