Home / Data Analyst practice test / Working with Dashboards and Visualizations in Databricks / Question

Databricks Data Analyst Associate · free practice question

A data analyst is monitoring daily active users across a 12-month period and wants to display the overall trend, including seasonal spikes, as clearly as…

Exam-style question on Working with Dashboards and Visualizations in Databricks from the free Data Analyst practice test, with the answer and a full explanation below.

Updated November 10, 2026

Working with Dashboards and Visualizations in Databricks

A data analyst is monitoring daily active users across a 12-month period and wants to display the overall trend, including seasonal spikes, as clearly as possible. Which visualization type is most effective for this use case?

  1. AA pie chart that partitions the 12-month total active users into proportional slices by month, making the relative contribution of each month visually apparent at a single glance
  2. BA scatter plot that plots each day's active user count as an individual data point on a two-axis chart, enabling the viewer to explore correlation between elapsed time and user activity volume
  3. CA line chart that connects data points along a continuous time axis, making the overall direction, rate of change, and seasonal spikes in daily active users easy to identify
  4. DA grouped bar chart that renders one bar per month with its height representing the total active users, allowing viewers to compare monthly magnitudes side-by-side without a connected trend line
  5. EA heat map that represents user activity intensity as a color gradient on a two-dimensional grid of days and hours, optimized for identifying recurring intra-week or intra-day cyclical patterns
Answer & explanation

Correct answer: C

WHY C: A line chart is the most effective visualization for showing trends over time. It connects chronological data points into a continuous line, making it easy to see the overall direction, rate of change, and seasonal spikes in daily active users across the full 12-month period. WHY NOT A: A pie chart shows proportions of a whole at a single point in time and cannot effectively display trends, direction of change, or seasonal spikes across a continuous 12-month timeline. WHY NOT B: A scatter plot shows correlation or distribution between two numeric variables. While it can plot time-series points, it does not connect them to show trend direction, making seasonal spikes harder to identify than with a line chart. WHY NOT D: A grouped or stacked bar chart can compare monthly totals in magnitude, but it does not emphasize the continuous trend direction or seasonal spike patterns as clearly as a line chart does for time-series data. WHY NOT E: A heat map is useful for identifying recurring cyclical patterns (e.g., day-of-week × hour-of-day), but it is not the most effective choice for visualizing an overall 12-month directional trend with highlighted seasonal spikes.

Take the full Data Analyst practice test free →

Would you pass today?

This question is one of 45 in the free, timed Databricks Data Analyst Associate practice test. Take it and get a section-by-section score.

Start the free test →