CERTIFIED-DATA-ANALYST-ASSOCIATE Question #86: Real Exam Question with Answer & Explanation

Question

A dashboard contains a bar chart visualization. The bar chart has a Date widget parameter associated with it. Which statement about the Date widget parameter is true?

Options

• AThe Date widget parameter provides a start date and an end date that is used by a WHERE
• BThe Date widget parameter provides a start date and an end date that sets the x-axis range of the
• CThe Date widget parameter provides a start date and an end date that filters all visualizations in
• DThe Date widget parameter functions only as a text box that tells the dashboard's users what date

Explanation

Option A is correct because a Date widget parameter in dashboard tools (like Databricks SQL or similar BI platforms) functions as a query filter - it passes the selected start and end dates into a SQL WHERE clause, which controls what data is fetched and displayed in the visualization.

Why the distractors are wrong:

• B is wrong because the Date widget doesn't manipulate the chart's visual x-axis range; it filters the underlying data via SQL, not the rendering layer.
• C is wrong because a parameter associated with a specific visualization typically filters only that visualization's query, not all visualizations on the dashboard (that would require a dashboard-level filter widget).
• D is wrong because widget parameters are functional, not decorative - they actively pass values into queries rather than serving as static labels.

Memory tip: Think of the Date widget as a SQL variable injector - its job is to slot date values into your query's WHERE clause, just like a parameter in a prepared statement. If it ends up in the query, it's a filter (A), not a chart setting or a label.

No community discussion yet for this question.