Ultimate access to all questions.
Explanation:
In Databricks SQL, queries can be scheduled to refresh automatically from the query’s page. This feature ensures that the results are updated at a chosen frequency (e.g., daily), without requiring the user to manually rerun the query.
Let’s break down the options:
A: Schedule from Jobs UI (every 1 day)
Jobs UI is typically used for workflows, notebooks, or pipelines—not for refreshing SQL queries directly. This is not the most appropriate solution.
B: Schedule the query to refresh every 1 day from the query’s page in Databricks SQL This is the correct approach. Databricks SQL allows you to set a refresh schedule directly on the query’s page, ensuring results are updated daily.
C: Schedule the query to run every 12 hours from the Jobs UI
Same issue as option A—Jobs UI is not the right place for SQL query refresh scheduling.
D: Schedule the query to refresh every 1 day from the SQL endpoint’s page
SQL endpoints manage compute resources, not query refresh schedules. Incorrect.
E: Schedule the query to refresh every 12 hours from the SQL endpoint’s page
Same as D—endpoints don’t handle query refresh scheduling.
B: They can schedule the query to refresh every 1 day from the query’s page in Databricks SQL.
Question 41
An engineering manager uses a Databricks SQL query to monitor their team's progress on fixes related to customer-reported bugs. 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?
A
They can schedule the query to run every 1 day from the Jobs UI.
B
They can schedule the query to refresh every 1 day from the query’s page in Databricks SQL.
C
They can schedule the query to run every 12 hours from the Jobs UI.
D
They can schedule the query to refresh every 1 day from the SQL endpoint’s page in Databricks SQL.
E
They can schedule the query to refresh every 12 hours from the SQL endpoint’s page in Databricks SQL.