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

Question 1

A data analyst is creating a report that will be printed in black and white for a quarterly business review. The report includes a bar chart comparing revenue across five product categories. To ensure the chart is interpretable without color, which design element should the analyst prioritize?

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

Accepted Answer

Use a distinct pattern (e.g., solid, striped, dotted) for each bar and include a legend or direct labels.. In a black-and-white print environment, color cannot be used to distinguish categories. Patterns are a reliable non-color encoding that works even with low-quality printing. Pairing patterns with a legend or direct labels ensures the viewer can correctly identify each product category, satisfying the requirement for interpretability.

Answer

Use a different shade of gray for each bar and include a legend.

Answer

Add data labels directly on each bar showing the revenue value.

Answer

Sort the bars from highest to lowest revenue and omit the legend.

Question 2

A data analyst is tasked with creating a report that shows the proportion of total sales contributed by each product category. The analyst wants to use a chart that clearly displays the parts of a whole. Which chart type is most appropriate?

Accepted Answer

Pie chart. A pie chart is the most appropriate because it visually represents each product category's share of total sales as slices of a whole. This directly addresses the requirement to show proportions, making it easy for the audience to compare contributions at a glance.

Answer

Histogram

Answer

Scatter plot

Answer

Line chart

Question 3

A data analyst is designing a dashboard for a hospital's emergency department. The dashboard must display real-time patient wait times, current bed occupancy, and the number of patients waiting to be seen. The primary users are charge nurses and physicians who need to make quick staffing decisions. Which two design principles are most critical to ensure the dashboard is effective for this scenario? (Choose two.)

Accepted Answer

Use a consistent color scheme with red indicating critical thresholds and green indicating normal status.. For a real-time operational dashboard used in a high-pressure environment, immediate interpretability and data freshness are paramount. A consistent color scheme for thresholds allows quick status assessment, and frequent automatic refreshes ensure the data reflects current conditions. Both features directly support rapid, informed staffing decisions.

Answer

Include detailed patient demographic information to provide context for each waiting patient.

Answer

Use a complex, multi-layered drill-down structure to allow users to explore data from multiple angles.

Answer

Display all available historical data to provide full context for current conditions.

Question 4

A retail analyst must build a single dashboard that executives will view on a large conference-room display and regional managers will open on tablets in the field. The executive layout uses a dense 4x3 grid of small KPI tiles. Which design approach best preserves readability across both viewing contexts?

Accepted Answer

Design a responsive layout with breakpoints so the tile grid reflows to fewer columns and larger touch targets on smaller screens.. A responsive layout with defined breakpoints lets a single dashboard artifact adapt its column count, element sizing, and touch targets to the viewport actually in use. The conference display retains dense KPI tiles for executive scanning, while the tablet view reflows into fewer, larger tiles that remain legible and tappable. This keeps one governed source of truth instead of divergent copies.

Answer

Keep one dense layout but increase the font size of every label until it is legible on the tablet, accepting overlap on the display.

Answer

Publish two entirely separate dashboard files and ask users to remember which URL corresponds to their device type.

Answer

Fix the dashboard to a single wide canvas and instruct tablet users to rotate to landscape and scroll horizontally.

Question 5

A data analyst is designing a dashboard that will be viewed on both desktop monitors and mobile devices. The dashboard contains several charts and KPI cards. Which design approach best ensures usability across these devices?

Accepted Answer

Implement a responsive layout that rearranges and resizes elements based on screen size. Implementing a responsive layout is the best approach because it dynamically adjusts the dashboard's elements to fit any screen size, ensuring that charts and KPIs are legible and interactive on both desktop and mobile. This avoids the pitfalls of horizontal scrolling, separate maintenance, and unreadable compact designs.

Answer

Use small fonts and compact charts to fit more information on mobile screens

Answer

Use a fixed-width layout with horizontal scrolling for mobile users

Answer

Create two separate dashboards: one for desktop and one for mobile

Question 6

A data analyst has built a dashboard tracking monthly active users (MAU) for a mobile app over the past two years. The executive sponsor complains that the line chart is hard to read because the y-axis starts at zero, making month-to-month variation look small. The analyst wants to emphasize the trend and small fluctuations while still being honest about the data. Which change to the y-axis is most appropriate?

Accepted Answer

Set the y-axis minimum to a value slightly below the lowest MAU value in the period.. Truncating the y-axis to start just below the lowest value highlights the changes the executive wants to see without falsifying the data. The other options either keep the chart flat, introduce unnecessary complexity, or use scales that obscure the trend. Clear labeling and context are essential when using a non-zero baseline.

Answer

Set the y-axis minimum to zero and add a secondary axis showing percentage change.

Answer

Apply a logarithmic scale to the y-axis starting at one.

Answer

Convert the line chart to a stacked area chart with the y-axis starting at zero.

Question 7

A data analyst is creating a report to summarize customer satisfaction survey results. The survey asked customers to rate their satisfaction on a scale from 1 (very dissatisfied) to 5 (very satisfied). The analyst wants to show the number of respondents for each rating level. Which visualization is most appropriate?

Accepted Answer

Bar chart. A bar chart is the most appropriate visualization for showing the frequency of categorical data like satisfaction ratings. It clearly displays the count for each rating level, allowing easy comparison. Other chart types either imply a trend, assume continuous data, or make comparison difficult.

Answer

Line chart

Answer

Pie chart

Answer

Histogram

Question 8

A data analyst is designing a report that will be viewed on a large monitor in a conference room. The report includes a heatmap of customer satisfaction scores across different regions and time periods. The analyst notices that the color scale uses a rainbow gradient, and some viewers have difficulty distinguishing between adjacent colors. Which change should the analyst make to improve the readability of the heatmap?

Accepted Answer

Switch to a sequential color palette with varying lightness.. Switching to a sequential color palette that varies in lightness improves the heatmap's readability by making value differences easier to perceive. Lightness is a more effective visual encoding than hue, especially for viewers with color vision deficiencies, and it aligns with best practices for visualizing continuous data like satisfaction scores.

Answer

Use a diverging color palette with red and green at the extremes.

Answer

Add data labels to every cell in the heatmap to show exact values.

Answer

Increase the number of colors in the rainbow gradient to provide more detail.

Question 9

A junior analyst is asked to show how total monthly support ticket volume changed over the past 24 months so leadership can spot seasonal peaks. Which visualization is most appropriate?

Accepted Answer

A line chart with months on the horizontal axis and ticket volume on the vertical axis.. Monthly ticket volume across 24 periods is a time series, and a line chart is the canonical encoding for ordered continuous change. Connecting the points lets readers perceive slope, peaks, and repeating seasonal cycles at a glance. The horizontal axis preserves chronological order, which is what distinguishes a trend display from a categorical comparison.

Answer

A stacked bar chart of ticket categories per month.

Answer

A scatter plot of ticket volume against month index.

Answer

A pie chart with one slice per month.

Question 10

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

Accepted Answer

Apply a conditional formatting rule that changes the metric's background to a bright color (e.g., red) and displays an alert icon when the threshold is exceeded.. For real-time monitoring, the most critical metric should have a dynamic visual alert when it crosses a threshold. Conditional formatting with a bright background and an alert icon localizes the cue to the metric itself, making it immediately noticeable without distracting from other information. This approach balances salience with usability.

Answer

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

Answer

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

Answer

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

Question 11

A data analyst is preparing a monthly performance report for a hospital network. The report will be distributed as a static PDF and must let department heads compare readmission rates across eight hospitals for the current month. The analyst wants the visual to remain accurate if the PDF is printed in grayscale. Which TWO design choices should the analyst make? (Choose two.)

Accepted Answer

Add direct data labels showing the readmission rate at the end of each hospital bar. A single-hue sequential scale preserves lightness contrast in grayscale, and direct data labels make the exact readmission rate readable regardless of color. Together they provide redundant encoding, so the comparison remains accurate on screen and in black-and-white print. Saturated multi-hue palettes, diverging red-green scales, and axis-free alphabetical layouts all undermine either grayscale legibility or the ability to compare values.

Answer

Use a red-to-green diverging scale centered on the network average readmission rate

Answer

Sort the hospitals alphabetically and omit any value axis to reduce clutter

Answer

Encode each hospital with a distinct saturated hue and rely on the legend

Question 12

A data analyst must build a one-page dashboard for a hospital's bed-management team. The team needs to know, at a glance, how many beds are free right now, how that compares with the same hour yesterday, and whether the trend is worsening. Which combination of visual elements is MOST appropriate for the top band of this dashboard?

Accepted Answer

A single large number (KPI card) for current free beds, a smaller comparison value for yesterday, and a sparkline showing the last 24 hours.. The request is for a glanceable status band answering three linked questions: current value, comparison to a prior equivalent period, and direction. A KPI card paired with a comparison figure and a sparkline delivers exactly that combination with minimal reading effort. Composition, correlation, row-level detail, and spatial views all answer different questions and would slow the team's decision.

Answer

A pie chart of free beds by ward, a stacked bar of occupied versus free beds, and a scatter plot of admissions against discharges.

Answer

A detailed table listing every bed, its ward, and its last-cleaned timestamp, sorted by ward name.

Answer

A geographic map of the hospital campus with color-coded buildings and a legend explaining each ward's capacity.

Question 13

A data analyst is designing a dashboard for hospital administrators to monitor emergency department (ED) wait times. The dashboard will be viewed on large wall-mounted displays in the operations center and must be readable from a distance. The analyst wants to ensure the dashboard effectively communicates urgent situations. Which two design choices are most appropriate? (Choose two.)

Accepted Answer

Use a red-yellow-green color scale for wait-time thresholds, with red indicating waits exceeding the target.. The red-yellow-green color scale and large, high-contrast fonts directly address the need for rapid, distance-readable communication of urgent wait times. The other options introduce clutter, privacy risks, or visual distortions that hinder quick comprehension. Effective operational dashboards prioritize clarity and immediate signal detection.

Answer

Add a live scrolling ticker at the bottom showing individual patient wait times to provide full transparency.

Answer

Include a detailed data table below each chart showing the last 24 hours of wait times in 15-minute increments.

Answer

Use a 3D pie chart to show the proportion of patients in each triage category, as it is visually engaging.

Question 14

A data analyst is building a dashboard that includes a filter for 'Region'. The dashboard also contains a table showing sales by product category. The analyst wants to ensure that when a user selects a region from the filter, the table updates to show only sales for that region. Which feature should the analyst configure?

Accepted Answer

Action filter. An action filter is the correct feature to enable cross-visual filtering. It allows a selection in one visual (the region filter) to dynamically filter another visual (the table). This creates an interactive dashboard where users can explore data by region without manually adjusting multiple filters.

Answer

Calculated field

Answer

Data blending

Answer

Parameter

Question 15

A data analyst publishes a quarterly financial report in which the same revenue figure is printed on a summary page, a regional breakdown page, and an appendix table. The three values currently come from three separately written queries. Which practice most directly reduces the risk of the pages disagreeing?

Accepted Answer

Define the revenue metric once in a governed semantic layer and have all three pages consume that shared definition.. When one metric appears in several places, the durable fix is to compute it once in a governed semantic layer and let every consumer reference that definition. Shared logic removes the class of error where independently authored queries drift in filters, joins, or aggregation. Consistency then becomes a property of the architecture rather than of individual author diligence.

Answer

Increase the refresh frequency of all three queries so they run within the same hour.

Answer

Add a footnote to each page stating the date the query was last executed.

Answer

Instruct each report author to cross-check their number against the other two pages before publishing.