Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Deep dive into the quiz with AI chat providers.
We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.
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?
Real Exam
Community
LLeetQuiz
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
Explanation:
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
Comments
Loading comments...