Databricks-DA-Assoc Creating Dashboards and Visualizations Practice Question
You are building a Databricks SQL dashboard and have a query that returns columns: order_date (DATE), region (STRING), and total_sales (DECIMAL). You want a single visualization that shows the trend of total_sales over order_date, with a separate line for each region, all on the same chart. Which visualization type should you select?
⚠ Common exam trap
The trap here is assuming any chart with a date on the X-axis will show a trend, when only a line chart connects points into continuous series per category.
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
The requirement is a temporal trend with one line per region, which is exactly what a line chart provides when a categorical column such as region is used as the series. The other chart types either compare static categories, show parts of a whole, or display point correlations, and none of them express continuous multi-series trends over dates.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Pie chart
Why it's wrong here
A pie chart shows parts of a whole at a single point in time, using slices proportional to a measure. It cannot represent a time series or multiple lines over dates, and adding region as slices would lose the temporal dimension entirely. This visualization fails the trend-over-time requirement.
- ✗
Scatter chart
Why it's wrong here
A scatter chart plots individual points to show correlation between two numeric variables. While you could put order_date on one axis, it does not connect points into continuous trend lines and does not naturally separate series by a categorical field like region. It is inappropriate for showing sales trends over time.
- ✗
Bar chart
Why it's wrong here
A bar chart compares discrete categories using rectangular bars, not continuous trends over time. Although you could place order_date on the X-axis, a bar chart would render a separate bar per date and cannot express a continuous multi-series temporal trend as clearly as a line. It is not the best fit for trend analysis across regions.
- ✓
Line chart
Why this is correct
A line chart plots a numeric measure on the Y-axis against a time or ordered dimension on the X-axis, and when a categorical column such as region is added to the series or grouping, it draws a distinct line per region. This directly satisfies the requirement to compare regional sales trends over time on one chart.
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.