Courseiva

CCNA Visualizing Data Questions

75 of 84 questions · Page 1/2 · Visualizing Data topic · Answers revealed

Practice these questionsExam hubAll questions
1
MCQeasy

A data analyst wants to show the relative proportions of defects by type in a manufacturing process. There are 6 defect types. Which chart is most appropriate?

A.Line chart
B.Pie chart
C.Stacked bar chart
D.Scatter plot
AnswerB

Pie chart effectively shows each defect type's share of total.

Why this answer

A pie chart is standard for showing parts of a whole, especially with few categories. Bar chart is also possible but not the best for proportions. Scatter and line charts are not for proportions.

Practice this question →
2
MCQhard

A company uses a dashboard to monitor server uptime. The data is collected every minute, but the dashboard only refreshes every hour. Users see gaps in the line chart. What is the most likely cause, and how should it be fixed?

A.The line chart should interpolate missing data points
B.Switch to a bar chart to avoid gaps
C.Increase the dashboard refresh rate to match data collection frequency
D.Use a different data series with the same refresh rate
AnswerC

Refreshing every minute eliminates gaps because data is fetched in near real-time.

Why this answer

The gaps are due to the dashboard not displaying data for the time between refreshes; the chart should interpolate or the refresh rate should match data collection. Using a bar chart does not solve gaps. Not all series need the same refresh.

Practice this question →
3
Multi-Selectmedium

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?

Select 2 answers
A.Scatter plot
B.Histogram
C.Pie chart
D.Line chart
E.Stacked bar chart
AnswersC, E

Pie charts effectively show each category's proportion of the total.

Why this answer

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.

Exam trap

The trap here is that candidates often choose a line chart (Option D) for any sales data because they associate sales with trends, overlooking that the question specifically asks for contribution to total sales, not change over time.

Practice this question →
4
Multi-Selecteasy

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

Select 2 answers
A.Box plot
B.Line chart
C.Histogram
D.Scatter plot
E.Pie chart
AnswersA, C

Box plots display summary statistics and distribution shape.

Why this answer

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.

Exam trap

CompTIA often tests the distinction between visualization types by presenting a line chart as a distractor, tempting candidates to confuse trend visualization with distribution analysis, especially when the continuous variable is time-based.

Practice this question →
5
MCQmedium

A data analyst needs to visualize the relationship between two continuous variables, such as sales revenue and advertising spend, to identify potential correlation. Which chart type is most appropriate?

A.Pie chart
B.Line chart
C.Bar chart
D.Scatter plot
AnswerD

Scatter plots show the relationship between two continuous variables and can reveal correlations.

Why this answer

Option C is correct because a scatter plot is specifically designed to show the relationship between two continuous variables and can reveal correlations, clusters, or outliers. Option A is wrong because bar charts compare discrete categories, not continuous relationships. Option B is wrong because line charts show trends over time, not correlation between two variables.

Option D is wrong because pie charts show proportions of a whole.

Practice this question →
6
Multi-Selecteasy

Which TWO are common mistakes when creating data visualizations?

Select 2 answers
A.Using excessive 3D effects that obscure data
B.Sorting categories alphabetically in a bar chart
C.Choosing a color-blind friendly palette
D.Including a legend to identify chart elements
E.Starting the y-axis at a value other than zero
AnswersA, E

3D effects can distort proportions and reduce readability.

Why this answer

Options A and D are correct. Truncated axis (A) can mislead, and excessive 3D effects (D) distort data. Option B is wrong because using a legend is good.

Option C is wrong because sorting alphabetically can be helpful for lookup. Option E is wrong because color-blind friendly palettes are a best practice.

Practice this question →
7
MCQmedium

A business analyst wants to compare the proportion of total sales contributed by each product category in the current year. Which visualization is most suitable?

A.Pie chart
B.Scatter plot
C.Line chart
D.Histogram
AnswerA

Pie charts are ideal for displaying proportions of a whole.

Why this answer

Option C is correct because a pie chart effectively shows parts of a whole when the number of categories is small. Option A is for trends. Option B is for distribution of a continuous variable.

Option D is for relationships.

Practice this question →
8
Multi-Selectmedium

A data analyst is creating a dashboard to display monthly sales trends for the past two years. The dataset includes monthly sales figures with seasonal fluctuations. The analyst wants to highlight both the overall trend and the seasonal patterns effectively. Which TWO chart types are most appropriate for this purpose? (Select two.)

Select 2 answers
A.Line chart
B.Stacked area chart
C.Scatter plot
D.Bar chart
E.Pie chart
AnswersA, D

Correct. Line charts are ideal for showing trends over time, such as monthly sales trends.

Why this answer

A line chart (A) clearly shows the overall trend over time, while a bar chart (C) allows easy comparison of monthly values, revealing seasonal peaks and troughs. A pie chart (B) is for parts of a whole and not suitable for trends. A scatter plot (D) is for correlations, not time series.

A stacked area chart (E) can show cumulative trends but makes individual monthly comparisons difficult.

Practice this question →
9
MCQmedium

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?

A.Change bar colors to gradient
B.Apply a logarithmic scale on the y-axis
C.Add more horizontal gridlines
D.Use a 3D bar chart for depth
AnswerB

Log scale compresses wide ranges so differences are visible.

Why this answer

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.

Exam trap

CompTIA often tests the misconception that adding decorative elements (like colors or 3D effects) improves readability, when the real issue is the scale of the data, and candidates may overlook the logarithmic scale as a legitimate axis transformation.

How to eliminate wrong answers

Option A is wrong because changing bar colors to a gradient does not address the scale disparity; it only adds visual noise without improving the comparability of bar heights. Option C is wrong because adding more horizontal gridlines does not change the axis scaling; it merely adds reference lines that do not help when the tall bars already dwarf the short ones. Option D is wrong because using a 3D bar chart introduces perspective distortion that can misrepresent the actual bar heights, making comparisons even more difficult rather than improving readability.

Practice this question →
10
Multi-Selecthard

A data analyst is troubleshooting a map visualization that shows null values for some regions. Which TWO actions should the analyst take to resolve the issue?

Select 2 answers
A.Check that latitude and longitude fields are properly geocoded.
B.Verify that the data source includes all region names.
C.Add a filter to exclude null values.
D.Change the mark type from Map to Pie.
E.Remove the color encoding from profit.
AnswersA, B

Improper geocoding can cause null regions; verifying geocoding resolves the issue.

Why this answer

Option B is correct because improper geocoding is a common cause of null values in map visualizations. Option D is correct if the data source lacks region names or has mismatches. Option A is wrong because changing mark type does not fix missing data.

Option C is wrong because removing color encoding hides the symptom but doesn't address the root cause. Option E is wrong because filtering out nulls may hide missing data issues instead of resolving them.

Practice this question →
11
MCQhard

A time series dataset has several missing months of data. Which chart type will present the most honest picture of the trend?

A.Area chart with interpolation
B.Line chart with gaps for missing months
C.Bar chart with zero values for missing months
D.Scatter plot with connected lines
AnswerB

Gaps indicate unknown values without interpolation.

Why this answer

Line charts with gaps explicitly show missing periods, avoiding false continuity.

Practice this question →
12
Multi-Selectmedium

Which TWO of the following chart types are appropriate for showing the distribution of a continuous variable? (Choose 2.)

Select 2 answers
A.Box plot
B.Bar chart
C.Pie chart
D.Line chart
E.Histogram
AnswersA, E

Shows distribution summary with quartiles and outliers.

Why this answer

A box plot is correct because it visually summarizes the distribution of a continuous variable through its five-number summary (minimum, first quartile, median, third quartile, maximum), clearly showing spread, central tendency, and potential outliers. This makes it ideal for distribution analysis in data visualization contexts like the DA0-001 exam.

Exam trap

The trap here is that candidates often confuse bar charts with histograms, mistakenly thinking bar charts can show continuous distributions, but bar charts require categorical x-axis values and have gaps between bars, while histograms use continuous intervals with no gaps.

Practice this question →
13
MCQmedium

A data analyst is tasked with visualizing the distribution of customer ages across different regions. The dataset contains outliers. Which chart type best displays the distribution and highlights outliers?

A.Box plot
B.Violin plot
C.Histogram
D.Bar chart
AnswerA

Box plot displays distribution spread and outliers as individual points beyond whiskers.

Why this answer

A box plot explicitly shows median, quartiles, and outliers, making it ideal for distribution and outlier detection. Histogram shows distribution but not outliers clearly. Violin plot is similar but more complex.

Bar chart is not for distribution.

Practice this question →
14
MCQeasy

An analyst creates a pie chart showing market share of four companies: A (45%), B (30%), C (15%), D (10%). A stakeholder complains that it is difficult to compare C and D. Which alternative chart should the analyst recommend?

A.Horizontal bar chart
B.Line chart
C.Stacked bar chart
D.Scatter plot
AnswerA

Horizontal bar chart allows easy length comparison between categories.

Why this answer

A bar chart allows easier comparison of individual values, especially when differences are small. The pie chart's reliance on angles makes small slices hard to compare. Options A, B, and D are not as effective for comparing discrete values.

Practice this question →
15
Multi-Selectmedium

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

Select 2 answers
A.Avoid using more than five slices in a pie chart
B.Maximize data-ink ratio by removing all whitespace
C.Always include gridlines with high contrast
D.Use 3D effects to make charts look professional
E.Use color to represent data values consistently
AnswersA, E

Too many slices make pie charts unreadable.

Why this answer

Option A is correct because 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.

Exam trap

CompTIA often tests the misconception that maximizing data-ink ratio means eliminating all whitespace, when in fact whitespace is a critical design element for readability and should be preserved judiciously.

Practice this question →
16
MCQeasy

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?

A.Scatter plot
B.Pie chart
C.Bar chart
D.Line chart
AnswerA

Scatter plots are used to display the relationship between two continuous variables.

Why this answer

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.

Exam trap

The trap here is that candidates often choose a line chart (Option D) because they mistakenly think 'relationship' implies a trend over time, but line charts require a sequential or time-based x-axis, not two independent continuous variables.

How to eliminate wrong answers

Option B (Pie chart) is wrong because pie charts are designed to show proportions of a whole for categorical data, not the relationship between two continuous variables. Option C (Bar chart) is wrong because bar charts compare discrete categories or aggregated values, not the direct correlation between two continuous numeric fields. Option D (Line chart) is wrong because line charts are typically used to show trends over time or ordered sequences, not the general relationship between two independent continuous variables.

Practice this question →
17
Multi-Selecthard

Which THREE of the following are common mistakes when creating data visualizations? (Choose 3.)

Select 3 answers
A.Choosing the correct chart type for the data
B.Using a 3D pie chart
C.Labeling axes clearly
D.Using a non-zero baseline for bar charts
E.Truncating the y-axis to exaggerate differences
AnswersB, D, E

3D distorts angles and makes comparison harder.

Why this answer

Option B is correct because 3D pie charts distort the perception of proportions by adding a false depth dimension, making it difficult for viewers to accurately compare slice sizes. This violates the principle of data-ink ratio and is widely discouraged in data visualization best practices.

Exam trap

CompTIA often tests the misconception that adding visual flair (like 3D effects) improves a chart, when in reality it reduces accuracy; the trap here is that candidates may think 3D pie charts are acceptable because they look 'professional' or 'modern'.

Practice this question →
18
Multi-Selecteasy

Which TWO color choices are appropriate for a categorical data visualization? (Select two.)

Select 2 answers
A.Distinct hues
B.Sequential color scheme
C.Monochrome
D.Rainbow gradient
E.Colorblind-friendly palette
AnswersA, E

Distinct hues clearly separate categories.

Why this answer

Distinct hues (A) are appropriate for categorical data because they use different colors to represent distinct categories without implying any order or magnitude. This aligns with best practices in data visualization where categorical variables require qualitative color schemes that maximize perceptual separation between groups.

Exam trap

CompTIA often tests the misconception that any color scheme can be used for any data type, but the trap here is confusing sequential or rainbow schemes (which imply order) with categorical data that requires distinct, unordered hues.

Practice this question →
19
MCQmedium

A company needs to visualize monthly sales revenue for the past five years to identify seasonal trends. Which chart type is most appropriate?

A.Line chart with months on the x-axis and revenue on the y-axis
B.Stacked bar chart showing each year as a segment
C.Scatter plot with revenue vs. month number
D.Pie chart for each year showing revenue distribution
AnswerA

Line chart is best for displaying continuous data over time and highlighting trends.

Why this answer

Option B (Line chart) is correct because line charts are ideal for showing trends over time. Option A (Bar chart) could work but is less effective for continuous time series. Option C (Pie chart) is for proportions, not trends.

Option D (Scatter plot) is for relationships between two variables.

Practice this question →
20
MCQmedium

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?

A.Use a sequential color scale with more contrast
B.Increase the number of color steps
C.Switch to a diverging color scale
D.Change to a single hue gradient
AnswerC

Diverging scale uses two contrasting colors from a midpoint, making differences more apparent.

Why this answer

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.

Practice this question →
21
MCQeasy

A data analyst is designing a dashboard for executives. Which best practice should be followed regarding the placement of key performance indicators (KPIs)?

A.Include as many charts as possible on a single screen to avoid scrolling
B.Hide KPIs behind filters to reduce initial load time
C.Use distinct colors to highlight all KPIs equally
D.Place the most important KPIs in the top-left corner
AnswerD

Users typically scan from top-left, so important metrics should be placed there.

Why this answer

Option C is correct because placing the most important KPIs at the top-left follows natural reading patterns. Option A is wrong because cramming many charts reduces readability. Option B is wrong because color coding alone is insufficient.

Option D is wrong because hiding KPIs defeats the purpose.

Practice this question →
22
MCQmedium

A data analyst creates a dashboard showing average order value by region. The chart indicates that one region has an unusually high average. Investigation reveals that the region has very few orders, but one large purchase inflates the average. Which data transformation should the analyst apply to improve the visualization?

A.Apply logarithmic scaling to the y-axis
B.Use median instead of mean for aggregation
C.Change the chart type to a pie chart
D.Remove all outliers from the dataset
AnswerB

Median is less sensitive to outliers than mean.

Why this answer

Option A is correct because using an appropriate aggregation like median or grouping with sufficient data can mitigate the impact of outliers. Other options do not address the root cause.

Practice this question →
23
MCQmedium

A retail company with 500 stores across North America wants to visualize its sales performance. The dataset includes store ID, region (Northeast, Southeast, Midwest, West), product category (Electronics, Clothing, Home Goods), monthly sales (in dollars), and date (from January 2018 to December 2023). The data has missing values for about 5% of store-month combinations, and a few stores have reported sales that are 10 times higher than the average for their region due to grand opening events. The goal is to create a dashboard that shows monthly sales trends for each region and product category, and allows users to identify which categories are driving growth. Which approach should the analyst take?

A.Use a stacked bar chart showing total sales by month, with each bar segmented by region and category
B.Create a line chart with month on the x-axis, sales on the y-axis, and separate lines for each region and category; check for outliers and consider annotating them
C.Create a scatter plot of sales vs. month with dots colored by region
D.Remove all stores with outlier sales and then create a line chart of the cleansed data
AnswerB

Line charts excel at showing trends over time; grouping by region and category allows comparison; outliers should be investigated and annotated, not removed.

Why this answer

Option A is correct because using a line chart with time on x-axis and grouping by region and category shows trends clearly. Handling outliers separately (e.g., annotation) preserves data integrity. Option B is wrong because combining all categories in a stacked bar makes it hard to see individual trends.

Option C is wrong because removing outliers discards valid grand opening data. Option D is wrong because a scatter plot is not appropriate for time series.

Practice this question →
24
MCQhard

The exhibit shows a SQL query result intended for a bar chart of revenue by region. However, the chart shows only the top 10 regions, but the query returns all regions. What is the most likely cause?

A.The GROUP BY clause is incorrect
B.The visualization tool has a default limit on the number of categories displayed
C.The query is missing a WHERE clause
D.The ORDER BY clause is ignored in the chart
AnswerB

Many tools limit categories to avoid clutter unless configured otherwise.

Why this answer

The query has no LIMIT clause, so it returns all rows. The chart tool must have a built-in limit. Option A is correct because the data is not truncated, but the visualization tool may be set to show only top 10.

Options B, C, and D are incorrect because the query is correct and order is applied.

Practice this question →
25
MCQmedium

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?

A.The maximum value of the gauge is set too high
B.The gauge updates too slowly
C.The gauge uses green for all values
D.The gauge needle is too small
AnswerA

If max is high, actual value appears as a smaller percentage than reality.

Why this answer

When a gauge always shows near 100% despite low inventory, the most likely cause is that the maximum value of the gauge is set too high. For example, if the gauge's maximum is configured as 10,000 units but the actual inventory never exceeds 100 units, even a small absolute value will appear as a high percentage. This scaling mismatch makes the gauge misleading because it fails to reflect the true relative state of the inventory.

Exam trap

The trap here is that candidates may focus on visual or performance issues (like update speed or color) instead of recognizing that the gauge's scale configuration is the root cause of the misleading percentage display.

How to eliminate wrong answers

Option B is wrong because a slow update rate would cause stale data, not a consistently high reading; the gauge would eventually show the correct low value after refreshing. Option C is wrong because using green for all values is a color-coding issue that affects interpretation of thresholds, not the gauge's percentage calculation or scale. Option D is wrong because the needle size is a visual design choice that does not impact the underlying data representation or the percentage value displayed.

Practice this question →
26
MCQmedium

An executive dashboard needs to display key performance indicators (KPIs) such as sales growth and customer satisfaction. Which design principle is most important?

A.Consistent color encoding for similar metrics
B.Use gauges for each KPI
C.Include all raw data in the dashboard
D.Animate charts to draw attention
AnswerA

Consistent colors reduce cognitive load and improve interpretation.

Why this answer

Consistent color coding helps viewers quickly associate colors with metrics across multiple charts.

Practice this question →
27
MCQhard

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?

A.The chart should group departments by region to reduce variance
B.The y-axis does not start at zero; reset it to zero
C.The data should be visualized as a line chart instead
D.The bar chart should be replaced with a 3D version for better depth
AnswerB

Starting the axis at zero prevents misleading comparisons; non-zero start exaggerates differences.

Why this answer

Option A is correct because a truncated y-axis can exaggerate differences, and starting at zero provides accurate perspective. Option B is wrong because changing chart type doesn't fix the axis issue. Option C is wrong because 3D charts distort perception.

Option D is wrong because outliers should be handled properly, not necessarily by truncating.

Practice this question →
28
MCQeasy

A company needs to visualize the trend of monthly sales revenue over the past two years. Which chart type is most appropriate?

A.Bar chart
B.Scatter plot
C.Line chart
D.Pie chart
AnswerC

Line charts excel at displaying trends over continuous time.

Why this answer

Option B is correct because line charts are best for showing trends over time. Option A (pie) is for parts of a whole; Option C (scatter) is for relationships between variables; Option D (bar) compares categories but not trends as clearly.

Practice this question →
29
MCQhard

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?

A.Switch to a diverging color scheme with a neutral center
B.Remove all but the highest and lowest values
C.Add black borders around each cell
D.Increase the size of each heatmap cell
AnswerA

Diverging palettes highlight midpoints and differentiate values better.

Why this answer

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.

Exam trap

The trap here is that candidates often think adding visual elements (borders or size) or filtering data will fix color perception issues, when the core problem is the color scheme's inability to represent moderate values distinctly.

How to eliminate wrong answers

Option B is wrong because removing all but the highest and lowest values discards the majority of the data, destroying the heatmap's purpose of showing the full distribution of click-through rates. Option C is wrong because adding black borders around each cell improves cell separation but does not address the perceptual compression of moderate values in the color gradient. Option D is wrong because increasing cell size only enhances readability of individual cells, not the discriminability of color values within the gradient.

Practice this question →
30
Multi-Selectmedium

Which TWO chart types are best suited for visualizing the distribution of a single continuous variable? (Select two.)

Select 2 answers
A.Scatter plot
B.Box plot
C.Line chart
D.Histogram
E.Pie chart
AnswersB, D

Box plot summarizes distribution with median, quartiles, and outliers.

Why this answer

Histogram shows frequency bins; box plot shows quartiles and outliers.

Practice this question →
31
MCQeasy

A dashboard designer needs to ensure that color choices are accessible to users with color vision deficiencies. Which practice should be followed?

A.Use a rainbow color palette to maximize differentiation
B.Convert all charts to grayscale
C.Use red and green to indicate positive and negative values
D.Combine color with patterns or labels to convey information
AnswerD

Using patterns or text alongside color ensures accessibility.

Why this answer

Option C is correct because patterns or shapes provide alternative ways to distinguish data. Option A is wrong as relying only on hue is problematic. Option B is wrong because grayscale loses emphasis.

Option D is wrong as specific colors like red-green are problematic for some.

Practice this question →
32
MCQeasy

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

A.Bar chart
B.Line chart
C.Pie chart
D.Scatter plot
AnswerD

Scatter plots reveal relationships between two variables.

Why this answer

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.

Exam trap

The trap here is that candidates often choose a line chart because they mistakenly think 'correlation' implies a trend over time, but the DA0-001 exam specifically tests that scatter plots are the standard for bivariate correlation analysis without a temporal component.

How to eliminate wrong answers

Option A is wrong because a bar chart is used to compare categorical data or discrete values, not to show the relationship between two continuous variables; it would obscure the correlation pattern. Option B is wrong because a line chart is best for displaying trends over time or sequential data, not for revealing the correlation between two independent continuous variables; it implies a temporal order that may not exist. Option C is wrong because a pie chart is designed to show proportions of a whole for categorical data, making it completely unsuitable for visualizing the correlation between two numeric variables.

Practice this question →
33
MCQeasy

A company wants to show the number of products sold across different categories: Electronics, Clothing, Home Goods, and Books. Which chart type is most appropriate?

A.Bar chart
B.Scatter plot
C.Line chart
D.Pie chart
AnswerA

Bar chart effectively compares categories.

Why this answer

Bar chart is ideal for comparing categorical data across distinct groups.

Practice this question →
34
MCQhard

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?

A.Increase the chart canvas size
B.Set bubble opacity to 70%
C.Reduce all bubble sizes uniformly
D.Remove outlier countries with large populations
AnswerB

Transparency allows seeing through overlapping bubbles.

Why this answer

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.

Exam trap

The trap here is that candidates often choose to reduce bubble sizes uniformly (Option C) thinking it solves overlap, but this distorts the proportional encoding of population, whereas opacity preserves the original data relationships while improving visibility.

How to eliminate wrong answers

Option A is wrong because increasing the canvas size does not resolve the fundamental issue of overlapping bubbles; it only spreads them out slightly, and large bubbles will still obscure others if their sizes are disproportionate. Option C is wrong because uniformly reducing all bubble sizes changes the visual encoding of population, potentially making small populations invisible and distorting the data's relative comparison. Option D is wrong because removing outlier countries with large populations eliminates valid data points, which introduces bias and violates the principle of representing the full dataset; the goal is to visualize all data, not discard it.

Practice this question →
35
Matchingmedium

Match each data analysis tool to its primary function.

Drag a concept onto its matching description — or click a concept then click the description.

Concepts
Matches

Query and manipulate structured data in databases

General-purpose language for data analysis and modeling

Statistical computing and graphics

Interactive data visualization and dashboards

Spreadsheet for data manipulation and basic analysis

Why these pairings

These are common tools used by data analysts.

Practice this question →
36
MCQhard

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?

A.Replace the pie chart with a stacked bar chart and use a categorical color scheme for the bar chart
B.Explode the Sports slice in the pie chart and use a monochromatic color scheme for the bar chart
C.Change the pie chart to a 3D pie chart and use a diverging color scheme for the bar chart
D.Group small categories into an 'Other' slice in the pie chart and use a sequential color scheme ordered by sales for the bar chart
AnswerD

Grouping small categories improves pie readability; sequential colors ordered by magnitude helps bar comparison.

Why this answer

Option D is correct because 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.

Exam trap

CompTIA often tests the misconception that simply highlighting or separating a small slice (exploding or 3D) fixes pie chart readability, when in fact it does not address the fundamental issue of angle comparison for tiny values.

How to eliminate wrong answers

Option A is wrong because replacing the pie chart with a stacked bar chart does not solve the problem of a barely visible category; it may still compress small values into thin segments, and a categorical color scheme for the bar chart does not order colors by magnitude, leaving the comparison of bar heights difficult. Option B is wrong because exploding the Sports slice in the pie chart only draws attention to it without improving the overall readability of the pie chart for small slices, and a monochromatic color scheme for the bar chart lacks the ordered intensity needed to compare bar heights effectively. Option C is wrong because a 3D pie chart distorts proportions and makes interpretation even harder, and a diverging color scheme is designed for data with a meaningful midpoint (e.g., positive/negative values), not for ordering bars by magnitude.

Practice this question →
37
MCQmedium

An executive dashboard must display high-level KPIs such as current revenue, profit margin, and customer count. Which visualization type is most appropriate for each KPI?

A.Pie chart
B.Sparkline for each KPI
C.KPI card showing value and variance
D.Gauge chart
AnswerC

KPI cards provide an immediate, straightforward view of a key metric.

Why this answer

Option D is correct because KPI cards (or tiles) display a single metric clearly and concisely. Other options are less effective for immediate understanding.

Practice this question →
38
Multi-Selecthard

Which THREE actions improve the accessibility of data visualizations for users with visual impairments? (Select exactly three.)

Select 3 answers
A.Provide text alternatives for charts (e.g., data tables).
B.Use only color to convey information.
C.Use clear and descriptive labels.
D.Ensure sufficient color contrast.
E.Add animated transitions between views.
AnswersA, C, D

Text alternatives allow screen readers to convey information.

Why this answer

Options B, C, and D are correct. Clear labels help all users; text alternatives allow screen readers; sufficient contrast improves readability. Using only color (A) excludes colorblind users; animation (E) can be distracting and not accessible.

Practice this question →
39
MCQhard

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?

A.Combine small categories into an 'Other' group
B.Change to a pie chart for each quarter
C.Increase the width of each bar
D.Switch to a 3D stacked column chart
AnswerA

Grouping small items simplifies the chart and improves readability.

Why this answer

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.

Exam trap

The trap here is that candidates often think adding more visual elements (3D, wider bars) or changing chart types (pie) will fix readability, when the real solution is data aggregation to reduce cognitive load.

How to eliminate wrong answers

Option B is wrong because using a pie chart for each quarter does not solve the problem of small categories; it merely shifts the same issue to a different chart type, where tiny slices are even harder to compare across quarters. Option C is wrong because increasing bar width does not address the core problem of too many small segments; it only stretches the visual horizontally without reducing the number of categories. Option D is wrong because switching to a 3D stacked column chart introduces perspective distortion and occlusion, making small contributions even more difficult to discern and violating best practices for accurate data visualization.

Practice this question →
40
MCQhard

An IT operations team monitors 200 servers. Each server reports CPU utilization (0-100%) every five minutes for the past year. The team wants to visualize the data to identify servers that are consistently over 80% utilization and detect any unusual spikes. They have a large dataset with 100,000+ records per server. The current visualization is a single scatter plot with CPU utilization on the y-axis, time on the x-axis, and each server as a different colored point. The chart is extremely cluttered, with points overlapping and colors indistinguishable. What should the team do to improve the visualization?

A.Use a heatmap showing CPU utilization over time per server, or create small multiple charts (one per server)
B.Switch to a line chart with each server as a separate line
C.Add a trend line to each server's data and remove the individual points
D.Increase the size of the data points to make them more visible
AnswerA

Heatmaps compactly show high-density data; small multiples allow per-server trend analysis without overlapping.

Why this answer

Option D is correct because using heatmaps or small multiples (trellis charts) reduces clutter for high-density data. Option A is wrong because increasing marker size worsens overlap. Option B is wrong because a single line chart would be even more cluttered with 200 lines.

Option C is wrong because trend lines remove detail needed for spike detection.

Practice this question →
41
MCQmedium

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?

A.The map projection is distorted
B.The color scale uses a sequential palette with insufficient contrast
C.The monitor resolution is too low
D.Users are color blind
AnswerB

Sequential palettes can have low perceptual difference between adjacent values.

Why this answer

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.

Exam trap

The trap here is that candidates may attribute the problem to hardware limitations (monitor resolution) or user physiology (color blindness) rather than recognizing it as a fundamental data visualization design flaw in the color scale selection.

How to eliminate wrong answers

Option A is wrong because map projection distortion affects the shape and area of regions, not the color intensity used to represent sales values. Option C is wrong because monitor resolution affects the sharpness of the display, not the perceived color difference between two distinct data values on the same screen. Option D is wrong because while color blindness can cause confusion between certain colors, the complaint is that two regions with very different sales appear nearly the same color, which points to a scale design issue rather than a user vision deficiency.

Practice this question →
42
Multi-Selectmedium

Which TWO actions will improve the readability of a bar chart showing quarterly sales across five regions?

Select 2 answers
A.Overlay a line chart showing cumulative sales
B.Sort bars in descending order of sales
C.Add data labels on top of each bar
D.Add vertical gridlines for every bar
E.Switch to a 3D bar chart to add visual depth
AnswersB, C

Sorted bars make it easy to identify largest and smallest values.

Why this answer

Options B and D are correct. Sorting bars by sales (B) helps compare values easily. Adding data labels (D) provides exact numbers.

Option A is wrong because a 3D chart distorts perception. Option C is wrong because a vertical gridline pattern can clutter. Option E is wrong because a line chart on the same axis mixes data types.

Practice this question →
43
MCQeasy

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?

A.Use a bar chart to show average sales per advertising spend bin.
B.Add a trend line using linear regression to the current scatter plot.
C.Remove the outlier and recreate the scatter plot.
D.Change the chart type to a line chart.
AnswerC

Correct. Removing the erroneous data point ensures the scatter plot reflects the true relationship.

Why this answer

Option A is correct. Since the outlier is confirmed to be a data entry error, it should be removed or corrected before creating a new scatter plot. Option B is incorrect: a line chart would not be appropriate because the data is not a time series (it's just ordered pairs, not sequential over time).

Option C is incorrect: adding a trend line to the current plot would still be influenced by the erroneous outlier. Option D is incorrect: creating bins would hide the outlier but not address the data quality issue, and it may obscure the relationship.

Practice this question →
44
Multi-Selectmedium

Which TWO of the following are best practices for designing an accessible data visualization? (Choose 2.)

Select 2 answers
A.Add text labels or patterns to differentiate elements
B.Rely solely on color to convey information
C.Use 3D effects to make charts visually appealing
D.Include animated transitions between views
E.Use colorblind-friendly color palettes
AnswersA, E

Provides alternative means to distinguish data.

Why this answer

Using colorblind-friendly palettes and adding text labels/patterns make charts accessible. Relying solely on color or using 3D effects reduces accessibility. Adding animation distracts.

Practice this question →
45
MCQhard

A heat map of store sales by region shows very low correlation between advertising spend and revenue, but a scatter plot of the same data shows a strong positive relationship. What is the most likely cause?

A.Data was aggregated incorrectly in the heat map
B.The heat map used an incorrect color scale
C.Outliers were removed only for the scatter plot
D.The chart types are inherently incompatible
AnswerA

Averaging within bins can reduce variability and hide correlations.

Why this answer

Heat maps often aggregate data into bins (e.g., averages), which can mask the underlying relationship.

Practice this question →
46
MCQmedium

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?

A.The analyst's username is not in the users list
B.The analyst lacks write permission
C.The analyst lacks read permission
D.JSON syntax error prevents parsing
AnswerA

Only 'admin' and 'analyst' have access.

Why this answer

The policy lists only 'admin' and 'analyst'; 'analyst2' is not included, so access is denied.

Practice this question →
47
MCQeasy

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?

A.Scatter plot
B.Pie chart
C.Line chart
D.Bar chart
AnswerC

Line charts display trends over time effectively.

Why this answer

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.

Exam trap

CompTIA often tests the misconception that a bar chart is suitable for time-series data, but bar charts are better for comparing distinct categories or aggregated values (e.g., average CPU per hour) rather than showing the continuous flow of data points over time.

How to eliminate wrong answers

Option A is wrong because a scatter plot is used to show the relationship between two numerical variables (e.g., CPU usage vs. memory usage), not to display a single variable's trend over time. Option B is wrong because a pie chart is designed to show parts of a whole (proportions) at a single point in time, making it unsuitable for tracking changes across 24 hours. Option D is wrong because a bar chart compares discrete categories or values at specific intervals but does not effectively convey continuous trends or the rate of change over time as a line chart does.

Practice this question →
48
MCQhard

A data analyst needs to visualize sales per capita across U.S. states. States with small populations but high sales (e.g., Delaware) appear too prominent on a choropleth map. Which technique best addresses this issue?

A.Switch to a bar chart sorted by sales
B.Use a choropleth map with rates instead of raw sales
C.Use a bubble chart with size proportional to sales
D.Apply a log scale to the color gradient
AnswerB

Choropleth mapping rates (e.g., per capita) normalizes geographic areas.

Why this answer

Option D is correct because a choropleth map adjusted for per-capita values properly normalizes by population. Other options either do not normalize or distort the data.

Practice this question →
49
MCQeasy

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?

A.Line chart
B.Pie chart
C.Scatter plot
D.Histogram
AnswerD

Histograms display frequency distribution of numerical data.

Why this answer

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.

Exam trap

CompTIA often tests the trap that candidates confuse a histogram with a bar chart, thinking a bar chart can show distribution, but a bar chart is for categorical data while a histogram is for continuous data binned into intervals.

How to eliminate wrong answers

Option A is wrong because a line chart is designed to show trends over time or ordered categories, not the distribution of a single continuous variable like test scores. Option B is wrong because a pie chart shows proportions of a whole for categorical data, and using it for 500 continuous test scores would obscure the distribution shape entirely. Option C is wrong because a scatter plot displays the relationship between two numerical variables, not the univariate distribution of a single variable.

Practice this question →
50
MCQhard

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?

A.Create a line chart with Date on the x-axis and MPG on the y-axis, with separate lines for each driver.
B.Create a box plot grouped by DriverID showing the distribution of MPG for each driver.
C.Create a scatter plot with Distance on the x-axis and FuelUsed on the y-axis, color-coded by DriverID.
D.Create a bar chart showing the average MPG for each driver.
AnswerB

A box plot shows median, quartiles, and outliers, allowing comparison of both central tendency and variability.

Why this answer

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).

Exam trap

The trap here is that candidates often choose a bar chart (Option D) because it shows averages, but they overlook the requirement to also see consistency, which only a box plot or violin plot can provide in a single visualization.

How to eliminate wrong answers

Option A is wrong because a line chart with Date on the x-axis and MPG on the y-axis would show trends over time for each driver, but it does not directly compare average efficiency or consistency across drivers; it would be cluttered with 10,000 points and multiple lines, making it hard to assess overall performance. Option C is wrong because a scatter plot of Distance vs. FuelUsed color-coded by DriverID shows the relationship between distance and fuel consumption, but it does not directly display average MPG or the distribution of MPG per driver; consistency would require visual inspection of point clusters, which is inefficient for 10,000 records.

Option D is wrong because a bar chart showing only the average MPG for each driver omits information about consistency; management cannot see how variable each driver's efficiency is, which is a key requirement.

Practice this question →
51
MCQhard

A data visualization specialist needs to display the relationship between advertising spend and revenue for 50 product categories over 12 months. The data has many overlapping points. Which chart type best reveals the correlation and density?

A.Heatmap with revenue binned
B.Line chart for each category
C.Bubble chart
D.Scatter plot with alpha blending
AnswerD

Transparency allows overlapping points to show density while preserving the relationship.

Why this answer

A scatter plot with transparency (alpha blending) reveals both correlation and point density by showing overlapping points as darker areas. A bubble chart adds a third variable. A heatmap on a grid loses resolution.

A line chart is not for correlation.

Practice this question →
52
MCQmedium

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?

A.A dual-axis chart with bars for actual and budget by month for each department, and a line for variance
B.A waterfall chart showing cumulative variance over the year
C.A table with conditional formatting to highlight over-budget cells
D.Stacked bar chart with one bar per month, segments showing each department's actual and budget
AnswerA

Dual-axis allows direct comparison of actual vs budget over time, and the line highlights variance trend.

Why this answer

Option B is correct because a dual-axis chart (bars for budget vs actual per month, line for variance) shows both comparison and trend clearly. Option A is wrong because a single stacked bar for all departments obscures monthly trends. Option C is wrong because a table is not a quick-visual overview.

Option D is wrong because a waterfall chart is for cumulative changes, not month-by-month trends.

Practice this question →
53
MCQmedium

A scatter plot of advertising spend vs. revenue shows no clear correlation, but the analyst suspects a relationship exists. Which addition to the plot could help reveal a hidden trend?

A.Change to a bar chart
B.Increase the marker size
C.Remove data points with low spend
D.Add a trendline
AnswerD

A trendline helps model and visualize the underlying relationship.

Why this answer

Option A is correct because adding a trendline (e.g., linear regression) can reveal patterns in noisy data. Other options may obscure or not address the issue.

Practice this question →
54
Multi-Selectmedium

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

Select 2 answers
A.Use 3D charts for visual appeal.
B.Use pie charts for comparing parts of a whole.
C.Include every possible metric to provide completeness.
D.Use a single page to avoid scrolling.
E.Use a consistent color scheme across visualizations.
AnswersD, E

A single page allows immediate overview.

Why this answer

Options A and C are correct. A single-page dashboard provides an at-a-glance view, and consistent color schemes improve readability. 3D charts (B) can distort perception; including every metric (D) clutters; pie charts (E) are often misused.

Practice this question →
55
MCQeasy

An analyst creates a dashboard with multiple visualizations. Which feature allows users to change the data displayed across all charts simultaneously?

A.Linked chart
B.Drill-down
C.Filter or slicer
D.Data segmentation
AnswerC

Filters and slicers allow users to interactively change the data displayed on multiple charts.

Why this answer

Option D is correct because a filter (or slicer) can apply to multiple visuals. Option A is for limited data view. Option B is a chart type.

Option C is dividing data into segments.

Practice this question →
56
Multi-Selectmedium

Which TWO chart types are best suited to show the proportion of total sales contributed by each product category? (Select exactly two.)

Select 2 answers
A.Histogram
B.Scatter plot
C.Stacked bar chart
D.Pie chart
E.Line chart
AnswersC, D

Stacked bars show composition across categories.

Why this answer

Options B and C are correct. Pie charts and stacked bar charts effectively show parts of a whole. Line charts show trends; scatter plots show relationships; histograms show distributions.

Practice this question →
57
MCQeasy

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

A.Pie chart
B.Stacked bar chart
C.Line chart
D.Bar chart
AnswerD

Bar charts effectively compare discrete values like growth percentages.

Why this answer

Option C is correct because a bar chart comparing growth percentages across categories is clear and straightforward. Other options are less effective for comparing discrete metrics.

Practice this question →
58
MCQhard

A sales dashboard shows a map with many overlapping markers in the same city, making it hard to read. What is the best improvement?

A.Add tooltips to show details on hover
B.Aggregate the data by region and use a choropleth map
C.Use a bubble chart instead of a map
D.Use different marker colors for each store
AnswerB

Aggregating reduces density and choropleth shows region-level values.

Why this answer

Option B is correct because aggregating sales data by region and using a choropleth map eliminates visual clutter from overlapping markers by shading entire geographic areas based on a metric (e.g., total sales). This approach leverages spatial aggregation to provide a clear, high-level view of regional performance, which is the best practice when individual point markers become unreadable due to density.

Exam trap

The trap here is that candidates may choose tooltips (Option A) thinking interactivity solves the problem, but the question asks for the 'best improvement' to readability, and tooltips do not address the fundamental issue of overlapping markers obscuring the visualization.

How to eliminate wrong answers

Option A is wrong because tooltips only provide details on hover and do not solve the core problem of overlapping markers obscuring data; they add interactivity but do not reduce visual density. Option C is wrong because a bubble chart, while useful for comparing values, is not a map-based visualization and would lose the geographic context that the dashboard intends to convey. Option D is wrong because using different marker colors for each store does not address overlapping markers; it only adds visual differentiation without reducing clutter, and in dense areas, colored markers still overlap and remain unreadable.

Practice this question →
59
MCQmedium

A data analyst needs to compare the salary distribution across five departments. Which visualization is most appropriate?

A.Line chart
B.Side-by-side box plot
C.Scatter plot
D.Stacked bar chart
AnswerB

Box plots display distribution statistics for each group.

Why this answer

A side-by-side box plot (option B) is the most appropriate visualization for comparing salary distributions across multiple departments because it displays the median, quartiles, and potential outliers for each group simultaneously. This allows the analyst to assess central tendency, spread, and skewness across all five departments in a single, compact chart.

Exam trap

The trap here is that candidates often confuse 'comparing distributions' with 'showing trends' or 'showing relationships,' leading them to incorrectly select a line chart or scatter plot instead of recognizing that a box plot is purpose-built for distribution comparison across groups.

How to eliminate wrong answers

Option A is wrong because a line chart is designed to show trends over a continuous interval (e.g., time series) and is not suitable for comparing distributions of categorical groups like departments. Option C is wrong because a scatter plot visualizes the relationship between two continuous variables, not the distribution of a single variable across categories. Option D is wrong because a stacked bar chart is used to show the composition of parts to a whole across categories, not the distribution (e.g., quartiles, outliers) of a continuous variable like salary.

Practice this question →
60
MCQeasy

A marketing team wants to explore the relationship between advertising spend (in dollars) and resulting revenue. Which chart type is most suitable?

A.Line chart
B.Table
C.Pie chart
D.Scatter plot
AnswerD

Scatter plot displays relationship between two numerical variables.

Why this answer

Scatter plots reveal correlation and distribution of two continuous variables.

Practice this question →
61
MCQeasy

A marketing team conducted a customer satisfaction survey for five different departments (Sales, Support, Billing, Shipping, Returns). The survey asked customers to rate their satisfaction on a scale of 1 (Very Dissatisfied) to 5 (Very Satisfied). The data is ordinal and the team wants to visualize the distribution of responses for each department to quickly see which department has the most 'Very Satisfied' customers and which has the most 'Very Dissatisfied'. They also want to compare the spread of responses across departments. Which chart type should they use?

A.Stacked bar chart with departments on x-axis and counts of each rating stacked
B.Line chart with departments on x-axis and average rating on y-axis
C.Box plot for each department
D.Scatter plot with department as category and satisfaction score as value
AnswerA

Stacked bars show the full distribution of ordinal responses, highlighting proportions of top and bottom ratings.

Why this answer

Option C is correct because a stacked bar chart can show the proportion of each rating for each department, making it easy to see satisfaction levels. Option A is wrong because a box plot requires continuous data. Option B is wrong because a line chart is for trends.

Option D is wrong because a scatter plot is for relationships.

Practice this question →
62
MCQeasy

Refer to the exhibit. A stakeholder complains that the line chart exaggerates the changes in sales. What is the most likely cause?

A.The y-axis does not start at zero
B.There are too few data points
C.The data labels are incorrect
D.The chart type should be a bar chart
AnswerA

Starting at a non-zero value exaggerates differences.

Why this answer

Setting beginAtZero to false truncates the y-axis, making small changes appear larger.

Practice this question →
63
MCQeasy

A dashboard designer wants to highlight the sales performance of individual sales representatives compared to team averages. Which chart type is most suitable for this comparison?

A.Scatter plot
B.Bar chart with average line
C.Pie chart
D.Line chart
AnswerB

Bar chart allows easy comparison of each rep's sales to the average line.

Why this answer

A bar chart is ideal for comparing individual values to an average because it clearly shows the magnitude of each value relative to a reference line. Options B, C, and D are less suitable for direct comparison of multiple entities.

Practice this question →
64
Multi-Selecthard

Which THREE are best practices for designing a dashboard for executive consumption?

Select 3 answers
A.Include detailed raw data tables for transparency
B.Ensure the dashboard is responsive for mobile devices
C.Use a separate chart for each metric to avoid clutter
D.Provide interactive filters for time periods and regions
E.Display the most critical KPIs at the top
AnswersB, D, E

Executives often view dashboards on tablets or phones.

Why this answer

Options A, C, and E are correct. Prioritize key metrics (A), provide interactive filters (C), and ensure mobile responsiveness (E). Option B is wrong because daily updates may be too frequent and clutter the dashboard.

Option D is wrong because summary views are more useful for executives.

Practice this question →
65
MCQeasy

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

A.Pie chart
B.Histogram
C.Line chart
D.Box plot
AnswerC

Line chart clearly shows trends and seasonal patterns over time.

Why this answer

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.

Exam trap

The trap here is that candidates confuse a histogram with a line chart because both use bars or lines, but a histogram bins continuous data without regard to order, while a line chart requires a sequential axis like time to show trends.

How to eliminate wrong answers

Option A is wrong because a pie chart is designed to show parts of a whole at a single point in time, not trends across multiple time periods; it cannot convey seasonal patterns or month-over-month changes. Option B is wrong because a histogram displays the distribution of a continuous variable by binning values, but it does not preserve the temporal order of months, making it impossible to identify seasonal patterns. Option D is wrong because a box plot summarizes data distribution (median, quartiles, outliers) for one or more groups, but it lacks a time axis and cannot show the sequential progression of sales across months.

Practice this question →
66
Multi-Selecthard

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

Select 3 answers
A.The animation capabilities of the software
B.The data types (categorical, numerical, time series)
C.The number of variables to display
D.The key insight or message to convey
E.The color scheme of the company logo
AnswersB, C, D

Data type determines suitable chart types.

Why this answer

Option B is correct because 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.

Exam trap

The trap here is that candidates often confuse aesthetic or software-specific features (like animation or branding) with the fundamental data characteristics that dictate chart appropriateness, leading them to select options that are about polish rather than analytical correctness.

Practice this question →
67
MCQhard

A data scientist creates a box plot of employee salaries and notices many outliers above the upper whisker. What action should be taken to best understand the salary distribution?

A.Replace the box plot with a histogram of the salaries
B.Remove all outliers to create a more typical box plot
C.Trim the top 5% of salaries and recreate the box plot
D.Investigate the outliers to determine if they are data entry errors or valid extremes
AnswerD

Outliers should be investigated to ensure data quality and contextual understanding.

Why this answer

Option A is correct because investigating outliers may reveal legitimate high salaries or data errors. Option B is wrong because removing outliers without cause can bias results. Option C is wrong because trimming changes the distribution.

Option D is wrong because a histogram may not highlight outliers clearly.

Practice this question →
68
MCQmedium

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?

A.Change "aggregation" to "average"
B.Change the query to include a moving average
C.Change "interpolation" to "monotone"
D.Change chartType to "bar"
AnswerC

Monotone interpolation produces a smoother curve through points.

Why this answer

Setting interpolation to 'monotone' or 'smooth' can reduce jaggedness. The aggregation is already applied in the query, so changing it to 'average' in the widget would double-aggregate. Changing chart type or data source is not necessary.

Practice this question →
69
MCQmedium

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?

A.Histogram
B.Bar chart
C.Line chart
D.Scatter plot
AnswerD

Scatter plots are ideal for visualizing the correlation between two continuous variables.

Why this answer

Option D is correct because scatter plots show the relationship between two continuous variables. Option A is for categorical comparisons. Option B is for trends over time.

Option C is for frequency distribution.

Practice this question →
70
MCQeasy

The exhibit shows log entries. A data analyst wants to visualize the frequency of each error type over time. Which chart type is most appropriate?

A.Time series line chart
B.Bar chart of error types
C.Scatter plot of timestamp vs error code
D.Pie chart of error types
AnswerA

Shows frequency trend over time.

Why this answer

A time series line chart counts events per time interval, best for showing frequency over time. Bar chart of counts is static. Pie of error types ignores time.

Scatter plot not suitable.

Practice this question →
71
MCQeasy

A dashboard needs to show sales trends for each of five regions over the past year. The intended audience wants to compare trends easily. Which chart type is best?

A.Line chart with multiple lines
B.Pie chart
C.Stacked bar chart
D.Area chart
AnswerA

Multiple line charts clearly show each region's trend over time.

Why this answer

Option B is correct because multiple line chart lines allow comparison of trends across regions. A stacked bar would show composition, not trends.

Practice this question →
72
MCQmedium

A data analyst is designing a dashboard for executives. Which best practice should be followed?

A.Use 3D effects to make charts more engaging
B.Include every data point in the dashboard
C.Minimize clutter and use clear visual hierarchy
D.Use rainbow color palette to highlight all data points
AnswerC

Clean design improves readability and decision-making.

Why this answer

Reducing clutter helps viewers focus on key insights without distraction.

Practice this question →
73
Drag & Dropmedium

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

Drag steps to the numbered slots on the right, or tap a step then tap a slot.

Steps
Order

Why this order

Conflict resolution starts with identification, analysis, standardization, transformation, and merging.

Practice this question →
74
Multi-Selecthard

Which THREE are considered best practices in dashboard design? (Select three.)

Select 3 answers
A.Using heat maps to visualize correlation
B.Using 3D charts to add depth
C.Maximizing the data-ink ratio
D.Providing interactive filters for exploration
E.Including every data point in the dashboard
AnswersA, C, D

Heat maps effectively show correlation matrices.

Why this answer

Option A is correct because heat maps effectively visualize correlation by using color intensity to represent the strength of relationships between two variables, making patterns and outliers immediately apparent. This aligns with best practices for dashboard design, which prioritize clarity and rapid insight over decorative elements.

Exam trap

CompTIA often tests the misconception that adding visual flair (like 3D effects) or exhaustive data improves a dashboard, when in reality these choices degrade readability and violate core principles of effective data visualization.

Practice this question →
75
MCQhard

Refer to the exhibit. What is the best corrective action to resolve this error?

A.Convert the 'revenue' column to numeric data type during ETL
B.Change the chart type to a bar chart
C.Remove the 'revenue' column from the visualization
D.Use a string-compatible chart type
AnswerA

Casting to numeric solves the type mismatch.

Why this answer

The error indicates a data type mismatch; converting the column to numeric in the ETL process ensures compatibility.

Practice this question →
Page 1 of 2 · 84 questions totalNext →

Ready to test yourself?

Try a timed practice session using only Visualizing Data questions.

Start 20-question session