DA0-002 Visualization and Reporting — 15 Questions

Question 1

A data analyst is creating a dashboard to monitor server CPU utilization over the past 24 hours. Which chart type is most appropriate for showing the trend of CPU usage over time?

Accepted Answer

Line chart. A line chart is the most appropriate choice for displaying CPU utilization trends over a continuous 24-hour period because it connects data points in chronological order, making it easy to observe peaks, valleys, and overall patterns. The x-axis represents time (hours), and the y-axis represents CPU usage percentage, allowing the analyst to quickly identify when utilization spikes or drops. This aligns with the DA0-001 objective of selecting the correct visualization for time-series data.

Answer

Scatter plot

Answer

Pie chart

Answer

Bar chart

Question 2

A sales dashboard shows monthly revenue but the bars are very tall for some months and very short for others, making comparisons difficult. Which visualization modification would best improve readability?

Accepted Answer

Apply a logarithmic scale on the y-axis. A logarithmic scale compresses the y-axis so that large values are displayed proportionally to small values, making it easier to compare relative changes across months with vastly different revenue figures. This is particularly useful when the data spans several orders of magnitude, as it prevents tall bars from dominating the view and short bars from being barely visible.

Answer

Change bar colors to gradient

Answer

Add more horizontal gridlines

Answer

Use a 3D bar chart for depth

Question 3

An analyst builds a dashboard with a gauge showing 'Current Inventory Level' as a percentage. Stakeholders find the gauge misleading because it always shows near 100% even when inventory is low. What is the most likely issue?

Accepted Answer

The maximum value of the gauge is set too low. When a gauge always shows near 100% despite low inventory, the most likely cause is that the maximum value of the gauge is configured too low. This scaling mismatch makes even small inventory values appear as a high percentage, making the gauge misleading. Therefore, option A is correct: the maximum value is set too low, causing the percentage to be artificially high.

Answer

The gauge updates too slowly

Answer

The gauge uses green for all values

Answer

The gauge needle is too small

Question 4

A data analyst creates a heatmap to show website click-through rates by hour and day of week. The heatmap uses a green-to-red gradient, but users cannot distinguish between moderate values. What is the best fix?

Accepted Answer

Switch to a diverging color scheme with a neutral center. A diverging color scheme with a neutral center (e.g., white or light gray) allows users to distinguish moderate values from extremes by providing a clear visual midpoint. The original green-to-red gradient is a sequential scheme that compresses moderate values into a narrow perceptual range, making them indistinguishable. Switching to a diverging palette solves this by mapping moderate values to the neutral center and extremes to the endpoints.

Answer

Remove all but the highest and lowest values

Answer

Add black borders around each cell

Answer

Increase the size of each heatmap cell

Question 5

Match each data type to its example.

Accepted Answer

Nominal: Colors of cars (red, blue, green). Nominal data are categories without order; ordinal data have ranked categories; interval data have equal intervals but no true zero; ratio data have equal intervals and a true zero. Common confusions include mistaking nominal for ordinal (e.g., gender) or interval for ratio (e.g., counts).

Answer

Ordinal: Gender (male, female)

Answer

Interval: Number of siblings (0,1,2,3)

Question 6

A marketing team wants to compare the growth rates of four product categories over the last quarter. Which chart type would best display this?

Accepted Answer

Bar chart. A bar chart is ideal for comparing discrete values across categories, such as the growth rates of four product categories. It allows for easy visual comparison of the heights of the bars. Option A (pie chart) is unsuitable for comparing growth rates as it shows proportions of a whole, not rates. Option B (stacked bar chart) would show cumulative totals, not individual growth rates. Option C (line chart) is better for trends over time, not for comparing discrete categories.

Answer

Pie chart

Answer

Stacked bar chart

Answer

Line chart

Question 7

A dataset contains salaries ranging from $25,000 to $2,500,000, with most salaries under $100,000. Which chart type best shows the distribution without distortion from extreme values?

Accepted Answer

Box plot. A box plot is ideal for showing the distribution of a dataset with extreme values because it displays the median, quartiles, and potential outliers without being distorted by them. The interquartile range (IQR) focuses on the middle 50% of the data, so extreme salaries like $2,500,000 appear as outliers rather than stretching the scale. This makes the box plot the best choice for comparing distributions and identifying skewness.

Answer

Scatter plot

Answer

Histogram with equal bin widths

Answer

Line chart

Question 8

Which TWO are best practices for designing effective dashboards? (Select exactly two.)

Accepted Answer

Use a single page to avoid scrolling.. Option D is correct because keeping a dashboard to a single page lets viewers grasp the key information at a glance without scrolling, which supports fast, at-a-glance monitoring and decision-making. Option E is correct because a consistent color scheme across visualizations reduces cognitive load and prevents viewers from misinterpreting colors as representing different meanings in different charts, improving readability and comparability. Options A, B, and C are not best practices: 3D charts distort proportions and hinder accurate comparison, pie charts are generally poor for comparing parts of a whole when there are many categories or similar values (bar charts are usually better), and including every possible metric creates clutter and obscures the most important signals.

Answer

Use 3D charts for visual appeal.

Answer

Use pie charts for comparing parts of a whole.

Answer

Include every possible metric to provide completeness.

Question 9

A dashboard uses a heatmap to show sales density by hour and day of week. Users report that the color scale is confusing because some low values appear similar to high values. Which design change improves clarity?

Accepted Answer

Switch to a diverging color scale. Using a diverging color scale with a neutral midpoint improves differentiation between low, medium, and high values. A sequential scale may still cause confusion. Increasing color steps or using a single hue does not address the issue.

Answer

Use a sequential color scale with more contrast

Answer

Increase the number of color steps

Answer

Change to a single hue gradient

Question 10

The exhibit shows a JSON configuration for a line chart that displays average response time over time. However, the chart shows jagged lines with many spikes. Which configuration change would smooth the visualization?

Accepted Answer

Change "interpolation" to "monotone". The jagged lines with spikes indicate that the chart is using linear interpolation, which connects data points with straight lines and preserves every fluctuation. Changing 'interpolation' to 'monotone' applies a monotone cubic interpolation that produces a smooth curve while preserving the overall trend and avoiding overshoot. This smoothing effect reduces visual spikes without altering the underlying data, making the chart easier to read.

Answer

Change "aggregation" to "average"

Answer

Change the query to include a moving average

Answer

Change chartType to "bar"

Question 11

A retail analyst wants to visualize monthly sales over the past year to identify seasonal patterns. Which chart type is best?

Accepted Answer

Line chart. A line chart is best for visualizing monthly sales over time because it explicitly shows trends and seasonal patterns across a continuous time axis. The sequential ordering of months allows the line to connect data points, making it easy to identify peaks, troughs, and recurring cycles. This aligns with the DA0-001 objective of selecting appropriate visualizations for time-series data.

Answer

Pie chart

Answer

Histogram

Answer

Box plot

Question 12

Refer to the exhibit. A data analyst attempts to visualize the dataset but receives a permission error. The analyst's username is 'analyst2'. What is the most likely cause?

Accepted Answer

The analyst's username is not in the users list. The permission error occurs because the analyst's username 'analyst2' does not appear in the users list of the access control configuration, so the system denies access before any read/write permission check is evaluated. In most access-control models, identity lookup precedes permission evaluation, so an unrecognized user produces a permission error regardless of the permissions that would have been granted.

Answer

The analyst lacks write permission

Answer

The analyst lacks read permission

Answer

JSON syntax error prevents parsing

Question 13

A data analyst creates a bar chart to compare average customer satisfaction scores across five departments. The chart shows very tall bars for three departments and very short bars for two departments, making differences hard to assess. What is the most likely cause and the best fix?

Accepted Answer

The y-axis does not start at zero; reset it to zero. When a bar chart's y-axis does not start at zero, the visual differences between bars are exaggerated, making small differences appear large and distorting the comparison. For average satisfaction scores, starting at zero provides a true proportional representation. Resetting the y-axis to zero is the correct fix to accurately reflect the data.

Answer

The chart should group departments by region to reduce variance

Answer

The data should be visualized as a line chart instead

Answer

The bar chart should be replaced with a 3D version for better depth

Question 14

A finance department wants to compare actual expenses against budgeted amounts for each of 10 departments over the past 12 months. They need to show the variance (over/under budget) as well as the trend of expenses over time. The data includes monthly actual and budget figures for each department. The audience is the CFO who needs a quick overview. Which visualization approach should be used?

Accepted Answer

A dual-axis chart with bars for actual and budget by month for each department, and a line for variance. A dual-axis chart with bars for actual and budget by month and a line for variance is correct because it simultaneously addresses all three requirements: comparing actual vs. budget (via paired bars), showing variance (via the line on a secondary axis), and revealing trends over time (via the monthly sequence). The dual-axis design allows the variance line to be scaled independently from the dollar amounts, making both the magnitude of the variance and the trend visible without distortion. This is the only option that combines all three elements in a single, CFO-friendly view.

Answer

A waterfall chart showing cumulative variance over the year

Answer

A table with conditional formatting to highlight over-budget cells

Answer

Stacked bar chart with one bar per month, segments showing each department's actual and budget

Question 15

A data analyst is creating a dashboard to monitor server CPU utilization over the past 24 hours. Which chart type is most appropriate for showing the trend of CPU usage over time?

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

Accepted Answer

Line chart. A line chart (A) is correct because plotting monthly sales as a continuous line over two years clearly reveals the overall trend and makes recurring seasonal peaks and troughs easy to spot. A bar chart (D) is also correct because discrete monthly bars let the analyst compare individual months and visually highlight seasonal fluctuations against the broader trend. A stacked area chart (B) is not appropriate here since stacking implies part-to-whole composition across multiple series, which is not the case with a single sales measure. A scatter plot (C) is designed to show correlation between two numeric variables, not time-based trends. A pie chart (E) shows proportions of a whole at a single point in time and cannot represent a two-year monthly time series.

Answer

Stacked area chart

Answer

Scatter plot

Answer

Pie chart