DA0-002 Visualization and Reporting — 100 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

Question 16

A hospital's analytics team has created a dashboard for tracking patient wait times across departments. The dashboard uses a stacked bar chart showing average wait time per department, with each bar segmented by severity level (Low, Medium, High). However, management complains that it is difficult to compare total wait times across departments or identify which department has the highest average wait time. The data itself is accurate and complete. The analyst needs to redesign the visualization to address these concerns. Which course of action should the analyst take?

Accepted Answer

Change the chart to a grouped bar chart, with each department having separate bars for each severity level placed side-by-side.. The core problem is that stacked bars make it hard to compare totals across departments because the segments do not share a common baseline—only the bottom segment aligns. A grouped bar chart places each severity level's bar side-by-side within each department group, so the total for each department is visually apparent (the group height) and individual severity comparisons are also easy. This directly addresses management's need to compare totals and identify the highest-wait department.

Answer

Replace the stacked bar chart with multiple line charts, one per department.

Answer

Use a heat map with departments on one axis and severity levels on the other, with color intensity representing wait time.

Answer

Switch to a pie chart showing the proportion of total wait time each department contributes.

Question 17

A retail company has collected data on monthly advertising spend (in thousands of dollars) and corresponding sales (in thousands of dollars) over the past 12 months. The analyst creates a scatter plot to visualize the relationship between advertising spend and sales. The plot shows a cluster of points with a positive trend, but there is one extreme outlier where spend was $100,000 but sales were only $20,000. Upon investigation, the analyst discovers that the outlier is due to a data entry error: the sales figure should have been $200,000. The analyst wants to present the overall trend accurately in a meeting. Which course of action should the analyst take first?

Accepted Answer

Remove the outlier and recreate the scatter plot.. The outlier is confirmed to be a data entry error (sales should be $200,000, not $20,000), so it does not represent a real observation. Correcting the underlying data by removing (or fixing) the erroneous point is the necessary first step before any trend analysis or visualization, because the outlier will distort the regression line and mislead the audience. Only after cleaning the data should the analyst recreate the scatter plot to show the true positive relationship.

Answer

Use a bar chart to show average sales per advertising spend bin.

Answer

Add a trend line using linear regression to the current scatter plot.

Answer

Change the chart type to a line chart.

Question 18

An analyst has a dataset with monthly sales figures for the past five years. They want to highlight the cumulative effect of sales over time and show the total contribution of each month stacked on top of previous months. Which chart type is most suitable?

Accepted Answer

Area chart. An area chart is the most suitable choice because it fills the space between the line and the baseline with color, visually emphasizing the cumulative total over time. This allows the analyst to see both the trend of monthly sales and the stacked contribution of each month to the overall cumulative effect, which is exactly what the question requires.

Answer

Line chart

Answer

Stacked bar chart

Answer

Waterfall chart

Question 19

A data analyst is working in Looker Studio and wants to add a metric that counts the number of unique customers per month. In the context of Looker Studio, which type of field is this metric?

Accepted Answer

Metric. In Looker Studio, a metric is a field that aggregates numeric data, such as counts, sums, or averages. Counting unique customers per month requires an aggregation (COUNT_DISTINCT) applied to a numeric or identifier field, which is the defining characteristic of a metric. Dimensions are used for grouping and categorizing data, not for performing calculations like counting unique values.

Answer

Dimension

Answer

Parameter

Answer

Blend

Question 20

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

Consistent color coding across all charts. Option A is correct because consistent color coding across all charts lets both executives and operations managers interpret the same metric (e.g., revenue always in blue, returns always in red) without relearning the legend on each visual, reducing cognitive load and misinterpretation. Option C is correct because a visual hierarchy that emphasizes the most important KPIs (e.g., largest size, top-left placement, boldest color for revenue or conversion rate) serves the executives' strategic view while still letting operations managers drill into secondary metrics. Option D is correct because interactive filters that slice data by region, date, and product directly support the stated requirement of serving two audiences with one dashboard, enabling executives to see aggregate trends and operations managers to isolate specific segments. Option B is not appropriate because annotating every data point creates clutter and defeats the purpose of a dashboard, which should surface trends and exceptions rather than exhaustively label each value. Option E is not appropriate because maximizing data-ink ratio by removing all labels and titles would strip the context needed to interpret the charts, harming comprehension for both audiences.

Answer

Including annotations on every data point

Answer

Maximizing the data-ink ratio by removing all labels and titles