Databricks-DA-Assoc Creating Dashboards and Visualizations Practice Question
A dashboard author wants viewers to click a bar in a Databricks SQL chart and have the dashboard display a second chart filtered to that bar's category. Which feature should the author configure to achieve this interactive behavior?
⚠ Common exam trap
A common mix-up: candidates confuse data-refresh scheduling with interactivity, when only selection-driven dashboard filtering reacts to a viewer clicking a chart element.
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
✓
Dashboard cross-filtering or a dashboard-level filter driven by the selected value
Interactive cross-chart behavior comes from dashboard filtering driven by a selected value, so clicking a bar's category updates the other chart. Scheduled refresh only reloads data, a parameter default is static, and separate per-category queries create static charts, none of which respond to a viewer's selection.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
A scheduled refresh on the dashboard so the second chart reloads on an interval
Why it's wrong here
Scheduled refresh controls how often a dashboard re-executes its queries to pick up new data; it has nothing to do with viewer clicks. It would not filter the second chart based on a selected bar. This feature addresses data freshness, not interactive cross-chart filtering, so it does not meet the requirement.
- ✗
A separate query per category added as individual visualizations to the dashboard
Why it's wrong here
Creating one visualization per category produces many static charts and does not respond to viewer clicks on a bar. It also bloats the dashboard and does not create a linked interactive experience. This approach misunderstands the requirement, which is dynamic filtering driven by selection rather than pre-built per-category charts.
- ✓
Dashboard cross-filtering or a dashboard-level filter driven by the selected value
Why this is correct
Databricks SQL dashboards support interactive filtering where selecting a value in one visualization, such as a bar's category, can drive a dashboard filter that updates other visualizations. Configuring this cross-filter or selection-driven filter lets viewers drill into a category and see the second chart update accordingly, matching the requested behavior.
- ✗
A parameter default value set to a specific category in the second chart's query
Why it's wrong here
Setting a parameter default fixes the value used before any viewer interaction; it does not respond to clicking a bar. The second chart would always start with that default rather than the selected category. This static configuration cannot deliver the dynamic cross-chart filtering the scenario requires.
About these practice questions
Courseiva writes every Databricks-DA-Assoc question from scratch — 291 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. 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.