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

Question 1

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

Accepted Answer

Removing unnecessary gridlines. Data-ink ratio focuses on removing non-data ink (chartjunk) and emphasizing data. Using minimal gridlines reduces non-data ink.

Answer

Using 3D effects for bars

Answer

Adding a background image

Answer

Using bright colors for all elements

Question 2

In a Power BI report, a data analyst needs to create a measure that calculates the sum of sales only for products that have a profit margin greater than 10%. Which DAX function should be used to filter the calculation?

Accepted Answer

CALCULATE. CALCULATE modifies the filter context and can be combined with FILTER to apply specific conditions. SUMX iterates over a table but without CALCULATE it cannot apply the filter context properly in this scenario.

Answer

Answer

FILTER

Answer

SUMX

Question 3

A data analyst wants to show the proportion of total sales for each product category. There are 4 categories. Which chart type is most appropriate?

Accepted Answer

Pie chart. Pie charts are suitable for showing part-to-whole relationships when there are a limited number of categories (5-7 or fewer).

Answer

Line chart

Answer

Scatter plot

Answer

Histogram

Question 4

A data analyst is creating a dashboard in Looker Studio and needs to combine data from two different data sources using a common field. Which feature should be used?

Accepted Answer

Data blending. Blending in Looker Studio allows combining data from different sources based on a common dimension, similar to a left join.

Answer

Community connector

Answer

Filter

Answer

Calculated field

Question 5

A data analyst is presenting a story to executives about a decline in sales. The analyst wants to show the key events that led to the decline, such as a product recall and a competitor's launch. Which storytelling technique should be used?

Accepted Answer

Annotating the line chart with event markers. Annotating key events on a time-series chart directly links events to data changes, helping executives understand causes.

Answer

Using a pie chart to show current market share

Answer

Adding a waterfall chart to show incremental changes

Answer

Using a treemap to show hierarchical proportions

Question 6

A data analyst needs to visualize the distribution of salaries across departments and also compare the median and identify outliers. Which chart type is most suitable?

Accepted Answer

Box plot. Box plots display median, quartiles, and outliers, making them ideal for comparing distributions across categories.

Answer

Histogram

Answer

Bar chart

Answer

Scatter plot

Question 7

A data analyst is creating a dashboard for a sales team. Which TWO actions adhere to dashboard design best practices?

Accepted Answer

Using consistent color coding across charts. Using consistent color coding and placing the most important metric prominently are best practices. Using many bright colors and 3D effects are not.

Answer

Including 3D effects to make charts look more professional

Answer

Adding detailed axis labels and titles to every chart

Answer

Using as many bright colors as possible to make the dashboard attractive

Question 8

A data analyst is using Tableau to build a dashboard. Which THREE features are available in Tableau for creating interactive dashboards?

Accepted Answer

Dashboard actions. Parameters, calculated fields, and dashboard actions are key Tableau features for interactivity. LOD expressions are also available but not required for interactivity per se. Power Query is a Power BI feature.

Answer

DAX measures

Answer

Power Query

Question 9

A data analyst is creating a report in Power BI and needs to calculate the total sales for the current year and the previous year. Which TWO DAX functions can be used to retrieve the previous year's sales?

Accepted Answer

DATEADD. SAMEPERIODLASTYEAR and DATEADD (with -1 year) both can return dates from the previous year. PREVIOUSYEAR is invalid, TOTALYTD is for current year, and FILTER is not a time intelligence function.

Answer

TOTALYTD

Answer

FILTER

Answer

PREVIOUSYEAR

Question 10

A data analyst wants to show the distribution of customer ages for a retail store. The ages are continuous and the analyst needs to visualize the frequency of different age ranges. Which chart type is most appropriate?

Accepted Answer

Histogram. A histogram is used to display the distribution of a continuous variable by grouping data into bins.

Answer

Bar chart

Answer

Line chart

Answer

Pie chart

Question 11

A business analyst is creating a dashboard to monitor sales performance. The primary goal is to quickly identify which regions are underperforming compared to the target. Which design principle is most important to apply?

Accepted Answer

Visual hierarchy. Visual hierarchy ensures that the most important metrics (like underperforming regions) are prominently displayed, drawing the user's attention first.

Answer

Data-ink ratio

Answer

Appropriate precision

Answer

Consistent color coding

Question 12

A data analyst is creating a dashboard in Tableau to show monthly sales trends. The data source includes daily sales figures. The analyst needs to calculate the cumulative sales for each month and compare it to the same period last year. Which Tableau feature should be used for the year-over-year comparison?

Accepted Answer

Table calculations. Tableau's table calculations can compute running totals and year-over-year comparisons without modifying the data source.

Answer

Calculated fields

Answer

Level of Detail (LOD) expressions

Answer

Parameters

Question 13

A marketing manager wants to visualize the conversion rate at each stage of a sales funnel, from leads to closed deals. The data shows the number of prospects at each stage. Which chart type is most appropriate for this pipeline analysis?

Accepted Answer

Funnel chart. A funnel chart is specifically designed to show progressive reduction as data moves through stages of a process.

Answer

Treemap

Answer

Waterfall chart

Answer

Stacked bar chart

Question 14

A data analyst needs to show the relationship between advertising spend (in dollars) and the number of website visits. Both variables are continuous. Which chart type is most suitable?

Accepted Answer

Scatter plot. Scatter plots are ideal for visualizing the correlation between two continuous variables.

Answer

Line chart

Answer

Box plot

Answer

Bar chart

Question 15

A financial analyst wants to create a dashboard that shows the monthly profit and loss, highlighting how each component (revenue, cost of goods sold, operating expenses) contributes to the final net profit. Which chart type is most appropriate?

Accepted Answer

Waterfall chart. A waterfall chart effectively shows how each incremental positive or negative value contributes to a final total, making it ideal for profit/loss breakdowns.

Answer

Pie chart

Answer

Stacked bar chart

Answer

Area chart