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

Question 1

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?

Accepted Answer

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

Answer

Scatter plot

Answer

Histogram

Answer

Box plot

Question 2

A sales analyst wants to show total sales by product category, with each category's contribution to the total. Which chart type is best?

Accepted Answer

Stacked bar chart. A stacked bar chart shows each product category as a bar segment whose height represents its sales contribution, and the total bar height represents overall sales — simultaneously displaying both individual contributions and the whole. This directly satisfies the requirement to show total sales by category with each category's contribution.

Answer

Scatter plot

Answer

Box plot

Answer

Line chart

Question 3

In Power BI, a developer needs to create a measure that calculates total sales for the same period last year. Which DAX function should be used?

Accepted Answer

SAMEPERIODLASTYEAR. SAMEPERIODLASTYEAR is a DAX time intelligence function that returns a table of dates shifted back exactly one year, ideal for year-over-year comparisons. It is specifically designed for calculating metrics like total sales for the same period last year when used with a date table. This function is simple and directly addresses the requirement.

Answer

TOTALYTD

Answer

PARALLELPERIOD

Answer

DATEADD

Question 4

A dashboard designer wants to ensure that the most important metric, such as total revenue, is prominently displayed at the top left. Which dashboard design principle is being applied?

Accepted Answer

Visual hierarchy. Visual hierarchy is the design principle of arranging elements so the most important information draws attention first, typically through size, position, color, or contrast. Placing total revenue at the top left leverages the natural reading pattern (F-pattern or Z-pattern) and prominence of that location to signal importance. This is exactly what visual hierarchy governs.

Answer

Consistent color coding

Answer

Appropriate precision

Answer

Data-ink ratio

Question 5

A data analyst is creating a dashboard for a retail company. Which TWO of the following are considered Key Performance Indicators (KPIs) tied to strategic objectives?

Accepted Answer

Year-over-year revenue growth. Year-over-year revenue growth (D) is a strategic KPI because it directly measures the company's financial performance against prior periods, showing whether long-term growth objectives are being met. Customer retention rate (E) is also a strategic KPI since retaining existing customers reflects loyalty, satisfaction, and sustainable revenue, which are core strategic goals for a retail business. In contrast, average handle time per call (A) is an operational efficiency metric for support teams, not a strategic objective. Number of products in inventory (B) is an inventory management measure, and daily number of customer service calls (C) is a volume/activity metric; neither directly indicates progress toward strategic business goals.

Answer

Average handle time per call

Answer

Number of products in inventory

Answer

Daily number of customer service calls

Question 6

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?

Accepted Answer

Resolution: By diversifying suppliers, sales recovered in November.. The question asks for the three elements of a narrative arc, which are Situation, Complication, and Resolution. Option C is correct because it establishes the Situation, the baseline context that Q3 sales were on track to meet targets, which sets the stage for the story. Option E is correct because it introduces the Complication, the supply chain disruption that caused the October drop, creating the conflict or turning point. Option B is correct because it provides the Resolution, explaining how diversifying suppliers led to recovery in November, which closes the narrative arc. Option A is not correct because a random color scheme for every chart harms visual consistency and does not contribute to a narrative arc. Option D is not correct because a detailed description of each product's sales breakdown is granular data detail, not a structural element of the narrative arc.

Answer

Random color scheme for every chart

Answer

Detailed description of each product's sales breakdown

Question 7

Which TWO of the following are leading indicators that can help predict future performance?

Accepted Answer

Website traffic. Website traffic (C) is a leading indicator because it measures top-of-funnel visitor activity that precedes and predicts future conversions, revenue, and customer acquisition, rather than reporting results that have already occurred. Number of qualified leads (D) is also a leading indicator because qualified leads represent prospects who have shown buying intent and are likely to convert into customers in future periods, directly forecasting upcoming sales performance. By contrast, net profit margin (A), monthly revenue (B), and customer churn rate (E) are lagging indicators: they report outcomes that have already happened (profitability, realized sales, and lost customers) and therefore confirm past performance rather than predict future performance.

Answer

Net profit margin

Answer

Monthly revenue

Answer

Customer churn rate

Question 8

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?

Accepted Answer

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

Answer

Line chart

Answer

Bar chart

Answer

Pie chart

Question 9

A dashboard designer is building a sales performance dashboard for executives. According to dashboard design principles, which TWO practices should be applied? (Choose two.)

Accepted Answer

Use color coding consistently to group related metrics. Option A is correct because consistent color coding lets executives instantly associate related metrics (e.g., all revenue measures in one hue) and compare them without reinterpreting the legend on each visual. Option B is correct because visual hierarchy—using size, position, and contrast to emphasize the single most important KPI—directs the executive's eye to the critical number first, which is a core dashboard design principle. Option C is wrong because titles and labels are essential for context and self-service interpretation; removing them creates ambiguity. Option D is wrong because excessive precision clutters the display and slows comprehension—executives need rounded, decision-relevant values. Option E is wrong because chartjunk (decorative, non-data elements) distracts from the message and violates the principle of maximizing the data-ink ratio.

Answer

Avoid titles and labels to keep the dashboard clean

Answer

Include excessive precision on all numbers to show accuracy

Answer

Maximize chartjunk to make the dashboard visually appealing

Question 10

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.)

Accepted Answer

SAMEPERIODLASTYEAR. TOTALYTD is correct because it is a time-intelligence function that evaluates an expression over the year-to-date interval, e.g., TOTALYTD(SUM(Sales[Amount]), 'Date'[Date]), which directly produces the year-to-date total sales the analyst needs. SAMEPERIODLASTYEAR is correct because it is a time-intelligence function that shifts the current date context back one year, returning the equivalent period from the prior year so the YTD figure can be compared to the same period last year. Together they satisfy the two comparison requirements in the scenario. FILTER is not a time-intelligence function; it returns a filtered table and would not by itself compute YTD or prior-year periods. RELATED is used to fetch a value from the many-side of a relationship, not for time comparisons. SUMX is an iterator that sums an expression row by row and does not handle year-to-date or prior-year logic.

Answer

FILTER

Answer

Answer

SUMX

Question 11

A data analyst is preparing a presentation for the executive team to explain why quarterly revenue fell short of targets. They want to use storytelling with data. Which THREE elements should be included in the narrative arc? (Choose three.)

Accepted Answer

Resolution: the recommended action or outcome. The narrative arc for storytelling with data follows a three-part structure: Situation, Complication, and Resolution. Option C (Situation: background and context) is correct because it establishes the setting and baseline — here, the quarterly revenue targets and prior performance — so the executive audience understands the starting point. Option E (Complication: the problem or challenge) is correct because it introduces the tension, namely that revenue fell short of targets, which is the core issue the presentation must explain. Option B (Resolution: the recommended action or outcome) is correct because it closes the arc by proposing what should be done next, giving executives a clear takeaway rather than leaving them with an unresolved problem. Option A (raw data tables with every transaction) is not part of the narrative arc; exhaustive transaction-level detail overwhelms an executive audience and belongs in an appendix, not the story. Option D (detailed explanation of data cleaning steps) is also excluded because data preparation methodology is a technical process detail, not a narrative element that advances the executive storyline.

Answer

Raw data tables with every transaction

Answer

Detailed explanation of data cleaning steps

Question 12

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.)

Accepted Answer

Box plot. A box plot (A) is appropriate because it summarizes the distribution of a continuous numeric variable like age using the median, quartiles, and potential outliers, giving a compact view of spread and skew across the 10,000 records. A histogram (C) is also appropriate because it bins the continuous age values into intervals and displays frequency counts, directly revealing the shape, center, and spread of the age distribution. A pie chart (B) is unsuitable because it shows parts of a whole for categorical data and cannot represent a continuous distribution of ages. A bar chart (D) is meant for comparing frequencies of discrete categories rather than showing the shape of a continuous distribution. A line chart (E) is designed to show trends over an ordered sequence such as time, not the distribution of a single numeric variable.

Answer

Pie chart

Answer

Bar chart

Answer

Line chart

Question 13

A business analyst is asked to distinguish between KPIs and metrics for a new dashboard. According to CompTIA Data+, which TWO statements correctly differentiate KPIs from metrics? (Choose two.)

Accepted Answer

KPIs are directly tied to strategic business objectives. Option C is correct because KPIs (Key Performance Indicators) are by definition tied directly to strategic business objectives — they measure how well an organization is progressing toward its most important goals, which is what distinguishes them from ordinary metrics. Option D is correct because metrics are general operational measurements (e.g., page views, CPU utilization, daily transaction counts) that track activity but are not necessarily linked to strategic objectives, whereas a KPI is a selected metric elevated for its strategic relevance. Options A, B, and E do not belong: KPIs and metrics are not interchangeable (A), importance is determined by strategic alignment rather than metrics always outranking KPIs (B), and KPIs can be leading or lagging indicators depending on the objective, so they are not always lagging (E).

Answer

KPIs and metrics are interchangeable terms

Answer

Metrics are always more important than KPIs

Answer

KPIs are always lagging indicators

Question 14

A retail company generates a daily PDF report showing the previous day's sales by region and product category. The report is automatically emailed to store managers at 6:00 AM. Which type of report is this?

Accepted Answer

Scheduled report. A scheduled report is generated automatically at a predefined time (6:00 AM daily) and delivered to recipients (store managers) via email. This matches the definition of a scheduled report, which runs on a recurring basis without manual intervention.

Answer

Self-service report

Answer

Ad hoc report

Answer

Operational report

Question 15

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?

Accepted Answer

An executive summary. An executive summary is a concise, standalone document that presents the most important findings and recommendations at the very beginning, tailored for senior leaders who need the key takeaway immediately. It allows the VP to grasp the campaign's outcome and recommended actions without reading the full report. This format directly matches the VP's stated preference for reading only the first paragraph.

Answer

A raw data extract

Answer

A detailed technical report

Answer

A data dictionary