CCNA Visualization and Reporting Questions — Page 4 of 4

226

MCQmedium

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?

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

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

C.Set point opacity to 30% and use a qualitative color palette with distinct hues for each region

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

AnswerC

Reducing point opacity to 30% lets overlapping marks accumulate into darker density, revealing clusters across 10,000 points. A qualitative palette assigns each of the five regions a perceptually distinct hue, replacing the near-identical blues that currently prevent region differentiation.

Why this answer

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.

Exam trap

The trap here is that candidates often choose small multiples (Option B) thinking they reduce clutter, but the question specifically asks to improve differentiation and reduce overplotting in a single view, and small multiples fragment the data, making cross-region comparison harder.

How to eliminate wrong answers

Option A is wrong because a hexagonal binning plot aggregates points into hexagons based on density, but it cannot encode a categorical variable like region with color inside a single plot—hexbin typically uses a single color gradient for density, not multiple regions. Option B is wrong because creating five separate scatter plots (small multiples) forces users to mentally compare across separate charts, losing the ability to see relative spatial patterns and interactions between regions in a single view. Option D is wrong because converting to a bubble chart by adding package weight as bubble size does not reduce overplotting (it can worsen it with larger circles) and does not improve region differentiation; it introduces a third continuous variable that is not related to the reported issues.

Practice this question →

227

MCQhard

An analyst creates a dashboard with a large amount of decorative graphics and background images. According to CompTIA Data+, which design principle is being violated?

A.Visual hierarchy

B.Data-ink ratio

C.Appropriate precision

D.Consistent color coding

AnswerB

Decorative graphics and background images consume ink without conveying data, lowering the data-ink ratio that Tufte defines as data-ink divided by total ink. CompTIA Data+ expects dashboards to maximise this ratio by removing non-data pixels, so heavy ornamentation directly violates the principle the stem describes.

Why this answer

The data-ink ratio, a concept from Edward Tufte, states that a visualization should maximize the proportion of ink used to represent actual data relative to total ink used. By adding excessive decorative graphics and background images, the analyst reduces this ratio, making the dashboard less efficient and potentially obscuring the data. CompTIA Data+ emphasizes minimizing non-data ink to improve clarity and insight extraction.

Exam trap

The trap here is that candidates confuse 'decorative graphics' with 'visual hierarchy' or 'color coding,' but CompTIA Data+ specifically tests the data-ink ratio as a principle for minimizing non-data elements to enhance readability.

How to eliminate wrong answers

Option A is wrong because visual hierarchy refers to the arrangement of elements to guide the viewer's eye by importance, which is not directly violated by decorative graphics; the issue is about ink efficiency, not order. Option C is wrong because appropriate precision concerns the level of detail in data values (e.g., rounding or decimal places), not the use of decorative elements. Option D is wrong because consistent color coding ensures that colors have the same meaning across the dashboard, which is unrelated to the overuse of non-data ink.

Practice this question →

228

MCQmedium

A data analyst is building a dashboard for a regional sales director who needs to monitor daily performance across 12 territories. The director wants to instantly see which territories are below target, with the ability to click a territory to view its individual store details. The analyst decides to use a bullet chart for each territory. Which design choice best supports the director's need for immediate exception identification and drill-down?

A.Use a stacked bar chart with actual and target values stacked on top of each other, and add a tooltip showing the variance.

B.Replace the bullet charts with a single pie chart showing each territory's percentage of total sales.

C.Use a uniform color for all bullet charts and rely on the target marker position to indicate performance.

D.Apply a conditional color rule that highlights bullet charts in red when actual sales fall below the target, and enable drill-through to a store-level detail page.

AnswerD

Conditional coloring makes below-target territories immediately visible without reading each chart, and drill-through provides the requested store-level detail. This combination directly addresses both the need for instant exception identification and the ability to investigate a territory. The bullet chart itself shows actual versus target, and the color adds a preattentive alert.

Why this answer

The director needs to instantly spot territories below target and then drill into store details. Conditional formatting on bullet charts uses color to preattentively flag exceptions, while drill-through provides the required detail. Together, these features meet both requirements without forcing the director to interpret each chart individually.

Exam trap

The trap here is assuming that showing actual and target values on the same chart is sufficient for exception identification, when preattentive color encoding is needed for rapid scanning.

Practice this question →

229

MCQeasy

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

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

B.A line chart with month on the horizontal axis and total revenue on the vertical axis

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

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

AnswerB

A line chart connects ordered time points, making the direction and shape of the trend easy to perceive. With 24 monthly values, the line reveals whether revenue is rising, falling, or fluctuating. This directly answers the finance team's question about the overall trend across two years.

Why this answer

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

Exam trap

The trap here is treating any chart that includes all the months as valid, even when the chart type cannot express direction of change.

Practice this question →

230

MCQhard

A data analyst is designing a dashboard that will be displayed on a large monitor in a call center. The dashboard shows real-time metrics such as average handle time, call volume, and customer satisfaction. The analyst wants to ensure that the most critical metric—average handle time—is immediately noticeable when it exceeds a threshold. Which design technique best achieves this?

A.Use a red background color for the entire dashboard when average handle time exceeds the threshold.

B.Display the average handle time as a gauge with a red zone beyond the threshold, and add a blinking animation when the threshold is exceeded.

C.Apply a conditional formatting rule that changes the metric's background to a bright color (e.g., red) and displays an alert icon when the threshold is exceeded.

D.Place the average handle time metric in the top-left corner and use a larger font size than other metrics.

AnswerC

Conditional formatting with a bright background and an alert icon creates a clear, localized visual cue that immediately draws attention to the metric in exception. It does not disrupt the entire dashboard and avoids the pitfalls of blinking or full-screen color changes. This technique is a standard best practice for real-time monitoring dashboards.

Why this answer

For real-time monitoring, the most critical metric should have a dynamic visual alert when it crosses a threshold. Conditional formatting with a bright background and an alert icon localizes the cue to the metric itself, making it immediately noticeable without distracting from other information. This approach balances salience with usability.

Exam trap

The trap here is equating prominence (size, position) with alerting, when the requirement is to signal a threshold breach dynamically.

Practice this question →

231

MCQmedium

A business analyst needs to show the monthly sales trend for the past three years. Which chart type is most appropriate?

A.Histogram

B.Pie chart

C.Line chart

D.Scatter plot

AnswerC

A line chart plots continuous time-series data along a chronological axis, making month-to-month movement across three years immediately visible. Its connected points reveal trend direction and seasonality, which categorical charts such as bar or pie cannot express as clearly for this continuous temporal requirement.

Why this answer

A line chart is the standard visualization for showing a continuous trend over time, with time on the x-axis and the measured value on the y-axis. Monthly sales across three years is a time series, so a line chart clearly reveals trends, seasonality, and growth patterns. It is the most appropriate choice for this analytical goal.

Exam trap

DA0-002 often tests chart selection by intent, so the trap is choosing a histogram because it sounds statistical, when the question explicitly asks for a trend over time, which requires a line chart.

How to eliminate wrong answers

Option A is wrong because a histogram shows the frequency distribution of a single continuous variable, not a trend over time. Option B is wrong because a pie chart shows parts of a whole at a single point in time and cannot effectively display 36 monthly data points or trends. Option D is wrong because a scatter plot shows the relationship between two continuous variables, not a time-based trend.

Practice this question →

232

MCQeasy

A retail company operates 50 stores across the country. The data analyst has been asked to create a dashboard to visualize monthly sales trends over the past two years and compare the performance of the top 5 stores. The dataset includes store name, date, and daily sales amount. Initial exploration reveals that some stores have missing sales data for certain months due to system outages, and there are occasional extreme values caused by promotional events (e.g., Black Friday sales are 10x normal). The analyst needs to choose an appropriate visualization approach that accurately represents the trends and comparisons while handling these data quality issues. What should the analyst do to best meet the requirements?

A.Use a line chart for each store's monthly sales and exclude outliers from the dataset.

B.Use a bar chart showing monthly sales for each month and filter out stores with missing data.

C.Use a line chart for the overall monthly sales trend (aggregated across all stores) and a separate bar chart for the top 5 stores by total sales, with tooltips explaining outlier values.

D.Use a stacked bar chart with all 50 stores, each bar representing a month.

AnswerC

Aggregating daily sales into monthly totals smooths outage gaps, while a line chart shows trend and a bar chart ranks the top 5 stores. Tooltips flag promotional outliers without distorting the plotted values, satisfying both trend and comparison requirements.

Why this answer

The analyst should use a line chart for the overall monthly sales trend to show the aggregated pattern over two years, and a separate bar chart for the top 5 stores to compare their performance. Tooltips can explain outlier values (e.g., Black Friday spikes) without distorting the overall trend. This approach handles missing data by aggregating (which can smooth over gaps) and addresses outliers by providing context rather than removing them, which could bias the analysis.

Exam trap

DA0-002 often tests the trade-off between data cleaning and information loss, tricking candidates into choosing options that exclude outliers or missing data rather than using visualization techniques to handle them.

How to eliminate wrong answers

Option A is wrong because excluding outliers removes valuable information about promotional events and can misrepresent actual sales performance. Option B is wrong because filtering out stores with missing data reduces the dataset and may exclude stores that are otherwise important, and a bar chart for each month across all stores would be cluttered. Option D is wrong because a stacked bar chart with all 50 stores would be visually overwhelming and make it difficult to compare trends or identify top performers.

Practice this question →

233

MCQmedium

A business analyst wants to show the relationship between advertising spend (independent variable) and sales revenue (dependent variable) for 12 different regions. Each region will be represented by a point. Which chart type is most appropriate?

A.Line chart

B.Bar chart

C.Scatter plot

D.Histogram

AnswerC

A scatter plot places each region as a point on two axes, advertising spend against sales revenue, revealing correlation, clusters and outliers. It is the standard chart for showing the relationship between two continuous variables.

Why this answer

A scatter plot is the most appropriate chart type because it directly visualizes the relationship between two continuous variables—advertising spend (independent) and sales revenue (dependent)—by plotting each of the 12 regions as a point. This allows the analyst to assess correlation, trends, and outliers, which is the core purpose of scatter plots in data visualization.

Exam trap

The trap here is that candidates often confuse scatter plots with line charts, mistakenly thinking a line connecting points is needed to show a relationship, but the exam tests the understanding that scatter plots are the standard for bivariate continuous data without an inherent sequence.

How to eliminate wrong answers

Option A is wrong because a line chart is typically used to show trends over time or sequential data, not the relationship between two independent continuous variables across distinct regions. Option B is wrong because a bar chart compares categorical data or discrete values, not the continuous relationship between two numeric variables. Option D is wrong because a histogram displays the distribution of a single continuous variable by grouping data into bins, not the relationship between two variables.

Practice this question →

234

Drag & Dropmedium

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

Drag or tap steps into the slots.

Steps

Order

1Step 1

2Step 2

3Step 3

4Step 4

Why this order

Cleaning starts with identification, then analysis of missingness, strategy selection, application, and documentation.

Practice this question →

235

Multi-Selectmedium

A data analyst is designing a dashboard for executives. Which TWO practices improve dashboard effectiveness? (Select two.)

Select 2 answers

A.Including clear labels and titles for all charts

B.Adding decorative images to make the dashboard visually appealing

C.Displaying data with high precision (e.g., 4 decimal places)

D.Using consistent color coding for similar metrics across charts

E.Using many different colors to highlight every data point

AnswersA, D

Clear labels and titles state what each chart measures, its units and dimensions, so executives interpret values without guessing. This satisfies the effectiveness goal by removing ambiguity that would otherwise cause misreading of the displayed metrics.

Why this answer

Option A is correct because clear labels and titles for all charts give executives immediate context for what each visual represents, eliminating ambiguity and reducing the cognitive effort needed to interpret the data, which is essential for fast executive decision-making. Option D is correct because consistent color coding for similar metrics across charts lets viewers track the same measure (e.g., revenue always in blue) across multiple visuals without re-learning the legend each time, improving comparability and reducing misinterpretation. Option B is not appropriate because decorative images add visual clutter and consume dashboard space without conveying analytical value, distracting from the data.

Option C is incorrect because displaying data with high precision such as 4 decimal places creates unnecessary detail that obscures trends and slows comprehension at the executive level, where rounded or aggregated values are more useful. Option E is incorrect because using many different colors to highlight every data point destroys visual hierarchy and makes it impossible to distinguish meaningful patterns or exceptions.

Exam trap

DA0-002 often tests the difference between aesthetics and effectiveness — candidates who equate 'visually appealing' with 'effective' pick decorative images or many colors, missing that clarity and consistency drive comprehension.

Practice this question →

236

MCQeasy

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

A.A stacked bar chart with one bar per month and segments for each acquisition channel.

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

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

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

AnswerA

Stacked bars show both the total per month and each channel's contribution as a segment, so the reader can see share composition and how it changes across the quarter. When comparing shares across months, a 100% stacked variant makes the proportion comparison even cleaner. This directly answers both parts of the product owner's question.

Why this answer

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

Exam trap

The trap here is choosing a line chart because the data spans time, overlooking that the question asks about share of a whole rather than absolute trend.

Practice this question →

237

MCQmedium

A data analyst needs to show the relationship between advertising spend (in dollars) and monthly sales revenue (in dollars) for the past 12 months. Which chart type is most appropriate?

A.Scatter plot

B.Line chart

C.Bar chart

D.Pie chart

AnswerA

A scatter plot pairs advertising spend against sales revenue as two continuous numeric variables, exposing correlation, trend and outliers across the 12 months. This satisfies the requirement to show the relationship between the two dollar-denominated measures.

Why this answer

A scatter plot is the most appropriate chart to show the relationship between two numerical variables, such as advertising spend and sales revenue. It plots each pair of values as a point, allowing the analyst to visually assess correlation, trends, and outliers. Line charts are better for time series, bar charts for categorical comparisons, and pie charts for proportions.

Exam trap

DA0-002 often tests chart selection; candidates may choose line chart because data is over 12 months, but the goal is to show relationship, not trend over time.

How to eliminate wrong answers

Option B is wrong because a line chart is used to show trends over time, not the relationship between two variables. Option C is wrong because a bar chart compares categorical data or shows distributions, not correlations between two numerical variables. Option D is wrong because a pie chart shows parts of a whole, not relationships between two continuous variables.

Practice this question →

238

MCQmedium

A data analyst discovers that the sales data for the current quarter shows a 15% increase in revenue. However, the analyst notes that the data does not include returns from the last week due to a system lag. How should the analyst communicate this uncertainty?

A.Delay the report until returns are processed.

B.Report the 15% increase as final, because the returns are insignificant.

C.Include a caveat that returns from the last week are missing and revenue may be overstated.

D.State that the revenue increase is exactly 15% and provide a confidence interval.

AnswerC

Stating that last week's returns are absent and revenue may therefore be overstated gives stakeholders the specific limitation affecting the 15% figure. This satisfies the stem's uncertainty requirement by disclosing the missing data rather than presenting the increase as definitive.

Why this answer

The analyst must be transparent about the data's limitations. Since the missing returns could reduce the reported revenue increase, the correct action is to explicitly state that returns from the last week are not included and that the 15% figure may be overstated. This maintains data integrity and allows stakeholders to make informed decisions.

Exam trap

DA0-002 often tests the importance of data quality and the need to disclose limitations rather than presenting incomplete data as final.

How to eliminate wrong answers

Option A is wrong because delaying the report may not be necessary if the uncertainty is clearly communicated; stakeholders may still need the preliminary data. Option B is wrong because assuming the returns are insignificant is an unsupported assumption; even small returns could affect the percentage. Option D is wrong because stating the increase is exactly 15% contradicts the known data gap, and a confidence interval cannot be accurately calculated without the missing data.

Practice this question →

239

MCQmedium

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

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

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

C.Use a single color palette with consistent meaning and place the three KPIs as large, clearly labeled tiles at the top of the dashboard.

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

AnswerC

Using a consistent color palette and large, labeled KPI tiles aligns with dashboard design best practices for executive audiences. It reduces cognitive load, ensures the most important metrics are immediately visible, and avoids ambiguity. The boardroom setting demands quick comprehension, so prioritizing key numbers at the top with clear labels is optimal.

Why this answer

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

Exam trap

The trap here is assuming that more detail or interactivity always improves an executive dashboard, when actually simplicity and at-a-glance clarity are paramount.

Practice this question →