DA0-002 Visualization and Reporting — Timed 25 Questions

Question 1

A logistics company has data on delivery times (continuous) and distance traveled (continuous). They want to visualize the relationship between these two variables. Which chart type is most appropriate?

25 minute time limit — choose an answer to begin.

Accepted Answer

Scatter plot. Scatter plots are used to visualize the relationship between two continuous variables. Option A (Histogram) is incorrect because it is used to show the frequency distribution of a single continuous variable, not the relationship between two variables. Option B (Bar chart) is incorrect because it is used for comparing categorical data, not for showing relationships between continuous variables. Option C (Line chart) is incorrect because it is typically used to show trends over time, not the relationship between two continuous variables.

Answer

Histogram

Answer

Bar chart

Answer

Line chart

Question 2

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 3

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 4

A data analyst creates a bubble chart showing country GDP (x-axis), life expectancy (y-axis), and population (bubble size). However, large bubbles overlap and obscure many data points. Which corrective action should the analyst take?

Accepted Answer

Set bubble opacity to 70%. Setting bubble opacity to 70% allows overlapping bubbles to become semi-transparent, so data points underneath remain visible. This technique preserves the original data representation (GDP, life expectancy, and population) without altering the chart's scale or removing data. It is a standard visualization practice for handling overplotting in dense scatter plots and bubble charts.

Answer

Increase the chart canvas size

Answer

Reduce all bubble sizes uniformly

Answer

Remove outlier countries with large populations

Question 5

An analyst wants to show the distribution of test scores for 500 students. Which visualization type is best for understanding the shape of the distribution?

Accepted Answer

Histogram. A histogram is the correct choice because it groups continuous test scores into bins and displays the frequency of scores within each bin, allowing the analyst to see the shape of the distribution (e.g., normal, skewed, bimodal). This directly addresses the goal of understanding distribution shape, which is a core use case for histograms in data visualization.

Answer

Line chart

Answer

Pie chart

Answer

Scatter plot

Question 6

A dashboard shows sales by region using a map with color intensity. Users complain that two regions with very different sales appear nearly the same color. What is the most likely cause?

Accepted Answer

The color scale uses a sequential palette with insufficient contrast. The issue is that the color scale uses a sequential palette with insufficient contrast between adjacent data values. When the color gradient is too narrow or uses similar hues, regions with significantly different sales figures map to nearly identical colors, making the visualization ineffective. This is a common problem in data visualization when the color mapping does not span the full range of the data or uses a perceptually uniform palette poorly.

Answer

The map projection is distorted

Answer

The monitor resolution is too low

Answer

Users are color blind

Question 7

An analyst creates a stacked bar chart showing quarterly sales by product category. The chart becomes hard to read because some categories have very small contributions. Which redesign is most effective?

Accepted Answer

Combine small categories into an 'Other' group. Combining small categories into an 'Other' group reduces visual clutter and improves readability by aggregating negligible contributions into a single bar segment. This technique preserves the overall trend while eliminating the noise from many tiny slices that make the stacked bar chart hard to interpret.

Answer

Change to a pie chart for each quarter

Answer

Increase the width of each bar

Answer

Switch to a 3D stacked column chart

Question 8

A data analyst needs to present the correlation between advertising spend and website traffic. Which chart type is most appropriate?

Accepted Answer

Scatter plot. A scatter plot is the most appropriate chart type for visualizing the correlation between two continuous variables, such as advertising spend and website traffic. It displays individual data points on a Cartesian plane, allowing the analyst to assess the strength, direction, and form of the relationship (e.g., linear, non-linear, or no correlation). This aligns with the DA0-001 objective of selecting the correct visualization for bivariate analysis.

Answer

Bar chart

Answer

Line chart

Answer

Pie chart

Question 9

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 10

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 11

Which TWO actions are best practices for creating effective data visualizations?

Accepted Answer

Avoid using more than five slices in a pie chart. Pie charts with more than five slices become cluttered and difficult to read, making it hard for viewers to compare proportions accurately. Limiting slices to five or fewer ensures the chart remains clear and effectively communicates the relative sizes of categories. This best practice aligns with data visualization principles that prioritize clarity and cognitive ease.

Answer

Maximize data-ink ratio by removing all whitespace

Answer

Always include gridlines with high contrast

Answer

Use 3D effects to make charts look professional

Question 12

Which THREE factors should be considered when choosing a chart type for a dataset?

Accepted Answer

The data types (categorical, numerical, time series). The data type (categorical, numerical, time series) determines which chart types are semantically valid. For example, a line chart requires a continuous numerical or time-series axis, while a bar chart works with categorical data. Choosing a chart that mismatches the data type can misrepresent the underlying distribution or trends.

Answer

The animation capabilities of the software

Answer

The color scheme of the company logo

Question 13

Which TWO visualization types are suitable for showing the distribution of a single continuous variable?

Accepted Answer

Box plot. A box plot is correct because it graphically depicts the distribution of a single continuous variable through its five-number summary (minimum, first quartile, median, third quartile, maximum), clearly showing spread, central tendency, and outliers. A histogram is correct because it bins the continuous variable into intervals and displays the frequency of data points within each bin, providing a direct view of the underlying probability distribution.

Answer

Line chart

Answer

Scatter plot

Answer

Pie chart

Question 14

You are a data analyst for an e-commerce company. Your team has built a dashboard to monitor daily sales performance across five regions: North, South, East, West, and Central. The dashboard includes a bar chart showing total sales per region, a line chart showing daily sales trend over the past 30 days, and a pie chart showing sales distribution by product category (Clothing, Electronics, Home, Books, Sports). Recently, stakeholders have complained that the pie chart is hard to interpret because the Sports category has very small sales and is barely visible. Also, the bar chart uses a rainbow color scheme that makes it difficult to compare bar heights because the colors are not ordered by magnitude. The line chart is fine. You need to redesign the dashboard to address these issues. Which combination of changes is most appropriate?

Accepted Answer

Group small categories into an 'Other' slice in the pie chart and use a sequential color scheme ordered by sales for the bar chart. Grouping small categories into an 'Other' slice directly addresses the pie chart's readability issue by consolidating negligible values, and using a sequential color scheme ordered by sales for the bar chart improves the ability to compare bar heights by encoding magnitude through color intensity. This combination follows best practices for data visualization: avoid cluttering with tiny slices and use ordered, perceptually uniform colors to facilitate accurate comparisons.

Answer

Replace the pie chart with a stacked bar chart and use a categorical color scheme for the bar chart

Answer

Explode the Sports slice in the pie chart and use a monochromatic color scheme for the bar chart

Answer

Change the pie chart to a 3D pie chart and use a diverging color scheme for the bar chart

Question 15

You are a data analyst at a logistics company. You have created a dashboard to monitor delivery performance. The dashboard includes a scatter plot showing delivery time (hours) vs. distance (miles) for each delivery, with points colored by delivery region (A, B, C, D, E). Users have reported that the scatter plot is cluttered because there are over 10,000 points, making it hard to see patterns. Additionally, the color legend for the five regions uses similar shades of blue, making it difficult to distinguish which region a point belongs to. You need to improve the scatter plot to reduce overplotting and improve region differentiation. Which approach is most effective?

Accepted Answer

Set point opacity to 30% and use a qualitative color palette with distinct hues for each region. Reducing opacity (alpha blending) mitigates overplotting by making overlapping points more transparent, while switching to a qualitative color palette (e.g., distinct hues like red, green, blue) ensures each of the five regions is easily distinguishable. This directly addresses both user complaints without losing the overall distribution context.

Answer

Use a hexagonal binning plot (hexbin) with color representing region

Answer

Create five separate scatter plots (small multiples) for each region

Answer

Convert to a bubble chart by adding package weight as bubble size

Question 16

A data analyst needs to visualize the relationship between two continuous variables: advertising spend (in dollars) and monthly sales (in units). Which chart type is most appropriate?

Accepted Answer

Scatter plot. A scatter plot is the most appropriate chart for visualizing the relationship between two continuous variables, such as advertising spend (dollars) and monthly sales (units). It displays individual data points on an x-y axis, allowing the analyst to observe correlation, clustering, or outliers between the two numeric fields. This aligns with the DA0-001 objective of selecting visualizations based on data type and analytical goal.

Answer

Pie chart

Answer

Bar chart

Answer

Line chart

Question 17

A data analyst is creating a dashboard for a retail company. The dashboard should provide insights into sales performance across multiple dimensions. Which TWO chart types are best suited for showing the contribution of each product category to total sales?

Accepted Answer

Pie chart. A pie chart is ideal for showing the contribution of each product category to total sales because it visually represents parts of a whole, making it easy to compare proportions at a glance. The stacked bar chart also effectively shows category contributions within a total, allowing for both absolute and relative comparisons across different time periods or segments. Both chart types directly address the need to visualize proportional breakdowns of a single aggregate metric.

Answer

Scatter plot

Answer

Histogram

Answer

Line chart

Question 18

You are a data analyst for a logistics company. The company has a fleet of delivery trucks and tracks performance metrics including delivery time, fuel consumption, and distance traveled. Management wants a dashboard to monitor driver efficiency and identify underperforming drivers. You have access to a dataset with columns: DriverID, Date, RouteID, Distance (miles), FuelUsed (gallons), DeliveryTime (minutes). The dataset contains 10,000 records from the past year. You need to create a visualization that allows management to quickly compare the average fuel efficiency (miles per gallon) of drivers and also see how consistent each driver's efficiency is. Which of the following approaches is the best course of action?

Accepted Answer

Create a box plot grouped by DriverID showing the distribution of MPG for each driver.. A box plot grouped by DriverID is the best choice because it simultaneously shows the central tendency (median MPG) and the spread (interquartile range and outliers) of each driver's fuel efficiency. This allows management to quickly compare average efficiency across drivers while also assessing consistency—drivers with narrow boxes are more consistent, while those with wide boxes or many outliers are erratic. The other options either fail to show distribution (bar chart, line chart) or require manual interpretation of consistency (scatter plot).

Answer

Create a line chart with Date on the x-axis and MPG on the y-axis, with separate lines for each driver.

Answer

Create a scatter plot with Distance on the x-axis and FuelUsed on the y-axis, color-coded by DriverID.

Answer

Create a bar chart showing the average MPG for each driver.

Question 19

Drag and drop the steps to clean a dataset with missing values in the correct order.

Accepted Answer

Step 1: Identify missing values, Step 2: Analyze missingness pattern, Step 3: Select imputation/removal strategy, Step 4: Apply the strategy, Step 5: Document changes. Cleaning starts with identification, then analysis of missingness, strategy selection, application, and documentation.

Answer

Step 1: Analyze missingness pattern, Step 2: Identify missing values, Step 3: Select imputation/removal strategy, Step 4: Apply the strategy, Step 5: Document changes

Answer

Step 1: Identify missing values, Step 2: Select imputation/removal strategy, Step 3: Analyze missingness pattern, Step 4: Apply the strategy, Step 5: Document changes

Answer

Step 1: Identify missing values, Step 2: Analyze missingness pattern, Step 3: Apply the strategy, Step 4: Document changes, Step 5: Select imputation/removal strategy

Question 20

Drag and drop the steps to resolve data integration conflicts in the correct order.

Accepted Answer

Step 1: Identify conflicts, Step 2: Analyze conflicts, Step 3: Standardize data, Step 4: Transform data, Step 5: Merge data. Conflict resolution starts with identification, analysis, standardization, transformation, and merging.

Answer

Step 1: Identify conflicts, Step 2: Standardize data, Step 3: Analyze conflicts, Step 4: Transform data, Step 5: Merge data

Answer

Step 1: Analyze conflicts, Step 2: Identify conflicts, Step 3: Standardize data, Step 4: Transform data, Step 5: Merge data

Answer

Step 1: Identify conflicts, Step 2: Analyze conflicts, Step 3: Transform data, Step 4: Standardize data, Step 5: Merge data