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

Question 1

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 2

A data analyst wants to visualize the number of website visitors by traffic source (e.g., organic, paid social, email) and also show the proportion of each source within the total. Which chart type is best?

Accepted Answer

Stacked bar chart. A stacked bar chart is best because it allows the data analyst to display both the absolute number of visitors per traffic source and the proportional contribution of each source to the total across categories (e.g., time periods). Each bar represents the total visitors, and segments within the bar show the breakdown by source, making it easy to compare both individual source counts and their relative shares.

Answer

Histogram

Answer

Pie chart

Answer

Line chart

Question 3

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 4

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 designed to show progressive reductions as stages narrow.

Answer

Waterfall chart

Answer

Treemap

Answer

Bar chart

Question 5

Which of the following is a key performance indicator (KPI) tied to a strategic objective, as opposed to a metric?

Accepted Answer

Customer satisfaction score (CSAT) as a strategic goal. A key performance indicator (KPI) is a measurable value that demonstrates how effectively a company is achieving a key strategic objective. Here, 'Customer satisfaction score (CSAT) as a strategic goal' explicitly ties the metric to a strategic objective (e.g., improving customer loyalty), whereas a plain metric like 'average handle time' is an operational measure without a direct strategic link. In data visualization, KPIs are often displayed on dashboards with targets and thresholds to track progress toward high-level business goals.

Answer

Average handle time

Answer

Number of daily logins

Answer

Server uptime percentage

Question 6

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 7

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 8

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. Effective data storytelling includes a narrative arc, choosing the right chart, and annotating key events.

Answer

Include as much data as possible to avoid missing details

Answer

Always use pie charts for part-to-whole comparisons

Question 9

Which TWO are examples of leading indicators in a business context? (Select two.)

Accepted Answer

Customer engagement score. Leading indicators predict future performance; number of qualified leads and customer engagement score forecast future sales.

Answer

Employee turnover rate

Answer

Net profit margin

Answer

Monthly revenue

Question 10

A data analyst wants to show the sales trend for a product over the past 12 months. Which chart type is most appropriate?

Accepted Answer

Line chart. A line chart is the most appropriate choice because it explicitly shows data points over a continuous time interval, making it ideal for visualizing the sales trend over 12 months. The x-axis represents time (months), and the y-axis represents sales values, allowing the audience to easily see upward, downward, or cyclical patterns. This aligns with the core principle of time-series visualization, where line charts excel at highlighting trends and changes over sequential periods.

Answer

Bar chart

Answer

Pie chart

Answer

Histogram

Question 11

A dashboard designer is creating a KPI dashboard for executives. Which of the following is a leading indicator?

Accepted Answer

Number of qualified leads. Number of qualified leads is a leading indicator as it predicts future sales, while revenue and customer churn are lagging indicators.

Answer

Net profit margin

Answer

Monthly revenue

Answer

Customer churn rate

Question 12

In Tableau, a data analyst creates a calculated field to compute the average sales per customer. The analyst wants this calculation to remain constant regardless of the level of detail in the view. Which Tableau feature should be used?

Accepted Answer

Level of Detail expression. Level of Detail (LOD) expressions allow calculations to be performed at a specific granularity independent of the view. FIXED LOD can compute average sales per customer and remain constant.

Answer

Table calculation

Answer

Parameter

Answer

Filter

Question 13

A data analyst needs to visualize the distribution of customer ages in a dataset containing 10,000 records. The analyst wants to see the shape of the distribution and identify any outliers. Which chart type is most appropriate?

Accepted Answer

Histogram. A histogram shows the distribution of a continuous variable and can reveal shape and outliers when bins are appropriately sized.

Answer

Line chart

Answer

Box plot

Answer

Pie chart

Question 14

A BI analyst is creating a report in Power BI and needs to calculate the total sales for the current year compared to the previous year. Which DAX function should be used to calculate the previous year's sales?

Accepted Answer

SAMEPERIODLASTYEAR. SAMEPERIODLASTYEAR returns a set of dates in the previous year for the same period, which is ideal for year-over-year comparisons.

Answer

PREVIOUSYEAR

Answer

TOTALYTD

Answer

DATEADD

Question 15

Which chart type is best for visualizing the correlation between two continuous variables?

Accepted Answer

Scatter plot. Scatter plots show the relationship between two continuous variables, making them ideal for visualizing correlation.

Answer

Pie chart

Answer

Bar chart

Answer

Line chart