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

Question 1

An analyst needs to create a report in Power BI that shows year-to-date sales compared to the same period last year, with the ability to drill down from year to quarter. Which DAX function combination is most appropriate for the year-to-date calculation?

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

Accepted Answer

TOTALYTD and SAMEPERIODLASTYEAR. TOTALYTD calculates year-to-date values, and SAMEPERIODLASTYEAR shifts the comparison to the prior year. Together they allow YTD vs prior YTD comparison.

Answer

CALCULATE and ALL

Answer

SUM and FILTER

Answer

RANKX and TOPN

Question 2

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

Question 3

A data analyst is presenting a story about why customer churn increased last quarter. They start by showing the current churn rate, then identify a key event (a pricing change), and finally show the impact of a proposed retention campaign. This structure follows which narrative arc?

Accepted Answer

Situation → Complication → Resolution. The situation-complication-resolution arc sets up the current state, introduces a problem, and then presents a solution.

Answer

Introduction → Methods → Results

Answer

Hook → Context → Call to action

Answer

Problem → Solution → Evidence

Question 4

A data analyst needs to visualize the relationship between advertising spend and sales revenue for 50 products. Which chart type is most appropriate?

Accepted Answer

Scatter plot. A scatter plot is the most appropriate chart type for visualizing the relationship between two continuous variables—advertising spend and sales revenue—across 50 products. It allows the data analyst to assess correlation, trends, and potential outliers by plotting each product as a point on a Cartesian plane, with advertising spend on the x-axis and sales revenue on the y-axis.

Answer

Histogram

Answer

Bar chart

Answer

Pie chart

Question 5

In Looker Studio, you have a data source with daily sales and a separate data source with marketing spend. You want to create a chart that shows sales and marketing spend on the same axis, but the two sources are not joined natively. Which feature should you use to combine them?

Accepted Answer

Data blending. Data blending in Looker Studio allows you to combine data from multiple sources based on a common dimension without requiring a native join.

Answer

Filters

Answer

Community connectors

Answer

Calculated fields

Question 6

A data analyst is creating a dashboard and wants to maximize the data-ink ratio. Which action supports this principle?

Accepted Answer

Removing gridlines and reducing chart borders.. Removing unnecessary gridlines and decorative elements reduces non-data ink, thereby increasing the data-ink ratio. The data-ink ratio is the proportion of ink used to display data versus total ink used in the chart.

Answer

Including detailed data tables alongside charts.

Answer

Using 3D effects to make bars stand out.

Answer

Adding a background image to make the dashboard visually appealing.

Question 7

A data analyst is building a Power BI report to track KPIs for a retail chain. Which TWO of the following are considered leading indicators? (Choose two.)

Accepted Answer

Customer satisfaction score. Leading indicators predict future performance. Number of website visits and customer satisfaction score can foreshadow future sales, whereas total sales and profit margin are lagging indicators. Employee count is operational but not typically leading.

Answer

Number of employees

Answer

Profit margin

Answer

Total sales revenue

Question 8

A data analyst wants to visualize the distribution of customer ages, including quartiles and potential outliers, for a dataset with 10,000 records. Which TWO chart types are appropriate? (Choose two.)

Accepted Answer

Box plot. Box plots explicitly show quartiles and outliers. Histograms show distribution shape and can reveal outliers, but they don't directly show quartiles. However, both can be used to understand distribution and identify outliers.

Answer

Pie chart

Answer

Line chart

Answer

Treemap

Question 9

A senior data analyst is advising a team on dashboard design principles. Which THREE of the following are recommended best practices? (Choose three.)

Accepted Answer

Apply consistent color coding across all charts for similar metrics.. Maximizing data-ink ratio, using consistent color coding, and providing clear labels and titles are established best practices. Using many colors for variety is not recommended, nor is including every possible data point to avoid clutter.

Answer

Include every data point to provide complete context.

Answer

Use a variety of colors to make the dashboard visually exciting.

Question 10

A data analyst wants to visualize the monthly sales trend for the past year. Which chart type is most appropriate?

Accepted Answer

Line chart. Line charts are best for showing trends over time.

Answer

Bar chart

Answer

Pie chart

Answer

Scatter plot

Question 11

A sales manager wants to display the contribution of each product category to total revenue, with a maximum of six categories. Which chart type is most suitable?

Accepted Answer

Pie chart. A pie or donut chart is ideal for part-to-whole relationships with a limited number of categories (5-7 slices).

Answer

Histogram

Answer

Box plot

Answer

Scatter plot

Question 12

An analyst creates a dashboard with a large amount of decorative graphics and background images. According to CompTIA Data+, which design principle is being violated?

Accepted Answer

Data-ink ratio. The data-ink ratio, a concept from Edward Tufte, states that a visualization should maximize the proportion of ink used to represent actual data relative to total ink used. By adding excessive decorative graphics and background images, the analyst reduces this ratio, making the dashboard less efficient and potentially obscuring the data. CompTIA Data+ emphasizes minimizing non-data ink to improve clarity and insight extraction.

Answer

Visual hierarchy

Answer

Appropriate precision

Answer

Consistent color coding

Question 13

A data analyst wants to show the correlation between advertising spend and website traffic. Which chart type should they use?

Accepted Answer

Scatter plot. Scatter plots are designed to show the relationship between two numerical variables.

Answer

Area chart

Answer

Bar chart

Answer

Line chart

Question 14

In a Power BI report, a user wants to create a measure that calculates total sales for the current year up to today. Which DAX function should they use?

Accepted Answer

TOTALYTD. TOTALYTD is a time intelligence function that calculates year-to-date values.

Answer

CALCULATE

Answer

SUMX

Answer

SAMEPERIODLASTYEAR

Question 15

Which chart type is best for comparing the distribution of a continuous variable across different categories?

Accepted Answer

Box plot. Box plots provide a summary of distribution including median, quartiles, and outliers, making them ideal for comparing distributions across groups.

Answer

Pie chart

Answer

Histogram

Answer

Treemap