Courseiva

CCNA Visualization and Reporting Questions

75 of 240 questions · Page 2/4 · Visualization and Reporting · Answers revealed

Practice these questionsDomain overviewAll questions
76
MCQhard

In Looker Studio, you have a data source with daily sales and a separate data source with marketing spend. You want to create a chart that shows sales and marketing spend on the same axis, but the two sources are not joined natively. Which feature should you use to combine them?

A.Data blending
B.Filters
C.Community connectors
D.Calculated fields
AnswerA

Blending allows combining multiple data sources in a single chart.

Why this answer

Data blending in Looker Studio allows you to combine data from multiple sources based on a common dimension without requiring a native join.

Practice this question →
77
MCQmedium

A data analyst is creating a dashboard in Looker Studio and needs to combine data from two different data sources using a common field. Which feature should be used?

A.Data blending
B.Community connector
C.Filter
D.Calculated field
AnswerA

Blending is used to combine data from multiple sources in Looker Studio.

Why this answer

Blending in Looker Studio allows combining data from different sources based on a common dimension, similar to a left join.

Practice this question →
78
MCQeasy

Which chart type is best for visualizing the correlation between two continuous variables?

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

Scatter plots are designed to show correlation between two continuous variables.

Why this answer

Scatter plots show the relationship between two continuous variables, making them ideal for visualizing correlation.

Practice this question →
79
MCQeasy

A data analyst notices that the sales numbers in a report differ from the numbers in the finance department's spreadsheet. This discrepancy is most likely due to a lack of:

A.Row-level security
B.Data lineage
C.Data dictionary
D.Single version of truth
AnswerD

Without a single source of truth, different reports may show conflicting numbers.

Why this answer

A single version of truth means all departments use the same centralized data, avoiding inconsistencies.

Practice this question →
80
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 SQL query itself returns all regions because there is no LIMIT clause. However, the visualization tool has a built-in default limit on the number of categories displayed, such as top 10, which truncates the data in the chart. This is the most likely cause, making Option B correct.

Options A, C, and D are incorrect: the GROUP BY clause is correctly specified, a WHERE clause is not required to get all regions, and the ORDER BY clause may be applied for sorting but the tool's limit overrides the full result set.

Practice this question →
81
MCQmedium

A manager in operations needs a real-time dashboard showing production line status, including machine uptime and error counts. Which type of report is most appropriate?

A.Analytical report
B.Ad hoc report
C.Scheduled report
D.Operational report
AnswerD

Operational reports deliver real-time status for operations.

Why this answer

Operational reports provide real-time or near-real-time data for monitoring ongoing processes.

Practice this question →
82
MCQmedium

In Tableau, an analyst wants to create a calculated field that returns the average sales per customer only for customers who have made more than five purchases. Which Tableau function or approach would be most efficient?

A.Use a table calculation for running sum
B.Use a context filter on the number of records
C.Use a Level of Detail expression to count purchases per customer, then filter
D.Create a parameter to filter customers
AnswerC

Correct. LOD expressions can compute per-customer counts and then be used in a filter.

Why this answer

Level of Detail (LOD) expressions like { FIXED [Customer ID] : SUM(…) } allow computations at a granular level. Then using an IF condition on the LOD result filters to customers with >5 purchases.

Practice this question →
83
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 low
B.The gauge updates too slowly
C.The gauge uses green for all values
D.The gauge needle is too small
AnswerA

This is incorrect. If the maximum is set too high, low inventory would show a low percentage, not near 100%. The actual problem is that the maximum is set too low.

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 configured too low. This scaling mismatch makes even small inventory values appear as a high percentage, making the gauge misleading. Therefore, option A is correct: the maximum value is set too low, causing the percentage to be artificially high.

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. Additionally, the wording of option A is a common distractor—it states 'too high' when the actual issue is 'too low', testing attention to detail.

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 →
84
MCQeasy

A data analyst needs to communicate the findings of a marketing campaign analysis to the Vice President of Marketing. The VP typically only reads the first paragraph and wants the key takeaway immediately. Which format should the analyst use?

A.A raw data extract
B.A detailed technical report
C.An executive summary
D.A data dictionary
AnswerC

Executive summaries condense findings for quick consumption.

Why this answer

An executive summary provides a concise overview with headline numbers and key insights, suitable for busy executives.

Practice this question →
85
MCQhard

An organization wants to ensure that all reports use the same definitions for metrics like 'Active Customer' to avoid confusion. Which data governance element should be implemented?

A.Row-level security
B.Data dictionary
C.Single version of truth
D.Data lineage
AnswerB

A data dictionary standardizes metric definitions across the organization.

Why this answer

A data dictionary provides consistent definitions, calculation methods, sources, and update frequencies for metrics.

Practice this question →
86
MCQmedium

A healthcare analyst is creating a report on patient outcomes. To comply with privacy regulations, which action should be taken before publishing?

A.Anonymize personally identifiable information
B.Include patient names for context
C.Provide raw data to all stakeholders
D.Aggregate data without anonymization
AnswerA

Correct. Anonymization protects privacy.

Why this answer

Anonymizing PII protects patient identities and ensures compliance with privacy laws like HIPAA.

Practice this question →
87
MCQmedium

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

A.Dimension
B.Parameter
C.Metric
D.Blend
AnswerC

Correct. COUNT_DISTINCT is a metric.

Why this answer

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

Exam trap

The trap here is that candidates often confuse a dimension with a metric because they think 'customer' is a category (dimension), but the question specifically asks for a count of unique customers, which requires an aggregation, making it a metric.

How to eliminate wrong answers

Option A is wrong because a dimension is a field used to categorize, group, or filter data (e.g., customer name or month), not to perform aggregations like counting unique customers. Option B is wrong because a parameter is a user-defined input value that can be used to filter or modify queries dynamically, but it does not itself perform any aggregation or count. Option D is wrong because a blend is a technique to combine data from multiple sources or tables, not a field type that can directly count unique customers per month.

Practice this question →
88
MCQeasy

A data analyst wants to compare the total sales of four different product categories for a single year. Which chart type is most appropriate for this comparison?

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

Correct. Bar charts are best for comparing values across categories.

Why this answer

A bar chart is ideal for comparing discrete categories because the length of each bar represents the total value, making it easy to see which category has the highest sales.

Practice this question →
89
MCQmedium

A data analyst is building a dashboard in Tableau and wants to allow users to select a specific product category and have all charts on the dashboard filter to that category. Which Tableau feature should be used?

A.Calculated field
B.LOD expression
C.Parameter
D.Dashboard action
AnswerD

Dashboard actions enable cross-sheet filtering.

Why this answer

Dashboard actions in Tableau enable interactivity such as filtering across sheets based on user clicks.

Practice this question →
90
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 →
91
MCQhard

A data analyst is building a report in Power BI and needs to create a measure that calculates the total sales for the current year, but only for products that have at least one sale in the previous year. Which DAX function combination is most appropriate?

A.RELATED to pull product data
B.TOTALYTD with a filter on Date table
C.SUMX with a FILTER on Sales table
D.CALCULATE with FILTER and SAMEPERIODLASTYEAR
AnswerD

CALCULATE modifies the filter context, and FILTER combined with SAMEPERIODLASTYEAR identifies products with prior year sales.

Why this answer

Using CALCULATE with a FILTER that checks for sales in the previous year via SAMEPERIODLASTYEAR or a similar time intelligence filter achieves this dynamic filtering.

Practice this question →
92
MCQeasy

Which chart type is best for showing the sales pipeline from leads to closed deals, illustrating how many prospects drop off at each stage?

A.Treemap
B.Funnel chart
C.Waterfall chart
D.Stacked bar chart
AnswerB

Funnel charts visualize pipeline stages and conversion.

Why this answer

A funnel chart is specifically designed to show conversion or drop-off rates in a pipeline.

Practice this question →
93
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

A bar chart's y-axis should start at zero to accurately represent proportions; a truncated y-axis can exaggerate differences between bars. Option A is wrong because grouping by region does not address the axis scaling issue. Option C is wrong because a line chart is not suitable for comparing discrete categories.

Option D is wrong because 3D charts can introduce visual distortion and are not recommended.

Practice this question →
94
MCQhard

In Tableau, you want to create a view showing the total sales per region, but also want to allow users to filter by year without losing the ability to see all regions. What feature should you use to compute the total sales that ignores the year filter?

A.Table calculation running total
B.Parameter action
C.LOD expression: { FIXED [Region] : SUM([Sales]) }
D.Calculated field using SUM([Sales])
AnswerC

This computes total sales per region ignoring other dimensions.

Why this answer

A Level of Detail (LOD) expression with FIXED can compute a value at the region level, ignoring other dimensions like year.

Practice this question →
95
MCQmedium

A business analyst needs to explain to a sales director that the reported revenue has a 95% confidence interval of ±2%. Which concept is being communicated?

A.Data governance
B.Uncertainty communication
C.Single version of truth
D.Data lineage
AnswerB

Correct. Confidence intervals communicate uncertainty.

Why this answer

Confidence intervals quantify the uncertainty around a metric, conveying that the true value may vary.

Practice this question →
96
MCQeasy

A dashboard should be designed so that the most important metric is prominently displayed. This is an example of which design principle?

A.Data-ink ratio
B.Consistent color coding
C.Appropriate precision
D.Visual hierarchy
AnswerD

Visual hierarchy arranges elements by importance.

Why this answer

Visual hierarchy is the design principle that dictates arranging elements to guide the viewer's eye to the most important information first. By making the key metric the most prominent element (e.g., larger, bolder, or top-left), the dashboard ensures immediate comprehension of the primary data point, which is critical for operational decision-making.

Exam trap

In the data-plus exam, visual hierarchy is often contrasted with data-ink ratio. Candidates may confuse 'making a metric prominent' with 'reducing non-data ink,' but the former is about emphasis while the latter is about eliminating visual clutter.

How to eliminate wrong answers

Option A is wrong because the data-ink ratio focuses on minimizing non-data ink (e.g., gridlines, borders) to maximize the proportion of ink used for actual data, not on emphasizing a specific metric. Option B is wrong because consistent color coding ensures that the same color represents the same category across visualizations, aiding comparison, but it does not inherently prioritize one metric over others. Option C is wrong because appropriate precision refers to displaying data with the correct level of detail (e.g., rounding to whole numbers when decimals are unnecessary), not to the visual prominence of a metric.

Practice this question →
97
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

(line chart) is correct because line charts are best for showing trends over time. Option A (bar chart) is more for comparing categories, Option B (scatter plot) shows relationships between variables, and Option D (pie chart) shows parts of a whole.

Practice this question →
98
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 →
99
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 →
100
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

Combining color with patterns or labels ensures that information is conveyed even to users with color vision deficiencies. Option A is incorrect as rainbow palettes rely solely on hue differentiation, which is problematic for color-blind users. Option B is incorrect because converting to grayscale loses the emphasis that color can provide for all users.

Option C is incorrect because red-green color schemes are particularly difficult for those with red-green color blindness (the most common type).

Practice this question →
101
Multi-Selecthard

A data analyst is designing a dashboard for executives to monitor company performance. Which THREE practices should the analyst follow to ensure effective storytelling with data? (Select three.)

Select 3 answers
A.Annotate key events on time-series charts
B.Include as much data as possible to avoid missing details
C.Always use pie charts for part-to-whole comparisons
D.Choose the right chart type for the message
E.Use a narrative arc: situation, complication, resolution
AnswersA, D, E

Annotations highlight important points in the story.

Why this answer

Effective data storytelling includes a narrative arc, choosing the right chart, and annotating key events.

Practice this question →
102
MCQhard

A data analyst notices that two departments report different revenue totals for the same period. Which data governance issue is most likely?

A.Single version of truth
B.Data dictionary
C.Data lineage
D.Row-level security
AnswerA

Correct. Without a centralized reporting layer, different sources can produce different numbers.

Why this answer

Lack of a single version of truth means data sources are not reconciled, leading to discrepancies.

Practice this question →
103
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 →
104
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 →
105
Multi-Selectmedium

A data analyst is creating a dashboard for a sales team. Which TWO actions adhere to dashboard design best practices?

Select 2 answers
A.Including 3D effects to make charts look more professional
B.Using consistent color coding across charts
C.Adding detailed axis labels and titles to every chart
D.Placing the most important metric at the top-left or most prominent position
E.Using as many bright colors as possible to make the dashboard attractive
AnswersB, D

Consistent color coding helps users quickly interpret charts and maintain visual coherence, which is a best practice.

Why this answer

Using consistent color coding and placing the most important metric prominently are best practices. Using many bright colors and 3D effects are not.

Practice this question →
106
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 →
107
MCQeasy

Which of the following is a key performance indicator (KPI) tied to a strategic objective, as opposed to a metric?

A.Average handle time
B.Customer satisfaction score (CSAT) as a strategic goal
C.Number of daily logins
D.Server uptime percentage
AnswerB

CSAT can be a KPI if tied to strategic objective of improving customer experience.

Why this answer

A key performance indicator (KPI) is a measurable value that demonstrates how effectively a company is achieving a key strategic objective. Here, 'Customer satisfaction score (CSAT) as a strategic goal' explicitly ties the metric to a strategic objective (e.g., improving customer loyalty), whereas a plain metric like 'average handle time' is an operational measure without a direct strategic link. In data visualization, KPIs are often displayed on dashboards with targets and thresholds to track progress toward high-level business goals.

Exam trap

The trap here is that candidates confuse any measurable value (metric) with a key performance indicator (KPI), failing to recognize that a KPI must be explicitly tied to a strategic objective, not just any operational or technical measurement.

How to eliminate wrong answers

Option A is wrong because average handle time is an operational metric that measures efficiency in a call center, not a KPI tied to a strategic objective; it lacks a direct connection to a broader business goal. Option C is wrong because number of daily logins is a vanity metric that tracks user activity but does not inherently reflect progress toward a strategic objective like revenue growth or customer retention. Option D is wrong because server uptime percentage is a technical metric for system reliability, not a KPI linked to a strategic objective unless explicitly framed as part of a service-level agreement (SLA) goal tied to business continuity.

Practice this question →
108
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

Excel is for spreadsheets, SQL for databases, Python for programming/ML, and Tableau for visualization. Common confusions include assigning predictive modeling to Excel or dashboard creation to SQL.

Practice this question →
109
MCQmedium

A financial analyst wants to create a dashboard that shows the monthly profit and loss, highlighting how each component (revenue, cost of goods sold, operating expenses) contributes to the final net profit. Which chart type is most appropriate?

A.Pie chart
B.Stacked bar chart
C.Area chart
D.Waterfall chart
AnswerD

Waterfall charts illustrate the step-by-step progression from starting to ending value, perfect for financial breakdowns.

Why this answer

A waterfall chart effectively shows how each incremental positive or negative value contributes to a final total, making it ideal for profit/loss breakdowns.

Practice this question →
110
MCQhard

In Power BI, an analyst wants to create a measure that calculates the total sales for the current year up to the latest date in the data. Which DAX function should be used?

A.SAMEPERIODLASTYEAR
B.CALCULATE
C.SUMX
D.TOTALYTD
AnswerD

Correct. TOTALYTD computes the year-to-date total.

Why this answer

TOTALYTD is a time intelligence function that sums values for the year up to the last date in the filter context (or specified end date).

Practice this question →
111
MCQeasy

Which of the following is a key difference between a Key Performance Indicator (KPI) and a metric?

A.Metrics are always quantitative, while KPIs can be qualitative
B.There is no difference; the terms are interchangeable
C.KPIs are tied to strategic objectives, while metrics are broader operational measurements
D.KPIs are always lagging indicators, while metrics are leading indicators
AnswerC

Correct. KPIs are a subset of metrics that are critical to strategic success.

Why this answer

KPIs are tied to strategic objectives and measure progress toward goals, while metrics can be any operational measurement that may not be directly linked to strategy.

Practice this question →
112
MCQhard

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

A.Line chart
B.Stacked bar chart
C.Area chart
D.Waterfall chart
AnswerC

Correct. An area chart, especially stacked, shows cumulative trends over time.

Why this answer

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

Exam trap

The trap here is that candidates often confuse a stacked bar chart with an area chart, thinking that stacking bars shows cumulative effect, but the area chart's continuous fill better represents the cumulative flow over time, which is the key requirement in the question.

How to eliminate wrong answers

Option A is wrong because a line chart only shows the trend of individual data points over time without any visual stacking or cumulative effect, so it cannot highlight the total contribution of each month stacked on top of previous months. Option B is wrong because a stacked bar chart shows parts of a whole at discrete time points but does not inherently emphasize the cumulative effect over time as a continuous flow, and it is less effective for showing the progression of cumulative totals across many months. Option D is wrong because a waterfall chart is designed to show incremental changes (additions and subtractions) from a starting value to an ending value, not to display a continuous cumulative stack of monthly contributions over a five-year period.

Practice this question →
113
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

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 →
114
Multi-Selectmedium

A data analyst frequently receives ad hoc requests for the same type of analysis. Which TWO approaches could reduce the number of ad hoc requests?

Select 2 answers
A.Increase data freshness to real-time
B.Create a scheduled report that covers the common analysis
C.Add more security to the data
D.Ignore the requests until they become urgent
E.Encourage users to create their own reports using a self-service BI tool
AnswersB, E

A scheduled report can proactively deliver the needed information.

Why this answer

Building self-service capabilities and iterating on feedback to improve scheduled reports can address recurring needs and reduce ad hoc requests.

Practice this question →
115
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

KPI cards (or tiles) are designed to display a single key metric, such as revenue, profit margin, or customer count, along with its variance (e.g., change over time or vs. target), making them ideal for executive dashboards where quick comprehension of high-level KPIs is critical. Pie charts are poor for showing individual values and cannot display variance; sparklines show trends but not the current value prominently; gauge charts are less precise for exact numbers. Therefore, KPI cards are the most appropriate choice.

Practice this question →
116
MCQhard

A data analyst is creating a self-service reporting environment. Which data governance practice ensures users see only data relevant to their department?

A.Data lineage
B.Row-level security
C.Data dictionary
D.Single version of truth
AnswerB

Correct. Row-level security filters data per user.

Why this answer

Row-level security restricts data access based on user roles, ensuring users only see authorized data.

Practice this question →
117
Multi-Selectmedium

An analyst is creating a report in Power BI and needs to calculate year-to-date total sales compared to the same period last year. Which TWO DAX functions should be used? (Choose two.)

Select 2 answers
A.FILTER
B.RELATED
C.SAMEPERIODLASTYEAR
D.SUMX
E.TOTALYTD
AnswersC, E

Correct. SAMEPERIODLASTYEAR shifts dates back one year.

Why this answer

TOTALYTD computes year-to-date, and SAMEPERIODLASTYEAR shifts context to the prior year. CALCULATE modifies filter context, often used with time intelligence.

Practice this question →
118
MCQmedium

An analyst wants to visualize the relationship between advertising spend (x-axis) and revenue (y-axis) for 100 different products. Each product is in one of three categories. Which chart type best displays this data?

A.Scatter plot with points colored by category
B.Bubble chart
C.Stacked bar chart
D.Line chart with three lines
AnswerA

Scatter plots show correlation, and color adds a third dimension.

Why this answer

A scatter plot with color-coded categories effectively shows relationships between two continuous variables and a third categorical dimension.

Practice this question →
119
MCQmedium

A data analyst creates a weekly KPI dashboard for executives. The analyst notes that the data is updated as of the previous day. Which report quality element should be included?

A.Data dictionary
B.Data lineage
C.Row-level security
D.Data freshness timestamp
AnswerD

Correct. Data freshness notes the last update time.

Why this answer

Data freshness indicates how recent the data is, which is crucial for interpreting the report's timeliness.

Practice this question →
120
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 A, C, and D are correct. Text alternatives (A) allow screen readers to convey chart data. Clear labels (C) improve readability for all users.

Sufficient color contrast (D) helps users with low vision. Using only color (B) to convey information excludes colorblind users, and animated transitions (E) can be distracting and are not an accessibility improvement.

Practice this question →
121
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 →
122
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

Heatmaps and small multiples (trellis charts) are effective for visualizing large, dense datasets with multiple categories. A heatmap can show CPU utilization intensity over time for all servers in a compact form, making it easy to identify consistently high utilization and spikes. Small multiples create separate charts per server, avoiding overlap and allowing comparison.

Option B is wrong because a single line chart with 200 lines would be even more cluttered than the scatter plot, making it impossible to distinguish individual servers. Option C is wrong because trend lines remove the individual data points needed to detect unusual spikes, and they would not show the actual utilization values. Option D is wrong because increasing the size of data points would worsen the overlap and clutter, making the chart even less readable.

Practice this question →
123
Multi-Selectmedium

A data analyst is documenting a report for external stakeholders. Which THREE elements should be included to ensure report quality and transparency?

Select 3 answers
A.Data freshness (e.g., last updated timestamp)
B.Employee names who created the report
C.Row-level security settings
D.Limitations and assumptions
E.Methodology notes
AnswersA, D, E

Indicates how current the data is.

Why this answer

Data freshness, methodology notes, and limitations/assumptions help users assess the reliability and context of the report.

Practice this question →
124
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 →
125
Multi-Selectmedium

A data analyst is creating a report that includes customer names and addresses. To comply with privacy regulations, which TWO actions should the analyst take?

Select 2 answers
A.Use aggregated data instead of individual records.
B.Include customer names for context.
C.Anonymize or remove personally identifiable information (PII).
D.Share the raw data with all stakeholders.
E.Encrypt the report but keep names visible.
AnswersA, C

Aggregation prevents identifying individuals.

Why this answer

Anonymizing PII (e.g., removing or masking names/addresses) and aggregating data prevent individual identification, which is required for GDPR compliance.

Practice this question →
126
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

Sorting bars by sales (B) allows immediate comparison of relative performance. Adding data labels on each bar (C) provides exact figures, enhancing readability. Option A is incorrect because overlaying a line chart on a bar chart mixes data types and can obscure the bar values.

Option D (vertical gridlines for every bar) often adds visual clutter without improving readability. Option E (3D bar chart) distorts perspective and makes accurate comparison difficult.

Practice this question →
127
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

Since the outlier is due to a data entry error, the appropriate first step is to correct the data (change the sales figure to $200,000) or remove the outlier, then recreate the scatter plot. This ensures the visualization accurately reflects the true relationship. Option A is incorrect: a bar chart with binned averages would still be affected by the erroneous data point and would not show the individual relationship clearly.

Option B is incorrect: adding a trend line to the current plot would still be influenced by the erroneous outlier, potentially distorting the trend. Option D is incorrect: a line chart is typically used for time series data, and this is not a time series; moreover, it would still include the outlier.

Practice this question →
128
MCQmedium

In a Power BI report, a user wants to create a measure that calculates total sales for the current year up to today. Which DAX function should they use?

A.TOTALYTD
B.CALCULATE
C.SUMX
D.SAMEPERIODLASTYEAR
AnswerA

TOTALYTD calculates year-to-date values correctly.

Why this answer

TOTALYTD is a time intelligence function that calculates year-to-date values.

Practice this question →
129
Multi-Selectmedium

Which TWO are examples of leading indicators in a business context? (Select two.)

Select 2 answers
A.Employee turnover rate
B.Net profit margin
C.Customer engagement score
D.Number of qualified leads
E.Monthly revenue
AnswersC, D

Engagement often predicts future retention and sales.

Why this answer

Leading indicators predict future performance; number of qualified leads and customer engagement score forecast future sales.

Practice this question →
130
Multi-Selecthard

A data analyst is preparing a report on regional sales performance. The report will be viewed by regional managers who should only see their own region's data. Which TWO data governance measures are most relevant?

Select 2 answers
A.Single version of truth
B.Row-level security
C.Data retention
D.Data lineage
E.Data dictionary
AnswersB, E

Row-level security limits users to their own region's data.

Why this answer

Row-level security restricts access to specific rows (regions), and a data dictionary ensures consistent metric definitions across regions.

Practice this question →
131
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 →
132
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 →
133
Multi-Selecteasy

A data analyst needs to display the distribution of customer ages in a dataset containing 10,000 records. Which TWO chart types are appropriate? (Choose two.)

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

Correct. Box plots show distribution, median, quartiles, and outliers.

Why this answer

Histograms show distribution of a continuous variable, and box plots show distribution with quartiles and outliers. Pie charts and bar charts are not for distribution.

Practice this question →
134
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 →
135
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 →
136
MCQmedium

A dashboard designer wants to maximize the data-ink ratio. Which action should they take?

A.Add a 3D effect to bars
B.Include a company logo in the chart area
C.Remove redundant gridlines
D.Use a colorful background
AnswerC

Removing non-data ink improves the data-ink ratio.

Why this answer

Data-ink ratio is maximized by removing non-data ink (chartjunk) like unnecessary gridlines and borders.

Practice this question →
137
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

A choropleth map using rates (sales per capita) normalizes for population, preventing small-population states with high sales from appearing overly prominent. Options A, C, and D do not properly normalize the data: A changes chart type but does not normalize, C uses raw sales, and D applies a log scale which distorts the relationship without normalizing for population.

Practice this question →
138
Multi-Selectmedium

A sales analyst is designing a report for the sales team that includes the number of new leads, conversion rate, and total revenue. The team wants to identify which metrics are Key Performance Indicators (KPIs) tied to the strategic goal of increasing revenue. Which TWO of the following should be classified as KPIs?

Select 2 answers
A.Total revenue
B.Conversion rate
C.Average deal size
D.Customer satisfaction score
E.Number of new leads
AnswersA, B

Correct. Total revenue is a direct measure of the strategic goal.

Why this answer

Total revenue is a direct measure of the strategic goal of increasing revenue, making it a clear Key Performance Indicator (KPI). It quantifies the financial outcome that the sales team is aiming to improve, aligning perfectly with the stated objective.

Exam trap

The trap here is that candidates often confuse input metrics (like number of new leads) or efficiency metrics (like average deal size) with KPIs, failing to recognize that KPIs must directly measure progress toward the specific strategic goal, which in this case is increasing revenue.

Practice this question →
139
Multi-Selectmedium

An analyst is creating a dashboard in Power BI to track sales performance. They want to ensure that when a user selects a specific product category on a slicer, all other visuals on the page filter to show data only for that category. Which TWO actions should the analyst take?

Select 2 answers
A.Use the 'Sync slicers' pane to synchronize the slicer across all pages
B.Edit interactions between the slicer and other visuals to ensure filtering is enabled
C.In the 'Format' pane, set the slicer to 'Single select'
D.Create a measure using the CALCULATE function with ALLEXCEPT
E.Place the slicer on the page and ensure the category field is added to the slicer
AnswersB, E

Correct. This ensures the slicer filters the desired visuals, especially if interactions were previously changed.

Why this answer

In Power BI, slicers by default filter all visuals on a page. However, if the analyst wants to ensure cross-filtering, they can edit interactions to enable filtering. Also, using the 'Sync slicers' pane is for syncing slicers across pages, not for enabling filtering.

The 'Filters' pane is for manual filters, not for slicer interactions.

Practice this question →
140
MCQmedium

A data analyst needs to visualize the distribution of salaries across departments and also compare the median and identify outliers. Which chart type is most suitable?

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

Box plots show median, quartiles, and outliers, and are great for comparing across groups.

Why this answer

Box plots display median, quartiles, and outliers, making them ideal for comparing distributions across categories.

Practice this question →
141
MCQmedium

A dashboard designer wants to ensure the most important KPI is prominently displayed at the top left. Which design principle is being applied?

A.Visual hierarchy
B.Consistent color coding
C.Data-ink ratio
D.Appropriate precision
AnswerA

Visual hierarchy organizes elements by importance.

Why this answer

Visual hierarchy arranges elements by importance, typically placing the most critical information where the eye naturally starts (top left in Western cultures).

Practice this question →
142
MCQeasy

Which chart type is best for showing the distribution of a continuous variable, such as customer ages?

A.Bar chart
B.Pie chart
C.Box plot
D.Histogram
AnswerD

Histograms display the distribution of a continuous variable.

Why this answer

A histogram is the correct choice because it groups continuous data (like customer ages) into bins along a continuous x-axis, displaying the frequency distribution through bar heights. This directly shows the shape, spread, and central tendency of the variable, which is the core requirement for visualizing a continuous distribution.

Exam trap

The trap here is that candidates often confuse a histogram with a bar chart, thinking both use bars for 'counts,' but fail to recognize that histograms require continuous numeric bins with no gaps, while bar charts use categorical labels with gaps.

How to eliminate wrong answers

Option A is wrong because a bar chart is designed for categorical (discrete) data, where each bar represents a distinct category with gaps between bars; using it for continuous ages would incorrectly treat age values as separate categories, losing the distribution's continuity. Option B is wrong because a pie chart shows proportions of a whole for categorical data, not the distribution of a continuous variable; it cannot convey the spread, skew, or modality of ages. Option C is wrong because a box plot summarizes distribution through quartiles and outliers but does not show the detailed shape (e.g., multimodality) that a histogram reveals; it is better for comparing distributions than for displaying the full distribution of a single continuous variable.

Practice this question →
143
Multi-Selectmedium

A marketing analyst wants to visualize the conversion funnel from website visitors to paying customers. Which TWO chart types are suitable for showing this pipeline? (Choose two.)

Select 2 answers
A.Scatter plot
B.Pie chart
C.Funnel chart
D.Waterfall chart
E.Bar chart
AnswersC, D

Correct. Funnel charts are purpose-built for conversion pipelines.

Why this answer

Funnel charts are designed for pipeline/conversion. Waterfall charts show incremental changes, which can also represent funnel stages. Scatter plots and bar charts are not ideal for funnel visualization.

Practice this question →
144
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 →
145
MCQmedium

A data analyst is building a report that includes customer names and addresses. To comply with GDPR, what must the analyst do before publishing the report?

A.Add a data dictionary
B.Increase data freshness
C.Apply row-level security
D.Anonymize the PII data
AnswerD

Anonymization protects individual privacy as required by GDPR.

Why this answer

GDPR requires that personally identifiable information (PII) be anonymized to prevent individual identification in reports.

Practice this question →
146
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 →
147
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 →
148
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

A dual-axis chart with bars for actual and budget by month for each department, and a line for variance, allows the CFO to quickly compare actual vs budget figures and see the trend of variance over time. Option B (waterfall chart) is better suited for cumulative changes over time, not month-by-month comparisons. Option C (table with conditional formatting) does not provide a quick visual overview of trends.

Option D (stacked bar chart) makes it difficult to compare actual vs budget across departments and months, and obscures individual department trends.

Practice this question →
149
Multi-Selecthard

A data analyst is building a narrative around a quarterly sales decline. The story should follow a narrative arc. Which THREE elements should be included in the story?

Select 3 answers
A.Random color scheme for every chart
B.Resolution: By diversifying suppliers, sales recovered in November.
C.Situation: Q3 sales were on track to meet targets.
D.Detailed description of each product's sales breakdown
E.Complication: A supply chain disruption caused a drop in October.
AnswersB, C, E

Resolution shows how the issue was addressed.

Why this answer

A narrative arc in data storytelling typically includes situation (context), complication (problem), and resolution (recommendation or action).

Practice this question →
150
MCQmedium

An analyst needs to show the part-to-whole relationship of market share among four competitors. Which chart type is most appropriate, considering best practices?

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

Pie charts effectively show proportions with a limited number of categories.

Why this answer

A pie or donut chart is suitable for part-to-whole with few categories (5-7 slices max). Here, four competitors fit well.

Practice this question →
← PreviousPage 2 of 4 · 240 questions totalNext →

Ready to test yourself?

Try a timed practice session using only Visualization and Reporting questions.

Start 20-question session