In a Databricks dashboard, how do you add a parameter widget that controls a query input?

Use the 'Schedule' button to set parameter values

Edit the SQL query to include a hardcoded value

Write a Python script in the dashboard

Click 'Add widget' in the dashboard editor and select 'Text' or 'Dropdown'

A data analyst is testing a dashboard with a parameter `{{ status }}`. The widget is a dropdown with values 'Active', 'Inactive', 'Pending'. The analyst selects 'Active' and the query returns 100 rows. Then they select 'Inactive' and the query returns 50 rows. What does this confirm?

The parameter is working correctly and the query is dynamic.

The widget is not connected to the query.

The dashboard is in 'Edit' mode.

The query is hard-coded to return a fixed number of rows.

A logistics company has a dashboard showing delivery performance. The dashboard has a parameter `{{ delivery_zone }}`. The analyst wants to add a widget that allows users to select multiple zones at once. What widget type should be used?

Dropdown with 'Multi-select' enabled

DatabricksCertified Data Analyst Associate

Domain 6Objective 3

Work with Parameters in SQL Queries and Dashboards, Including Defining, Configuring, and Testing Parameters. DATA-ANALYST-ASSOCIATE Practice Questions (Page 4)

Part of the Section 6: Working with Dashboards and Visualizations in Databricks domain, which makes up ~17% of our current practice bank. Databricks does not publish an official question count, but from its 90-minute exam (~35–60 total, ~6–10 in this domain), expect 1–1 from this objective — we provide 18 practice questions to prepare you well beyond it. (estimate)

18questions here

4free pages

3concepts

Questions 16–18

16foundation · easy
In a Databricks dashboard, how do you add a parameter widget that controls a query input?
Select an answer first
17application · easy
A data analyst is testing a dashboard with a parameter `{{ status }}`. The widget is a dropdown with values 'Active', 'Inactive', 'Pending'. The analyst selects 'Active' and the query returns 100 rows. Then they select 'Inactive' and the query returns 50 rows. What does this confirm?
Select an answer first
18application · medium
A logistics company has a dashboard showing delivery performance. The dashboard has a parameter `{{ delivery_zone }}`. The analyst wants to add a widget that allows users to select multiple zones at once. What widget type should be used?
Select an answer first

Finished these 3 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack to DATA-ANALYST-ASSOCIATE

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Databricks. “DATA-ANALYST-ASSOCIATE” is a trademark of its owner, used for identification only.

Work with Parameters in SQL Queries and Dashboards, Including Defining, Configuring, and Testing Parameters. DATA-ANALYST-ASSOCIATE Practice Questions (Page 4)

Questions 16–18

In a Databricks dashboard, how do you add a parameter widget that controls a query input?

A data analyst is testing a dashboard with a parameter `{{ status }}`. The widget is a dropdown with values 'Active', 'Inactive', 'Pending'. The analyst selects 'Active' and the query returns 100 rows. Then they select 'Inactive' and the query returns 50 rows. What does this confirm?

A logistics company has a dashboard showing delivery performance. The dashboard has a parameter `{{ delivery_zone }}`. The analyst wants to add a widget that allows users to select multiple zones at once. What widget type should be used?

Keep studying — Section 6: Working with Dashboards and Visualizations in Databricks