Courseiva

CCNA Visualization and Reporting Questions

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

Practice these questionsDomain overviewAll questions
226
Multi-Selecthard

A data analyst is creating a report in Power BI and needs to calculate the total sales for the current year and the previous year. Which TWO DAX functions can be used to retrieve the previous year's sales?

Select 2 answers
A.DATEADD
B.TOTALYTD
C.SAMEPERIODLASTYEAR
D.FILTER
E.PREVIOUSYEAR
AnswersA, C

Can shift dates by -1 year to get the previous year.

Why this answer

SAMEPERIODLASTYEAR and DATEADD (with -1 year) both can return dates from the previous year. PREVIOUSYEAR is invalid, TOTALYTD is for current year, and FILTER is not a time intelligence function.

Practice this question →
227
MCQhard

A data scientist has a dataset with 50 variables and wants to identify clusters of similar observations. Which visualization technique is most suitable for reducing dimensionality to 2D while preserving cluster structure?

A.Heatmap of correlations
B.Scatter matrix (pairplot)
C.Parallel coordinates plot
D.Scatter plot of first two principal components
AnswerD

PCA reduces dimensions while preserving variance, enabling visualization of clusters.

Why this answer

PCA reduces the dimensionality of a 50-variable dataset to two principal components while preserving the variance, making clusters visible in a scatter plot. Parallel coordinates (C) is useful for visualizing high-dimensional data but does not inherently preserve cluster structure. Heatmap of correlations (A) shows relationships between variables, not observations.

Scatter matrix (B) becomes impractical with 50 variables due to the number of plots, and it does not reduce dimensionality.

Practice this question →
228
MCQhard

An analyst creates a histogram of customer transaction amounts but observes that the distribution looks bimodal. Upon review, the analyst realizes that two different customer segments (retail and wholesale) were combined. Which action best addresses this?

A.Create two separate histograms, one for each segment
B.Use a single histogram with two colors for segments
C.Use a box plot instead of a histogram
D.Increase the number of bins to see more detail
AnswerA

Separate histograms clearly show each segment's distribution and the reason for bimodality.

Why this answer

Splitting the data into two separate histograms by segment reveals the distinct distributions. Changing bin width may hide or exaggerate features. Combining into one chart with color is possible but may still obscure the bimodal nature if overlapping.

A box plot shows medians but not shape.

Practice this question →
229
MCQmedium

A data analyst is building a self-service reporting environment. Which of the following is the primary benefit of this approach?

A.It ensures all reports use the same data source.
B.It reduces the number of ad hoc report requests to the analytics team.
C.It automatically generates executive summaries.
D.It improves data security by limiting access.
AnswerB

Users can answer their own questions without involving analysts.

Why this answer

Self-service BI empowers business users to create their own reports, reducing ad hoc requests to the analytics team.

Practice this question →
230
MCQmedium

A dashboard designer is creating a sales performance dashboard and wants to minimize non-data ink to improve clarity. Which action best follows the principle of maximizing the data-ink ratio?

A.Removing gridlines that do not add value to the chart
B.Including a detailed company logo on every chart
C.Adding a background image to make the dashboard more visually appealing
D.Using 3-D effects on bars to make them stand out
AnswerA

Correct. Removing unnecessary gridlines reduces chartjunk and increases the proportion of ink used for data.

Why this answer

It directly follows Tufte's data-ink ratio principle by removing non-data ink (gridlines that don't aid interpretation) while preserving the core data. This maximizes the proportion of ink devoted to actual sales metrics, improving clarity without sacrificing information.

Exam trap

The trap here is that candidates may confuse 'visually appealing' (options B, C, D) with effective data communication, not realizing that decorative elements reduce the data-ink ratio and can obscure insights in a professional dashboard.

How to eliminate wrong answers

Option B is wrong because a detailed company logo on every chart adds non-data ink that distracts from the sales performance data, violating the data-ink ratio principle. Option C is wrong because a background image introduces decorative non-data ink that reduces the clarity of the data visualization, contrary to the principle. Option D is wrong because 3-D effects on bars add chartjunk (non-data ink) that can distort perception of bar heights and make comparisons harder, directly opposing the goal of maximizing data-ink.

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

Alpha blending reveals density; distinct colors improve region identification.

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 →
232
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

The data-ink ratio is reduced by unnecessary decorative elements.

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 →
233
MCQhard

A dataset contains salaries ranging from $25,000 to $2,500,000, with most salaries under $100,000. Which chart type best shows the distribution without distortion from extreme values?

A.Box plot
B.Scatter plot
C.Histogram with equal bin widths
D.Line chart
AnswerA

Box plots show median, quartiles, and outliers, handling skew well.

Why this answer

Box plot. Box plots display the distribution through quartiles and explicitly show outliers as individual points, making them ideal for skewed data with extreme values. In contrast, a scatter plot (B) is for relationships between variables, not distribution; a histogram (C) with equal bin widths would compress the majority of the data into a single bin if bins are sized to include the extreme values; and a line chart (D) is for trends over time.

Therefore, the box plot best shows the distribution without distortion from extreme values.

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

Line charts effectively show trends over time.

Why this answer

Line charts are ideal for displaying trends over time, making them suitable for showing monthly sales trends.

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

Combines trend and comparison effectively; aggregation handles missing data, and tooltips provide context.

Why this answer

It combines a line chart for overall trend (aggregating all stores) and bar charts for top 5 stores, which allows comparison while handling missing data through aggregation. Tooltips can provide context for outliers. Option A is wrong because using separate line charts for each store becomes cluttered with 50 stores, and excluding outliers may omit valuable information about promotions.

Option B is wrong because filtering out stores with missing data could remove important stores and distort the trend. Option D is wrong because a stacked bar chart with all 50 stores would be difficult to read and doesn't show trends over time effectively.

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

Correct. Scatter plots reveal correlation between two 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 →
237
Drag & Dropmedium

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

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

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 →
238
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 are essential for understanding.

Why this answer

Clear labels and titles help interpretation; consistent color coding aids quick comprehension.

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

Correct. Scatter plots display the relationship between two continuous variables.

Why this answer

A scatter plot is used to visualize the correlation between two continuous variables.

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

Disclosing the limitation is the correct approach.

Why this answer

When data has limitations, it's important to disclose them, such as missing returns, to avoid misleading conclusions.

Practice this question →
← PreviousPage 4 of 4 · 240 questions total

Ready to test yourself?

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

Start 20-question session