DA0-002 Visualization and Reporting Practice Test 19 — 15 Questions

Question 1

A junior data analyst is asked to create a chart that shows total monthly revenue for the past 24 months so the finance team can see whether revenue is generally rising or falling over time. Which chart type is most appropriate?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

A line chart with month on the horizontal axis and total revenue on the vertical axis. A line chart is the standard choice for showing change over a continuous, ordered time dimension because the connected line makes direction and rate of change immediately visible. The finance team's question is about trend, not composition or correlation, so a pie chart, stacked bar chart, or scatter plot would obscure the answer. Month on the horizontal axis and revenue on the vertical axis aligns with conventional time-series design.

Answer

A stacked bar chart with one stack per month and a segment for each sales region

Answer

A pie chart with one slice per month showing each month's share of total revenue

Answer

A scatter plot with month on the horizontal axis and revenue on the vertical axis

Question 2

A data analyst is finalizing a recurring monthly operations report that will be exported to PDF and emailed to regional directors who read it on tablets. The analyst must choose design practices that keep the report readable and trustworthy in that fixed, non-interactive format. (Choose two.)

Accepted Answer

Keep each page's color palette and label placement identical from month to month.. A static, non-interactive deliverable must carry its own provenance and its own exact values, so a refresh timestamp and source note are essential for trust. Because the same directors read the report every month, stable color semantics and label placement let them detect change quickly instead of relearning the layout. Interaction-dependent features, degraded legibility, and decorative recoloring all work against those goals.

Answer

Use a different accent color for each region so every chart looks visually distinct.

Answer

Maximize information density by shrinking fonts until every chart fits on a single page.

Answer

Rely on hover tooltips to reveal the exact values behind each bar and line.

Question 3

A data analyst is creating a report to compare the total sales revenue for five different product categories over the last four quarters. The analyst wants to show both the overall total and how each category contributes to that total for each quarter. Which chart type is most appropriate?

Accepted Answer

A stacked bar chart with quarters on the x-axis and sales on the y-axis, with segments for each category.. A stacked bar chart is ideal for showing both total values per quarter and the contribution of each category to those totals. It allows viewers to compare overall quarterly sales and see how the product mix changes over time. The other chart types either omit the total, obscure the part-to-whole relationship, or lose the time dimension.

Answer

A pie chart with one slice per category, using the total sales across all quarters.

Answer

A line chart with quarters on the x-axis and sales on the y-axis, with one line per category.

Answer

A grouped bar chart with quarters on the x-axis and sales on the y-axis, with one bar per category.

Question 4

A data analyst must build a monthly dashboard for the executive team. The dashboard will be viewed on large screens in the boardroom and must display the current month's revenue, profit margin, and customer acquisition cost at a glance. Which design approach best ensures the dashboard is immediately understandable?

Accepted Answer

Use a single color palette with consistent meaning and place the three KPIs as large, clearly labeled tiles at the top of the dashboard.. The correct approach is to use consistent colors and prominent KPI tiles because executive dashboards should prioritize immediate comprehension of key metrics. Large, labeled tiles at the top ensure that revenue, profit margin, and customer acquisition cost are seen first without requiring interaction. This design reduces cognitive load and supports quick decision-making in a boardroom setting.

Answer

Include detailed data tables with conditional formatting to show the exact values for each KPI and supporting calculations.

Answer

Create a separate tab for each KPI with interactive filters so executives can drill into the data themselves.

Answer

Use a variety of chart types, such as pie charts and 3D bar charts, to make the dashboard visually engaging and modern.

Question 5

A data analyst is preparing a dashboard that will be embedded in a public-facing web page and refreshed nightly. The source system contains customer names and account numbers, but the dashboard only needs aggregated counts by region and product line. Which two practices should the analyst apply to reduce disclosure risk while keeping the dashboard functional? (Choose two.)

Accepted Answer

Suppress or combine aggregate cells whose counts fall below a minimum group size threshold.. Minimizing the dataset to only the fields the dashboard consumes removes direct identifiers at the source, and enforcing a minimum group size on aggregate cells blocks the inference route where a tiny count can single out an individual. Together they let regional and product-line counts be published on a public page while removing the two most common re-identification paths.

Answer

Restrict the dashboard to authenticated internal users so the public page shows a login prompt instead of the report.

Answer

Embed the full source table in the page and rely on the chart configuration to display only aggregated values.

Answer

Obscure the identifiers by applying a simple substitution cipher to the name and account number columns before publishing.

Question 6

A data analyst at a subscription streaming service is designing a dashboard for the customer success team. The team needs to monitor, side by side, the current month's churn rate against the same month last year and against a target churn rate of 4.5%. The analyst wants viewers to instantly see whether the current rate is above or below target. Which design approach best supports this?

Accepted Answer

A KPI card showing the current churn rate, the prior-year value, and the target, with a conditional indicator that changes when the target is exceeded. A KPI card with the current churn rate, the prior-year comparison, and the target, plus a conditional indicator, packages exactly the three values the team needs and converts the target comparison into an immediate visual cue. Gauges, tables, and stacked area charts either hide the target relationship or require manual interpretation, slowing the team's ability to act when churn drifts above 4.5%.

Answer

A detailed table listing monthly churn rates for the last 24 months with conditional formatting on the target column

Answer

A gauge chart showing the current churn rate with a needle and colored zones for acceptable and unacceptable ranges

Answer

A stacked area chart showing churn rate components over the last 12 months

Question 7

A retail analytics team publishes a dashboard showing average order value by store. A regional manager notices that the store with the highest average order value is also the store with the fewest orders, and questions whether that store is genuinely the best performer. Which dashboard design change would BEST let the manager judge that store fairly?

Accepted Answer

Add order-count context to the measure, for example by displaying the number of orders alongside the average and sizing or annotating the mark accordingly.. The manager's objection is fundamentally about sample size: an average built on few orders is unstable and easy to top by chance. Pairing the average with the order count, or encoding volume in the mark itself, gives the reader the information needed to weigh the result appropriately while preserving the requested metric. Substituting a different metric, transforming the scale, or filtering out small stores all fail to expose reliability.

Answer

Switch the metric from average order value to total revenue by store and rebuild the ranking on that basis.

Answer

Remove the lowest-volume stores from the dashboard so the ranking reflects only established locations.

Answer

Apply a logarithmic scale to the axis showing average order value so differences between stores appear smaller.

Question 8

A data analyst is building a dashboard that includes a KPI card showing the current customer satisfaction (CSAT) score. The target is 90%. The analyst wants the card to immediately convey whether the current score is meeting, approaching, or below target. Which design approach best achieves this?

Accepted Answer

Display the CSAT score with conditional formatting: green if >= 90%, yellow if 85-89.9%, and red if < 85%.. Conditional formatting with color thresholds immediately signals performance status relative to the target. It leverages pre-attentive processing, allowing viewers to grasp the situation without mental calculation. The other options provide context or trends but fail to deliver an instant, unambiguous status indicator, which is the core need for a KPI card.

Answer

Display the CSAT score with a comparison to the previous period, such as an up or down arrow with percentage change.

Answer

Display the CSAT score as a gauge chart with a needle pointing to the current value on a 0-100% scale.

Answer

Display the CSAT score in a large font with a small line chart showing the trend over the past 30 days.

Question 9

A data analyst is creating a report that compares the performance of five different marketing campaigns over the past year. The analyst wants to show both the total revenue generated by each campaign and the proportion of total revenue that each campaign represents. Which combination of visualizations is most effective for this purpose?

Accepted Answer

A bar chart showing total revenue by campaign and a pie chart showing the percentage of total revenue for each campaign.. The most effective combination is a bar chart for total revenue and a pie chart for proportion. A bar chart enables accurate comparison of revenue totals across campaigns, while a pie chart clearly illustrates each campaign's share of the total when there are only five categories. This dual approach directly addresses both analytical goals without requiring viewers to perform mental calculations.

Answer

A treemap showing revenue by campaign, with rectangle sizes proportional to revenue.

Answer

A line chart showing revenue trends for each campaign over the year and a scatter plot showing revenue versus campaign cost.

Answer

A stacked bar chart showing revenue by campaign, with each bar segmented by month.

Question 10

A data analyst is building a dashboard that includes a map showing sales by state. The map uses a choropleth technique with a continuous color gradient from light blue (low sales) to dark blue (high sales). A stakeholder comments that it is difficult to compare sales between states because the colors look similar. Which adjustment would most improve the map's effectiveness for comparison?

Accepted Answer

Use a sequential color palette with more distinct steps and add data labels showing the sales value for each state.. The stakeholder struggles to compare states because the continuous blue gradient lacks distinct steps. Using a sequential palette with more distinct steps improves discriminability, and adding data labels provides exact values. This combination leverages both visual and numerical encoding to facilitate accurate comparison across states.

Answer

Switch to a diverging color palette centered on the average sales value.

Answer

Change the map to a symbol map with circles sized by sales.

Answer

Use a continuous color gradient with a wider range of hues, such as from red to green.

Question 11

A data analyst has built a dashboard for a retail chain that shows sales by product category. During user testing, store managers report that they cannot tell which categories are the top performers because the bars are arranged in the order the categories appear in the database, and the y-axis starts at zero with a very high maximum that compresses all bars. Which change should the analyst make to improve the chart's communicative value?

Accepted Answer

Sort the bars in descending order by sales and keep the y-axis starting at zero. Descending sort by sales surfaces the ranking directly, and maintaining a zero baseline keeps bar lengths proportional and honest. The original problems were ordering by an irrelevant database sequence and a scale that compressed differences; sorting fixes the first, and a zero-based axis with an appropriate maximum fixes the second without distortion. Alphabetical sorting, axis truncation, or switching to a pie chart each fails to resolve the ranking or scale issue.

Answer

Sort the bars alphabetically by category name and add data labels to each bar

Answer

Replace the bar chart with a pie chart sorted by slice size and add percentage labels

Answer

Keep the database order but change the y-axis to start at the minimum bar value to emphasize differences

Question 12

A marketing team wants a single view comparing this quarter's campaign performance against the same quarter last year across five channels, with the ability to drill from channel totals down to individual campaign rows. Which visualization structure best supports both the comparison and the drill path?

Accepted Answer

A matrix with channels as rows and the two quarters as columns, configured with a drill-down hierarchy from channel to campaign.. A matrix handles both demands at once: channels as rows give a stable axis for comparing the two quarter columns side by side, and the built-in row hierarchy lets a user expand a channel to reveal its campaigns. The comparison stays in one visual while the drill path descends the same hierarchy, avoiding a jump to a separate page.

Answer

A treemap sized by campaign spend with channels as top-level rectangles.

Answer

A bar chart of this quarter's channel totals with a separate bar chart of last year's totals placed beside it.

Answer

A line chart plotting campaign rows over time with one line per channel.

Question 13

A data analyst is preparing a quarterly business review report for a retail company. The report includes a bar chart showing sales by region. The analyst notices that the chart is very wide and the region labels are overlapping, making it hard to read. The analyst wants to improve readability without losing any regions. Which action is most appropriate?

Accepted Answer

Convert the bar chart to a horizontal bar chart, placing regions on the y-axis.. Converting to a horizontal bar chart is the most effective solution because it provides ample space for region labels on the y-axis, eliminating overlap and improving readability. It maintains the ability to compare sales across regions. The other options either partially mitigate the issue or introduce new problems such as reduced comparability or awkward label orientation.

Answer

Rotate the region labels 90 degrees so they fit vertically under each bar.

Answer

Increase the width of the chart to provide more space between bars.

Answer

Use a pie chart instead, as it naturally avoids label overlap by placing labels outside the slices.

Question 14

A data analyst has built a dashboard tracking daily website sessions. The product owner wants to know which acquisition channel contributed the largest share of sessions over the past quarter, and how those shares shifted month by month. Which chart type is MOST appropriate?

Accepted Answer

A stacked bar chart with one bar per month and segments for each acquisition channel.. The question combines a part-to-whole comparison with a time progression, which is precisely what a stacked bar chart handles: each monthly bar totals the sessions while its segments show each channel's contribution, and a 100% stacked form isolates share. Line charts emphasize absolute trends, scatter plots require two continuous variables, and waterfalls imply sequential deductions that do not exist here.

Answer

A line chart with one line per acquisition channel plotting sessions against time.

Answer

A waterfall chart starting from total quarterly sessions and subtracting each channel's contribution.

Answer

A scatter plot of sessions against channel with each point representing one day.

Question 15

A data analyst is designing a dashboard to monitor real-time website traffic. The dashboard will be used by the operations team to quickly identify anomalies and take immediate action. Which two design elements are most critical to include? (Choose two.)

Accepted Answer

Clear visual alerts (e.g., color-coded thresholds) for metrics exceeding normal ranges.. The two most critical elements are automatic refresh with a timestamp and clear visual alerts for anomalies. Real-time monitoring demands that data is current and that deviations from normal are immediately visible. A timestamp builds trust in data freshness, while color-coded thresholds enable split-second recognition of issues. Together, they empower the operations team to act quickly and confidently.

Answer

A detailed data table showing all raw traffic data for the current day.

Answer

A historical trend line showing traffic over the past year for context.

Answer

Drill-down capabilities to explore individual user sessions.