Databricks-DA-Assoc Creating Dashboards and Visualizations Practice Question
A data analyst is building a Databricks SQL dashboard that tracks daily active users across four global regions. The dashboard has a single dataset query, and the analyst wants the region filter to apply to all visualizations on the dashboard without editing each widget's query. Which dashboard feature should the analyst configure?
⚠ Common exam trap
It's easy for candidates to confuse a dashboard parameter, which is an interactive control shared across widgets, with table-level row filters or refresh schedules that have nothing to do with user-driven filtering.
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
✓
A dashboard-level parameter with the keyword {{region}} applied in the dataset query.
Dashboards in Databricks SQL let analysts define parameters that can be referenced in dataset queries with the {{name}} syntax. A dashboard-level parameter appears as a control for viewers and, because multiple visualizations can share one dataset, changing the parameter re-runs the dataset and updates every widget bound to it. This satisfies the requirement of a single region filter driving all visualizations without editing each widget's SQL.
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 Unity Catalog row filter function attached to the underlying table.
Why it's wrong here
Row filter functions in Unity Catalog enforce row-level security based on the identity of the querying user; they are not interactive dashboard controls. They cannot be changed by an analyst clicking a dropdown on a dashboard, and they apply uniformly to all queries against the table rather than acting as an ad hoc filter. Using them here would not give viewers the ability to switch regions on the fly.
- ✗
A separate query snippet embedded in each visualization's SQL that hardcodes the region list.
Why it's wrong here
Hardcoding a region list inside each visualization's SQL does not create a shared control and cannot be changed at runtime by a dashboard viewer. It also duplicates logic across widgets, so a new region requires editing every visualization individually. This approach fails the requirement that a single control drive filtering for all visualizations on the dashboard, and it does not leverage the platform's shared parameter mechanism.
- ✓
A dashboard-level parameter with the keyword {{region}} applied in the dataset query.
Why this is correct
Databricks SQL dashboards support parameters that can be bound to a dataset query using the {{parameter_name}} syntax. A dashboard-level parameter created from the dashboard UI is shared across all visualizations that reference the same dataset, so changing its value re-executes the dataset and updates every widget that depends on it. This is the intended mechanism for cross-widget filtering without duplicating filter logic in each visualization.
- ✗
A scheduled refresh on the dashboard set to run every five minutes.
Why it's wrong here
A refresh schedule controls when the dashboard's cached results are recomputed; it has no effect on filtering behavior or on which regions appear in a visualization. Scheduling more frequent refreshes would simply re-run the same query with the same static filter values. It does not provide an interactive control that propagates a region selection to every widget on the dashboard.
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.