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

Question 1

An analyst creates a scatter plot with three variables: X, Y, and a third variable represented by the size of the markers. This chart is called a:

Accepted Answer

Bubble chart. A bubble chart is a variation of a scatter plot where a third numeric variable is encoded by the size (area) of the markers. This allows the visualization of three dimensions of data simultaneously on a two-dimensional plane, making it the correct choice for the described chart.

Answer

Heat map

Answer

Treemap

Answer

Waterfall chart

Question 2

A dashboard designer wants to ensure the most important KPI is prominently displayed at the top left. Which design principle is being applied?

Accepted Answer

Visual hierarchy. Visual hierarchy arranges elements by importance, typically placing the most critical information where the eye naturally starts (top left in Western cultures).

Answer

Consistent color coding

Answer

Data-ink ratio

Answer

Appropriate precision

Question 3

An analyst needs to display the number of website visitors per age group (e.g., 18-25, 26-35, 36-45). Which chart type is most appropriate?

Accepted Answer

Histogram. A histogram displays the distribution of a continuous variable (age) across bins (age groups).

Answer

Bar chart

Answer

Line chart

Answer

Pie chart

Question 4

In Tableau, which of the following is used to create a calculated field that aggregates data at a different level of detail than the view?

Accepted Answer

LOD expressions. LOD (Level of Detail) expressions allow you to compute aggregates at a granularity different from the view.

Answer

Marks

Answer

Parameters

Answer

Dashboard actions

Question 5

A data analyst is presenting a story about declining sales. The narrative arc should include which three elements in order?

Accepted Answer

Situation → Complication → Resolution. A compelling data story about declining sales follows the classic narrative arc: Situation (establish context, e.g., 'Sales were steady in Q1'), Complication (introduce the conflict, e.g., 'Then a 20% drop occurred in Q2'), and Resolution (present the insight or action, e.g., 'We identified the cause and implemented a new pricing strategy'). This order mirrors the 'Situation-Complication-Resolution' framework used in data storytelling to guide the audience logically from context to problem to solution.

Answer

Resolution → Complication → Situation

Answer

Situation → Resolution → Complication

Answer

Complication → Situation → Resolution

Question 6

In Looker Studio, what is the difference between dimensions and metrics?

Accepted Answer

Dimensions are categorical; metrics are numerical. In Looker Studio, dimensions are fields that contain categorical data (e.g., text, dates, or geographic names) used to group and segment data, while metrics are numerical fields (e.g., counts, sums, averages) that can be aggregated. Option D is correct because this distinction is fundamental to how Looker Studio processes and visualizes data: dimensions define the rows or categories in a chart, and metrics provide the quantitative values to be measured.

Answer

Dimensions are used for aggregation; metrics are for grouping

Answer

Dimensions are numerical; metrics are categorical

Answer

Both can be categorical or numerical

Question 7

A data analyst is designing a dashboard for executives. Which TWO practices improve dashboard effectiveness? (Select two.)

Accepted Answer

Including clear labels and titles for all charts. Clear labels and titles help interpretation; consistent color coding aids quick comprehension.

Answer

Adding decorative images to make the dashboard visually appealing

Answer

Displaying data with high precision (e.g., 4 decimal places)

Answer

Using many different colors to highlight every data point

Question 8

A sales analyst is building a report to analyze quarterly performance. Which THREE are appropriate uses of a formula language or a data transformation tool? (Select three.)

Accepted Answer

Using a data transformation tool to remove duplicate rows from the data source. Data transformation tools are specifically designed for data cleaning and preparation tasks, such as removing duplicate rows from a data source before the data is loaded into the analysis model. This is a standard ETL operation that such tools handle efficiently using their deduplication features, which is not a function of a formula language.

Answer

Using an iterative summation function to sum a column without using iteration

Answer

Using a lookup function to create a calculated column from a related table

Question 9

An analyst is choosing a chart to show the correlation between two continuous variables. Which TWO chart types could be used? (Select two.)

Accepted Answer

Bubble chart. A bubble chart is an extension of a scatter plot that can show the correlation between two continuous variables on the x- and y-axes, while a third variable is represented by the size of the bubbles. For the specific purpose of showing correlation between exactly two continuous variables, the bubble chart is valid because the bubble size is optional and does not interfere with the primary x-y relationship. This makes it a correct choice for visualizing the relationship between two continuous variables.

Answer

Pie chart

Answer

Waterfall chart

Answer

Histogram

Question 10

A data analyst wants to show the relationship between advertising spend and sales revenue for 50 stores. Which chart type is most appropriate?

Accepted Answer

Scatter plot. A scatter plot is the most appropriate chart for showing the relationship between two continuous variables—advertising spend and sales revenue—across 50 stores. Each point on the plot represents one store, allowing the analyst to visually assess correlation, trends, or outliers. This aligns with the DA0-001 objective of selecting visualizations that best represent bivariate relationships.

Answer

Line chart

Answer

Bar chart

Answer

Pie chart

Question 11

A dashboard designer wants to maximize the data-ink ratio. Which action should they take?

Accepted Answer

Remove redundant gridlines. Data-ink ratio is maximized by removing non-data ink (chartjunk) like unnecessary gridlines and borders.

Answer

Add a 3D effect to bars

Answer

Include a company logo in the chart area

Answer

Use a colorful background

Question 12

In Power BI, a data analyst needs to create a measure that calculates total sales for the current year. Which DAX function should be used?

Accepted Answer

TOTALYTD. TOTALYTD is a time intelligence function that calculates a running total for the year-to-date.

Answer

SAMEPERIODLASTYEAR

Answer

CALCULATE

Answer

SUMX

Question 13

Which chart type is best for showing the distribution of a continuous variable, such as customer ages?

Accepted Answer

Histogram. A histogram is the correct choice because it groups continuous data (like customer ages) into bins along a continuous x-axis, displaying the frequency distribution through bar heights. This directly shows the shape, spread, and central tendency of the variable, which is the core requirement for visualizing a continuous distribution.

Answer

Bar chart

Answer

Pie chart

Answer

Box plot

Question 14

A data analyst wants to show the monthly sales trend for the past two years with an emphasis on cumulative growth. Which chart type is most appropriate?

Accepted Answer

Area chart. An area chart is the most appropriate choice because it combines a line chart's ability to show trends over time with a filled area beneath the line, which visually emphasizes cumulative growth. For monthly sales data over two years, the area fill makes it easy to see both the month-over-month trend and the total accumulated sales volume, which is exactly what the data analyst needs.

Answer

Scatter plot

Answer

Bar chart

Answer

Line chart

Question 15

In Tableau, an analyst wants to create a parameter that allows users to select a threshold for highlighting products with sales above that value. The parameter is used in a calculated field that returns TRUE if sales exceed the parameter value. Which type of calculated field is this?

Accepted Answer

Boolean calculation. A Boolean calculated field returns TRUE or FALSE based on a condition.

Answer

Table calculation

Answer

Aggregate calculation

Answer

Level of Detail expression