Answer-first summary for fast verification
Answer: Create a dashboard widget with the query and refresh it daily
**Correct Answer: B — They can schedule the query to refresh every 1 day from the query’s page in Databricks SQL.** **Why B is Correct:** - In Databricks SQL, you can **schedule individual queries** to refresh automatically - This is done from the **query's page** (not Jobs UI or SQL endpoint settings) - "Refresh every 1 day" matches the daily update requirement - Results are automatically updated without manual reruns **Why A and C are Incorrect:** - **Jobs UI** is for scheduling notebooks/jobs, not SQL queries for dashboard purposes - Would require additional setup and doesn't directly update the query results page **Why D and E are Incorrect:** - **SQL endpoint page** controls warehouse configuration (auto-stop, scaling) - Cannot schedule query refreshes from the endpoint settings - Endpoint settings manage compute resources, not query scheduling **Why This Solution Works:** - Automates the daily refresh the manager needs - Keeps results current without manual intervention - Maintains the query in Databricks SQL where the manager already works
Author: LeetQuiz .
Ultimate access to all questions.
No comments yet.
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
Schedule the query to run daily and send the results to the manager via email
B
Create a dashboard widget with the query and refresh it daily
C
Set up a Databricks Workflow to run the query daily and store the results in a table
D
Use a Databricks Notebook to run the query and schedule it with a job
E
Configure the query to automatically refresh when the manager opens the SQL editor
F
Create a materialized view that updates automatically when underlying data changes