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

Question 1

A data analyst is building a dashboard for executives and wants to ensure the most important metric, total revenue, is immediately visible. Which design principle should the analyst apply?

Accepted Answer

Visual hierarchy. Visual hierarchy is the design principle of arranging elements so the most important information draws the eye first, typically through size, position, color contrast, or whitespace. Placing total revenue prominently (e.g., top-left, largest font, high-contrast KPI card) ensures executives see it immediately. This directly addresses the requirement to make the key metric immediately visible.

Answer

Appropriate precision

Answer

Consistent color coding

Answer

Data-ink ratio

Question 2

Which of the following is a key difference between a Key Performance Indicator (KPI) and a metric?

Accepted Answer

KPIs are tied to strategic objectives, while metrics are broader operational measurements. A KPI is a metric that is explicitly tied to a strategic business objective — it measures progress toward a goal the organization cares about (e.g., customer retention rate). A metric is any quantifiable measurement (e.g., page views, CPU utilization) that may or may not be strategically important. The key distinction is the linkage to strategy, not the data type or leading/lagging nature.

Answer

Metrics are always quantitative, while KPIs can be qualitative

Answer

There is no difference; the terms are interchangeable

Answer

KPIs are always lagging indicators, while metrics are leading indicators

Question 3

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?

Accepted Answer

Scatter plot. 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.

Answer

Line chart

Answer

Bar chart

Answer

Histogram

Question 4

In Power BI, an analyst wants to create a measure that calculates the total sales for the current year up to the latest date in the data. Which DAX function should be used?

Accepted Answer

TOTALYTD. TOTALYTD is a time intelligence function that sums values for the year up to the last date in the filter context (or specified end date).

Answer

SAMEPERIODLASTYEAR

Answer

CALCULATE

Answer

SUMX

Question 5

A data analyst needs to visualize the distribution of customer ages in a dataset. The analyst wants to see the frequency of ages grouped into bins. Which chart type should be used?

Accepted Answer

Histogram. A histogram is the correct choice because it is purpose-built for showing the frequency distribution of a continuous numeric variable by grouping values into bins (e.g., ages 18–25, 26–33). Each bar's height represents the count of observations falling into that bin, directly answering the analyst's need to see frequency by age group. Unlike a bar chart, the bars are adjacent with no gaps, reflecting the continuous nature of the underlying variable.

Answer

Pie chart

Answer

Box plot

Answer

Bar chart

Question 6

Which chart type is best for showing the number of website visitors at each stage of a conversion funnel, from initial visit to purchase?

Accepted Answer

Funnel chart. A funnel chart is specifically designed to visualize the progressive reduction in volume across stages of a linear process, such as a conversion funnel. It clearly shows the number of visitors at each stage (e.g., initial visit, product view, add to cart, purchase) and the drop-off between them, making it the optimal choice for this scenario.

Answer

Stacked bar chart

Answer

Treemap

Answer

Waterfall chart

Question 7

In Tableau, an analyst wants to create a calculated field that returns the average sales per customer only for customers who have made more than five purchases. Which Tableau function or approach would be most efficient?

Accepted Answer

Use a Level of Detail expression to count purchases per customer, then filter. A Level of Detail (LOD) expression such as {FIXED [Customer] : COUNT([Order ID])} computes the purchase count per customer independently of the view's granularity, which can then be used in a filter or conditional calculation. This is the canonical Tableau approach for row-level filtering based on aggregated per-entity metrics. It is efficient because it pushes the aggregation to the data source level.

Answer

Use a table calculation for running sum

Answer

Use a context filter on the number of records

Answer

Create a parameter to filter customers

Question 8

A data analyst is presenting a time-series chart of monthly sales to executives. The sales dropped sharply in March due to a one-time supply chain disruption. Which storytelling technique would best help the audience understand this anomaly?

Accepted Answer

Add an annotation explaining the supply chain disruption. Adding an annotation directly on the chart provides immediate context for the March sales drop, allowing executives to understand the anomaly without leaving the visualization. This technique follows the principle of 'contextual annotation' in data storytelling, where key events are marked to prevent misinterpretation of trends. It preserves data integrity while clarifying the cause, which is essential for accurate decision-making.

Answer

Remove the March data point to avoid confusion

Answer

Use a different chart type to hide the drop

Answer

Use a moving average to smooth the drop

Question 9

A sales analyst is designing a report for the sales team that includes the number of new leads, conversion rate, and total revenue. The team wants to identify which metrics are Key Performance Indicators (KPIs) tied to the strategic goal of increasing revenue. Which TWO of the following should be classified as KPIs?

Accepted Answer

Total revenue. Total revenue is a direct measure of the strategic goal of increasing revenue, making it a clear Key Performance Indicator (KPI). It quantifies the financial outcome that the sales team is aiming to improve, aligning perfectly with the stated objective.

Answer

Average deal size

Answer

Customer satisfaction score

Answer

Number of new leads

Question 10

A business analyst needs to show the monthly sales trend for the past three years. Which chart type is most appropriate?

Accepted Answer

Line chart. A line chart is the standard visualization for showing a continuous trend over time, with time on the x-axis and the measured value on the y-axis. Monthly sales across three years is a time series, so a line chart clearly reveals trends, seasonality, and growth patterns. It is the most appropriate choice for this analytical goal.

Answer

Histogram

Answer

Pie chart

Answer

Scatter plot

Question 11

A data analyst wants to compare the revenue across five different product categories. Which chart type is best suited?

Accepted Answer

Bar chart. A bar chart is the best choice for comparing a categorical variable (five product categories) against a quantitative measure (revenue). Each category gets its own bar, making relative magnitudes easy to compare side by side. Bar charts handle a small number of discrete categories cleanly, which matches this scenario exactly.

Answer

Scatter plot

Answer

Pie chart

Answer

Line chart

Question 12

In Tableau, you want to create a view showing the total sales per region, but also want to allow users to filter by year without losing the ability to see all regions. What feature should you use to compute the total sales that ignores the year filter?

Accepted Answer

LOD expression: { FIXED [Region] : SUM([Sales]) }. A Level of Detail (LOD) expression with FIXED can compute a value at the region level, ignoring other dimensions like year.

Answer

Table calculation running total

Answer

Parameter action

Answer

Calculated field using SUM([Sales])

Question 13

When designing a dashboard for executives, which principle is most important to follow to ensure key information is immediately visible?

Accepted Answer

Create a visual hierarchy with the most important metric prominently displayed.. Visual hierarchy places the most important metric in the prime viewing position (typically top-left or center-top) with the largest size and strongest contrast, so an executive scanning for five seconds immediately sees the headline number. This is the defining principle of executive dashboard design because executives consume dashboards in brief, infrequent glances rather than deep analytical sessions.

Answer

Apply consistent color coding across all charts.

Answer

Use as many colors as possible to highlight different data points.

Answer

Include all available data to provide complete context.

Question 14

Which chart type is best for displaying the distribution of a continuous variable, such as the age distribution of customers?

Accepted Answer

Histogram. A histogram is the correct choice because it groups continuous data (like age) into bins along the x-axis and displays the frequency of observations within each bin as bars, making the distribution shape immediately visible. This directly addresses the need to show how customer ages are spread across the range, which is the definition of a distribution for a continuous variable.

Answer

Box plot

Answer

Line chart

Answer

Pie chart

Question 15

A marketing manager wants to visualize the conversion funnel from website visits to final purchase. Which chart type is most appropriate?

Accepted Answer

Funnel chart. Funnel charts are specifically designed to show stages in a pipeline or conversion process, with decreasing values as prospects move through the funnel.

Answer

Treemap

Answer

Waterfall chart

Answer

Scatter plot