Databricks-DA-Assoc Creating Dashboards and Visualizations Practice Question
A data analyst is building a Databricks SQL dashboard that includes a line chart of daily active users over the past year. The stakeholder wants to hover over the line to see the exact date and user count for each point. The analyst notices that the tooltip currently shows only the user count and not the date. What should the analyst do to include the date in the tooltip?
⚠ Common exam trap
The trap here is assuming a dashboard-wide setting can inject all query columns into tooltips, when tooltip content is governed by the visualization's field encodings.
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 the date column to the visualization's tooltip encoding or ensure it is included as a field in the chart's data so the hover tooltip can display it.
Tooltips reflect the fields encoded in the visualization. If the date is used only for the x-axis and not exposed to the tooltip, hovering shows only the measure. Including the date in the tooltip encoding or ensuring it is part of the chart's fields makes the hover display both the date and the user count, preserving the line chart while meeting the stakeholder's requirement.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Enable the dashboard-level option to show all fields in tooltips, which automatically includes every column returned by the query.
Why it's wrong here
Databricks SQL visualizations do not have a global dashboard setting that automatically injects every query column into tooltips. Tooltip content is determined by the visualization's encodings and the fields included in the chart. Relying on such an option would not reliably add the date, so the analyst should explicitly include the date in the tooltip or chart fields instead.
- ✗
Modify the query to concatenate the date and user count into a single string column and use that as the measure in the line chart.
Why it's wrong here
Concatenating the date and user count into a string would break the numeric measure needed for the line chart's y-axis, since the chart requires a numeric field to plot the line. It would also prevent proper aggregation and trend rendering. The tooltip issue is better solved by exposing the date field to the tooltip rather than altering the measure's data type and content.
- ✗
Change the visualization type from line chart to a table so that all columns, including the date, are visible without hovering.
Why it's wrong here
Switching to a table would show the date and user count as rows, but it would remove the line chart the stakeholder wants and eliminate the hover interaction entirely. The requirement is to keep the trend line and enhance the tooltip, not to replace the visualization. A table also makes it harder to perceive the daily trend over a year at a glance, so this does not meet the stated need.
- ✓
Add the date column to the visualization's tooltip encoding or ensure it is included as a field in the chart's data so the hover tooltip can display it.
Why this is correct
Tooltips in Databricks SQL visualizations display fields that are included in the chart's encoding or data. If the date is only used as the x-axis but not exposed to the tooltip, the hover may show only the measure. Adding the date to the tooltip encoding or ensuring it is part of the chart's fields lets the tooltip render both the date and the user count as the stakeholder requested.
About these practice questions
Courseiva writes every Databricks-DA-Assoc question from scratch — 291 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or 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.