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

Databricks Data Analyst Associate · free practice question

A data analyst wants to show what percentage of total quarterly revenue each of the five product categories contributed. The goal is to make the relative…

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 wants to show what percentage of total quarterly revenue each of the five product categories contributed. The goal is to make the relative proportions immediately obvious to stakeholders. Which visualization type is most effective?

  1. AA multi-line chart with one line per product category showing revenue over the quarter, with percentage contribution annotations added at the rightmost data point of each line
  2. BA scatter plot placing product categories on the X-axis and revenue on the Y-axis, with bubble size representing each category's percentage of total revenue to add a proportional dimension
  3. CA pie or donut chart displaying the five product categories as proportional slices of the whole, making each category's relative revenue contribution immediately visible and easy to compare
  4. DA heat map with product categories as rows and weeks as columns, using a color intensity scale to represent the revenue percentage so that the distribution across time is visible
  5. EA stacked area chart where each category is a separate shaded band stacked so that the combined height of all bands equals 100% of quarterly revenue over a continuous time axis
Answer & explanation

Correct answer: C

WHY C: A pie or donut chart is the standard visualization for communicating proportions of a whole. With only five categories, it effectively shows each category's percentage share of total quarterly revenue at a glance, making relative contributions immediately obvious to stakeholders. WHY NOT A: A multi-line chart is optimized for showing trends over time, not static proportions at a single quarter; adding percentage annotations helps but does not make the proportional relationships as intuitively clear as a pie chart. WHY NOT B: A scatter plot is designed to show correlation or distribution between two numeric variables; using bubble size for percentage adds visual complexity without delivering the immediate proportional clarity of a pie chart. WHY NOT D: A heat map is better for showing intensity across a two-dimensional grid (category × time) and does not directly communicate each category's share of the total in a single-quarter static comparison. WHY NOT E: A stacked area chart is effective for showing how proportions change over continuous time; for a single static quarter where the goal is immediate proportional comparison, a pie or donut chart is far more direct and intuitive.

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 →