Databricks-DA-Assoc Creating Dashboards and Visualizations Practice Question
An analyst is creating a dashboard in Databricks SQL and wants to display the number of active users per day over the last 30 days. The data is stored in a Delta table with a timestamp column. Which visualization type should the analyst use to best show the trend over time?
⚠ Common exam trap
The trap here is selecting a bar chart because it can show time on the x-axis, but a line chart is superior for trend analysis.
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
✓
Line chart
A line chart is the most appropriate visualization for showing trends over time. It connects data points to illustrate changes and patterns, making it easy to interpret the daily active user count over the 30-day period. Other chart types are better suited for different analytical purposes.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Scatter plot
Why it's wrong here
A scatter plot is used to show the relationship between two numerical variables, not trends over time. While it could plot date versus user count, it would display discrete points without connecting them, making it harder to perceive a continuous trend. Scatter plots are better for correlation analysis.
- ✗
Bar chart
Why it's wrong here
A bar chart can show values over time, but it is less effective for highlighting trends because the bars emphasize individual values rather than the continuous change between them. For a time series with many data points, a line chart provides a clearer visual of the trend. Bar charts are better for comparing categorical data.
- ✓
Line chart
Why this is correct
A line chart is ideal for displaying trends over time. It plots data points connected by lines, making it easy to see how the number of active users changes from day to day. With dates on the x-axis and user count on the y-axis, the analyst can quickly identify increases, decreases, or patterns over the 30-day period.
- ✗
Pie chart
Why it's wrong here
A pie chart is used to show proportions of a whole at a single point in time, not trends over time. It cannot effectively display daily changes across 30 days. Using a pie chart would make it difficult to discern any trend or pattern in the number of active users over the period.
About these practice questions
One of 291 original Databricks-DA-Assoc practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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.