Databricks Certified Data Analyst Associate — Question 56

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?

Answer options

• A. The Date widget parameter provides a start date and an end date that is used by a WHERE clause in the query that provides data to the bar chart.
• B. The Date widget parameter provides a start date and an end date that sets the x-axis range of the bar chart.
• C. The Date widget parameter provides a start date and an end date that filters all visualizations in the dashboard.
• D. The Date widget parameter functions only as a text box that tells the dashboard's users what date range the dashboard is using.

Correct answer: A

Explanation

The correct answer is A because the Date widget parameter is specifically used to determine the date range for the data being queried, which is reflected in the WHERE clause. Option B is incorrect as the x-axis range is not solely determined by the Date widget. Option C misrepresents the scope of filtering as it only applies to the bar chart's data. Option D is also incorrect because the Date widget is functional and not just for display purposes.