Databricks-DA-Assoc Creating Dashboards and Visualizations Practice Question
A data analyst is building a dashboard in Databricks SQL that includes a visualization showing sales by product category. The analyst wants to ensure that the dashboard is interactive and allows viewers to filter the data by date range and product category. Which TWO of the following actions should the analyst take to enable this interactivity? (Choose two.)
⚠ Common exam trap
The trap here is thinking that creating multiple static visualizations or using fixed filters achieves interactivity, when in fact parameters are required.
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
✓
Add a date range parameter to the dashboard and reference it in the query's WHERE clause.
To enable interactive filtering by date range and product category, the analyst should use parameters. A date range parameter and a dropdown list parameter for product category, both referenced in the query, allow viewers to dynamically filter the data. This is the standard and most efficient method in Databricks SQL dashboards.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Embed the dashboard in an iframe and use JavaScript to pass filter values.
Why it's wrong here
Embedding the dashboard in an iframe and using JavaScript to pass filter values is not a native Databricks SQL feature for dashboard interactivity. While embedding is possible, it does not provide the built-in parameter and filter mechanisms that Databricks SQL offers. This approach is overly complex and not the recommended way to enable interactivity.
- ✓
Add a date range parameter to the dashboard and reference it in the query's WHERE clause.
Why this is correct
Adding a date range parameter and referencing it in the query's WHERE clause allows viewers to select a date range that dynamically filters the data. This is a standard method to enable interactivity in Databricks SQL dashboards. The parameter must be added to the dashboard so viewers can adjust it, and the query must use it to filter results.
- ✓
Add a dropdown list parameter for product category and use it in the query to filter the data.
Why this is correct
A dropdown list parameter for product category enables viewers to select one or more categories, and referencing it in the query filters the visualization accordingly. This provides the desired interactivity for category filtering. The parameter should be added to the dashboard and used in the query's WHERE clause to restrict the data.
- ✗
Use a dashboard-level filter that applies to all visualizations and set it to a fixed date range.
Why it's wrong here
A dashboard-level filter can filter data, but setting it to a fixed date range removes interactivity. Viewers would not be able to change the date range. The requirement is for interactive filtering, so a fixed value is inappropriate. Filters can be used, but they must be dynamic and not fixed.
- ✗
Create a separate visualization for each product category and add them all to the dashboard.
Why it's wrong here
Creating separate visualizations for each category does not provide interactive filtering; it simply displays multiple static views. Viewers cannot dynamically filter the data themselves. This approach also clutters the dashboard and does not leverage parameterization, which is the intended method for interactivity in Databricks SQL.
About these practice questions
This Databricks-DA-Assoc question is part of Courseiva's 291-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam 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.