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

Question 1

A data analyst is creating a report to compare the performance of sales regions across multiple years. The report will be used by regional managers to identify trends. Which visualization approach best supports this?

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

Accepted Answer

Small multiples of line charts, one per region. Small multiples (trellis charts) allow comparison of multiple time series in a compact, consistent layout, making it easy to spot trends across regions.

Answer

A single line chart with all regions overlaid

Answer

A bar chart with years on x-axis and regions as grouped bars

Answer

A stacked area chart with all regions

Question 2

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 3

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 both the total and the part-to-whole breakdown by category.

Answer

Scatter plot

Answer

Box plot

Answer

Line chart

Question 4

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?

Accepted Answer

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

Answer

Calculated field

Answer

LOD expression

Answer

Parameter

Question 5

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 time intelligence function that returns dates from the previous year.

Answer

TOTALYTD

Answer

PARALLELPERIOD

Answer

DATEADD

Question 6

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 arranges elements by importance, typically with key metrics at the top or top-left.

Answer

Consistent color coding

Answer

Appropriate precision

Answer

Data-ink ratio

Question 7

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. KPIs are tied to strategic goals; revenue growth and customer retention align with high-level business strategy.

Answer

Average handle time per call

Answer

Number of products in inventory

Answer

Daily number of customer service calls

Question 8

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.. A narrative arc in data storytelling typically includes situation (context), complication (problem), and resolution (recommendation or action).

Answer

Random color scheme for every chart

Answer

Detailed description of each product's sales breakdown

Question 9

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

Accepted Answer

Website traffic. Leading indicators predict future outcomes; website traffic and number of qualified leads are forward-looking.

Answer

Net profit margin

Answer

Monthly revenue

Answer

Customer churn rate

Question 10

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 used to visualize the correlation between two continuous variables.

Answer

Line chart

Answer

Bar chart

Answer

Pie chart

Question 11

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. Visual hierarchy emphasizes the most important metric, and clear labels ensure readability. Chartjunk should be minimized, not maximized.

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 12

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 computes year-to-date, and SAMEPERIODLASTYEAR shifts context to the prior year. CALCULATE modifies filter context, often used with time intelligence.

Answer

FILTER

Answer

Answer

SUMX

Question 13

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. Situation sets context, complication introduces the problem, and resolution provides the solution. Data details are not part of the high-level narrative arc.

Answer

Raw data tables with every transaction

Answer

Detailed explanation of data cleaning steps

Question 14

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

Accepted Answer

Funnel chart. 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.

Answer

Scatter plot

Answer

Pie chart

Answer

Bar chart

Question 15

An analyst is creating a Tableau dashboard for a logistics company. They need to allow users to filter data by region and time period, and also want to show a tooltip with detailed shipment information. Which THREE Tableau features should be used? (Choose three.)

Accepted Answer

Tooltips. Parameters allow user input for filtering, dashboard actions enable interactions across sheets, and tooltips display details on hover. Calculated fields are for custom calculations, and marks are for visual encoding.

Answer

Marks

Answer

Calculated fields