DA0-002 Visualization and Reporting Practice Test 4 — 15 Questions

Question 1

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?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

Row-level security. Row-level security (B) is correct because it enforces access control at the row granularity, so each regional manager's query is automatically filtered to return only the rows belonging to their own region, which directly satisfies the requirement that managers see only their region's data. A data dictionary (E) is correct because it documents the definition, meaning, and structure of the data elements (such as the region field and sales metrics) used in the report, ensuring consistent interpretation and correct identification of the region attribute that the security policy relies on. Single version of truth (A) is not the focus here because it concerns eliminating conflicting copies of data rather than restricting visibility per user. Data retention (C) addresses how long data is kept and purged, which is unrelated to per-region access restriction. Data lineage (D) tracks the origin and transformation path of data for auditing and troubleshooting, but it does not itself control who can see which rows.

Answer

Single version of truth

Answer

Data retention

Answer

Data lineage

Question 2

A data analyst is building a one-page dashboard for a logistics company. The dashboard must show, at a glance, how many shipments are currently in each of five statuses: Pending, In Transit, Delivered, Delayed, and Cancelled. The analyst wants viewers to instantly compare the relative size of each status without reading exact numbers. Which visualization should the analyst use?

Accepted Answer

A horizontal bar chart with one bar per shipment status, sorted by count. A horizontal bar chart with a shared baseline lets viewers compare category magnitudes by length, the most accurately perceived visual encoding, and sorting by count highlights the ranking. Because the data is a current categorical snapshot rather than a time series or a hierarchical composition, bars are the correct fit. Pie charts, line charts, and treemaps either obscure the comparison or impose an inappropriate structure.

Answer

A line chart with one line per shipment status over the last 30 days

Answer

A pie chart with five slices, one per shipment status

Answer

A treemap with nested rectangles sized by shipment count per status

Question 3

A data analyst is creating a report that will be distributed as a PDF to stakeholders who will view it on various devices, including smartphones. The report contains several charts and tables. Which TWO design practices will best ensure the report remains legible and effective on small screens? (Choose two.)

Accepted Answer

Design charts with large, clear labels and minimal clutter.. For mobile viewing, a single-column layout allows natural vertical scrolling and prevents horizontal scrolling, while charts with large labels and minimal clutter remain readable when scaled down. Together, these practices ensure the report is legible and effective on smartphones without requiring zooming or panning.

Answer

Include detailed data tables with many columns to provide comprehensive data.

Answer

Increase the font size of all text to at least 14 points.

Answer

Use vector graphics for charts instead of raster images.

Question 4

A data analyst is creating a report that will be distributed as a PDF to stakeholders. The report includes a chart that uses color to differentiate between five product categories. The analyst wants to ensure the chart is accessible to color-blind readers. Which approach is most effective?

Accepted Answer

Add patterns or textures to each category in addition to color.. The most effective approach for accessibility is to not rely on color alone. Adding patterns or textures to each category ensures that readers with color vision deficiency can differentiate the data. This is a fundamental principle of accessible design, especially for static reports like PDFs where interactivity is not available.

Answer

Use a color palette that is color-blind friendly, such as blue-orange.

Answer

Use a rainbow color palette to maximize differentiation.

Answer

Use a monochromatic color palette with varying shades.

Question 5

A data analyst is building a dashboard for a logistics company. The operations manager needs to see the current status of all 500 active deliveries on a single screen. The statuses are: On Time, Delayed, At Risk, and Delivered. The analyst wants a chart that shows the proportion of deliveries in each status and allows the manager to quickly identify if the 'Delayed' proportion is growing. Which chart type is most appropriate?

Accepted Answer

Stacked bar chart. The operations manager needs to see the proportion of deliveries in each status and detect growth in the 'Delayed' category. A stacked bar chart effectively shows parts of a whole for categorical data, allowing quick comparison of segment sizes. It can also be used to compare proportions across multiple groups or time periods, making it ideal for monitoring changes in a specific status like 'Delayed'.

Answer

Pie chart

Answer

Scatter plot

Answer

Line chart

Question 6

A data analyst is creating a heatmap to show website click-through rates across different pages and user segments. The analyst notices that some cells have very low click-through rates, making the heatmap appear predominantly light in color and difficult to interpret. Which technique should the analyst apply to improve the readability of the heatmap?

Accepted Answer

Apply a logarithmic color scale to compress the range of high values and expand the range of low values.. A logarithmic color scale is the best technique because it transforms the data to reveal differences among low values while compressing high values. This directly addresses the problem of low click-through rates dominating the heatmap. By expanding the low end of the scale, the analyst can better distinguish variations that were previously lost, leading to a more informative and readable heatmap.

Answer

Switch to a grayscale color scheme to reduce the impact of color perception differences.

Answer

Use a diverging color scale centered on the median click-through rate.

Answer

Increase the number of color bins to create a smoother gradient across the range.

Question 7

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

Accepted Answer

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

Answer

Increase the chart canvas size

Answer

Reduce all bubble sizes uniformly

Answer

Remove outlier countries with large populations

Question 8

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

Accepted Answer

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

Answer

Line chart

Answer

Pie chart

Answer

Scatter plot

Question 9

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

Accepted Answer

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

Answer

The map projection is distorted

Answer

The monitor resolution is too low

Answer

Users are color blind

Question 10

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

Accepted Answer

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

Answer

Change to a pie chart for each quarter

Answer

Increase the width of each bar

Answer

Switch to a 3D stacked column chart

Question 11

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

Accepted Answer

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

Answer

Bar chart

Answer

Line chart

Answer

Pie chart

Question 12

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

Accepted Answer

Avoid using more than five slices in a pie chart. Option A is correct because limiting a pie chart to about five slices keeps each wedge large enough to compare visually; beyond that, similar-sized slices become indistinguishable and the chart loses its purpose, so consolidating minor categories into an 'Other' slice is a recognized best practice. Option E is correct because assigning colors consistently to the same data values or categories across all visuals in a report prevents misreading and lets viewers track a series reliably, which is a core principle of effective encoding. The unmarked options do not belong: B is wrong because maximizing data-ink ratio means removing non-data ink, not all whitespace, since whitespace improves grouping and readability; C is wrong because high-contrast gridlines compete with the data and should be muted or omitted when not needed; and D is wrong because 3D effects distort proportions and add perspective that misrepresents values rather than making charts more professional.

Answer

Maximize data-ink ratio by removing all whitespace

Answer

Always include gridlines with high contrast

Answer

Use 3D effects to make charts look professional

Question 13

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

Accepted Answer

The data types (categorical, numerical, time series). Option B is correct because the data type—categorical, numerical, or time series—directly determines which chart families are valid: categorical comparisons suit bar charts, time series suit line charts, and numerical distributions suit histograms or scatter plots. Option C is correct because the number of variables to display dictates dimensionality, so one variable may use a histogram, two variables a scatter plot, and three or more may require bubble charts, small multiples, or faceting. Option D is correct because the key insight or message to convey should drive the choice—showing trend, comparison, composition, correlation, or distribution each calls for a different chart type. Option A is not a primary factor because animation is a presentation enhancement, not a determinant of whether a chart correctly encodes the data. Option E is not a primary factor because brand color schemes affect styling and accessibility, not the fundamental selection of chart type.

Answer

The animation capabilities of the software

Answer

The color scheme of the company logo

Question 14

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

Accepted Answer

Box plot. A box plot (option A) is correct because it summarizes the distribution of a single continuous variable through its median, quartiles, and potential outliers, directly revealing spread and skewness. A histogram (option C) is also correct because it bins a single continuous variable into intervals and displays the frequency of values in each bin, clearly showing the distribution's shape. A line chart (option B) is not appropriate here since it is designed to show trends or changes over an ordered sequence, typically time. A scatter plot (option D) is used to visualize the relationship between two continuous variables, not the distribution of one. A pie chart (option E) shows proportions of a whole for categorical data, not the distribution of a continuous variable.

Answer

Line chart

Answer

Scatter plot

Answer

Pie chart

Question 15

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

Accepted Answer

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

Answer

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

Answer

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

Answer

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