Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
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
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...