Databricks-DA-Assoc Creating Dashboards and Visualizations Practice Question
A data analyst is building a Databricks SQL dashboard to track daily sales. They need to ensure that the dashboard automatically updates every hour to reflect the latest ingestion from Delta tables. Which mechanism should the analyst configure to achieve this requirement?
⚠ Common exam trap
Candidates often think dashboards update in real time automatically without configuring an explicit schedule tied to a running SQL warehouse.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Configure a schedule on the dashboard using a SQL warehouse to run at the desired frequency.
Databricks SQL dashboards include a built-in schedule feature that allows analysts to define an interval for automated refreshes. By configuring a schedule, the dashboard queries run automatically in the background, ensuring stakeholders view current data without manual intervention. This feature is vital for operational reporting where timeliness is critical for business decision-making and performance monitoring across the organization.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Enable the 'Auto-refresh' toggle within the browser settings of the dashboard viewer.
Why it's wrong here
Browser settings do not manage backend compute resources or SQL query execution schedules. Relying on client-side refresh settings is unreliable, as the dashboard session may expire or the tab may enter a sleep state, failing to trigger the necessary SQL warehouse execution to fetch updated data.
- ✗
Configure a SQL warehouse to 'Auto-stop' every hour to trigger a metadata update.
Why it's wrong here
Auto-stop settings are designed for cost management by shutting down idle resources, not for triggering data refreshes. Stopping and starting a warehouse does not inherently execute queries or refresh dashboard visualizations; it only manages the lifecycle and billing state of the compute cluster itself.
- ✓
Configure a schedule on the dashboard using a SQL warehouse to run at the desired frequency.
Why this is correct
Scheduling is the native Databricks feature that allows dashboards to run queries at defined intervals. This approach ensures that the SQL warehouse executes the underlying queries, updates the cache, and refreshes the visualizations, providing consistent and automated data delivery to users without requiring manual refreshes or browser activity.
- ✗
Create a Job in the Workflows UI that explicitly opens the dashboard URL every hour.
Why it's wrong here
Workflows are designed to orchestrate data pipelines and tasks, not to interact with web interfaces or simulate user browser sessions. Creating a job to open a URL does not execute SQL queries or refresh dashboard widgets, making it an ineffective and unsupported method for updating dashboard data.
About these practice questions
One of 291 original Databricks-DA-Assoc practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Databricks exam blueprint
This Databricks-DA-Assoc practice question is part of Courseiva's free Databricks certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the Databricks-DA-Assoc exam.