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

Question 1

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 in Tableau allow you to compute aggregations at a specified granularity that can be finer or coarser than the view's level of detail. They are written using curly braces with keywords FIXED, INCLUDE, or EXCLUDE, and they enable calculations like average sales per customer regardless of the dimensions in the view. This directly addresses the need to aggregate data at a different level of detail than the view.

Answer

Marks

Answer

Parameters

Answer

Dashboard actions

Question 2

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 3

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 4

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. Option A is correct because clear labels and titles for all charts give executives immediate context for what each visual represents, eliminating ambiguity and reducing the cognitive effort needed to interpret the data, which is essential for fast executive decision-making. Option D is correct because consistent color coding for similar metrics across charts lets viewers track the same measure (e.g., revenue always in blue) across multiple visuals without re-learning the legend each time, improving comparability and reducing misinterpretation. Option B is not appropriate because decorative images add visual clutter and consume dashboard space without conveying analytical value, distracting from the data. Option C is incorrect because displaying data with high precision such as 4 decimal places creates unnecessary detail that obscures trends and slows comprehension at the executive level, where rounded or aggregated values are more useful. Option E is incorrect because using many different colors to highlight every data point destroys visual hierarchy and makes it impossible to distinguish meaningful patterns or exceptions.

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 5

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 6

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 7

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

Accepted Answer

Remove redundant gridlines. The data-ink ratio, a concept from Edward Tufte, is maximized by removing non-data ink — elements that do not convey information. Redundant gridlines add visual clutter without adding data value, so removing them directly increases the ratio. The other options all add non-data ink (3D effects, logos, colorful backgrounds) that reduce the ratio.

Answer

Add a 3D effect to bars

Answer

Include a company logo in the chart area

Answer

Use a colorful background

Question 8

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 9

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 calculated field that returns TRUE or FALSE based on a condition is a Boolean calculation. In Tableau, Boolean calculated fields produce logical values (True/False) and are often used for filtering, highlighting, or conditional formatting. Here, the field compares Sales to a parameter value and returns TRUE when Sales exceeds the threshold, which is a classic Boolean expression. The parameter allows dynamic threshold selection, but the output type of the calculation is Boolean.

Answer

Table calculation

Answer

Aggregate calculation

Answer

Level of Detail expression

Question 10

A dashboard should be designed so that the most important metric is prominently displayed. This is an example of which design principle?

Accepted Answer

Visual hierarchy. Visual hierarchy is the design principle that dictates arranging elements to guide the viewer's eye to the most important information first. By making the key metric the most prominent element (e.g., larger, bolder, or top-left), the dashboard ensures immediate comprehension of the primary data point, which is critical for operational decision-making.

Answer

Data-ink ratio

Answer

Consistent color coding

Answer

Appropriate precision

Question 11

In Looker Studio, a data analyst has two data sources: one with customer IDs and transactions, and another with customer demographics. They need to create a chart that includes fields from both sources. Which feature should they use?

Accepted Answer

Data blending. Data blending in Looker Studio allows you to combine data from two or more separate data sources based on a common key (e.g., customer ID). This enables you to create a chart that uses fields from both the transactions source and the demographics source without needing to merge the data at the database level. Without blending, a single chart can only reference fields from one data source at a time.

Answer

Calculated fields

Answer

Community connectors

Answer

Dashboard filters

Question 12

A sales manager wants to see the conversion rates at each stage of the sales pipeline, from initial contact to closed deal. Which chart type is most appropriate?

Accepted Answer

Funnel chart. A funnel chart is purpose-built to show sequential stages of a process and the progressive reduction in count or value at each stage, making it ideal for visualizing sales pipeline conversion from initial contact to closed deal. The tapering shape visually communicates drop-off at each stage, which is exactly what the sales manager needs.

Answer

Waterfall chart

Answer

Treemap

Answer

Bar chart

Question 13

An analyst creates a bar chart showing average sales by region. They want to ensure that the y-axis starts at zero to avoid misleading interpretation. This practice aligns with which dashboard design principle?

Accepted Answer

Appropriate precision. Starting the y-axis at zero is a fundamental practice to ensure that the visual representation of data (bar heights) accurately reflects the actual values, preventing exaggeration or minimization of differences. This principle directly supports 'Appropriate Precision' by maintaining the integrity of the data visualization and avoiding misleading interpretations, which is a key consideration in dashboard design.

Answer

Visual hierarchy

Answer

Clear labels and titles

Answer

Data-ink ratio

Question 14

Which TWO chart types are appropriate for visualizing the distribution of a continuous variable? (Select two.)

Accepted Answer

Box plot. A box plot (B) is appropriate for visualizing the distribution of a continuous variable because it displays the median, quartiles, and potential outliers, providing a five-number summary of the data. A histogram (D) is also appropriate as it groups continuous data into bins and shows the frequency distribution, revealing the shape, central tendency, and spread of the variable.

Answer

Bar chart

Answer

Line chart

Answer

Pie chart

Question 15

A data analyst is designing a dashboard for executives to monitor company performance. Which THREE practices should the analyst follow to ensure effective storytelling with data? (Select three.)

Accepted Answer

Annotate key events on time-series charts. Option A is correct because annotating key events (such as product launches, outages, or policy changes) directly on time-series charts gives executives immediate context for spikes and dips, turning raw trends into an explanatory story rather than an unexplained line. Option D is correct because selecting the chart type that matches the intended message — for example, line charts for trends over time, bar charts for comparisons across categories, and scatter plots for correlation — ensures the visual encoding reinforces the insight instead of obscuring it. Option E is correct because structuring the dashboard around a narrative arc (situation, complication, resolution) mirrors how executives reason about performance: it establishes the baseline, highlights the deviation or problem, and points to the recommended action. Option B is not appropriate because cramming in as much data as possible creates clutter and cognitive overload, which undermines clarity and focus on the key message. Option C is not appropriate because pie charts are generally poor for part-to-whole comparisons with many categories and are widely discouraged in favor of bar charts, so 'always' using them is not an effective storytelling practice.

Answer

Include as much data as possible to avoid missing details

Answer

Always use pie charts for part-to-whole comparisons