Databricks-DA-Assoc Executing Queries with Databricks SQL Practice Question
A data analyst is building a Databricks SQL dashboard that includes a parameter for the region. The dashboard should allow viewers to select a region from a dropdown list that is populated dynamically from the distinct values in the sales table's region column. Which feature should the analyst use to implement this?
⚠ Common exam trap
Test-takers frequently confuse a filter widget with a parameter; filter widgets are for filtering visualizations, while parameters are reusable variables that can be used across queries and visualizations.
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
✓
Create a query-based dropdown parameter that runs a SELECT DISTINCT region FROM sales query to populate the list.
Databricks SQL dashboards support query-based parameters, which dynamically populate a dropdown from a SQL query. This ensures the list of regions is always up to date. Static lists or text inputs do not provide dynamic population from the data, and filter widgets are not parameters.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Add a filter widget on the dashboard that uses a SELECT DISTINCT query, and link it to the visualizations.
Why it's wrong here
While filter widgets can be based on queries, the specific feature for a parameter that populates a dropdown is a query-based parameter. A filter widget is applied to a single visualization or the dashboard, but it does not define a reusable parameter for multiple queries. The question asks for a parameter, not a filter.
- ✗
Implement a text input parameter and instruct users to type the region name.
Why it's wrong here
A text input allows free-form entry, which can lead to typos and inconsistent values. It does not provide a dropdown list of valid options. The requirement is for a dropdown populated from data, so a text input does not meet the need.
- ✗
Use a static dropdown parameter and manually enter all possible region values.
Why it's wrong here
A static dropdown requires manual entry and maintenance, which is error-prone and not dynamic. If new regions are added, the dashboard would not reflect them until updated. The requirement is for dynamic population, so a static list is unsuitable.
- ✓
Create a query-based dropdown parameter that runs a SELECT DISTINCT region FROM sales query to populate the list.
Why this is correct
Databricks SQL dashboards support query-based parameters, where the list of values is generated by a query. This allows dynamic population from the distinct values in a column. The analyst can configure the parameter to use a query, ensuring the dropdown reflects current data without manual updates.
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.