DA0-002 Practice Test 15 — 15 Questions

Question 1

A data analyst is performing data profiling on a customer table. Which TWO metrics are most useful for understanding the completeness of the data? (Choose two.)

Accepted Answer

Null count per column. Row count gives total records, null count gives missing values per column, both help assess completeness. Cardinality is for uniqueness, min/max for range, mean for central tendency.

Answer

Minimum and maximum values

Answer

Cardinality

Answer

Mean value

Question 2

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 3

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 4

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 5

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 6

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 7

A marketing analyst wants to visualize the conversion funnel from website visitors to paying customers. Which TWO chart types are suitable for showing this pipeline? (Choose two.)

Accepted Answer

Funnel chart. Funnel charts are designed for pipeline/conversion. Waterfall charts show incremental changes, which can also represent funnel stages. Scatter plots and bar charts are not ideal for funnel visualization.

Answer

Scatter plot

Answer

Pie chart

Answer

Bar chart

Question 8

A data analyst is creating a dashboard in Looker Studio for an e-commerce company. They want to display the average order value by product category, and also allow users to filter by date range. Which combination of elements should be used?

Accepted Answer

Dimension: Product Category; Metric: Average Order Value; Control: Date Range. In Looker Studio, dimensions are fields like product category, metrics are aggregations like average order value, and date range controls provide filtering.

Answer

Dimension: Order Value; Metric: Product Category; Control: Date Range

Answer

Dimension: Date; Metric: Product Category; Control: None

Answer

Dimension: Average Order Value; Metric: Product Category; Control: Date Range

Question 9

A data analyst is creating a dashboard in Tableau to monitor sales performance. The dashboard will be used by executives to quickly identify trends. Which THREE design principles should the analyst apply?

Accepted Answer

Clear labels and titles. Visual hierarchy ensures key metrics stand out; consistent color coding aids interpretation; clear labels prevent confusion. Data-ink ratio is important but not as critical for executive dashboards as clarity; including many interactive filters may clutter.

Answer

Maximize data-ink ratio

Answer

Include as many interactive filters as possible

Question 10

A business intelligence analyst is designing a dashboard for executives. The dashboard includes revenue, profit margin, and customer satisfaction score. To maximize the data-ink ratio, the analyst should:

Accepted Answer

Remove gridlines, use minimal colors, and avoid decorative elements. Maximizing data-ink ratio means removing non-data ink (chartjunk) and redundant labels, focusing on the data itself.

Answer

Add a background image of the company logo

Answer

Use different font styles for each metric label

Answer

Use 3D pie charts with shadow effects

Question 11

In Power BI, a developer needs to create a measure that calculates total sales for the same period last year. Which DAX function should be used?

Accepted Answer

SAMEPERIODLASTYEAR. SAMEPERIODLASTYEAR is a time intelligence function that returns dates from the previous year.

Answer

TOTALYTD

Answer

PARALLELPERIOD

Answer

DATEADD

Question 12

Which TWO of the following are leading indicators that can help predict future performance?

Accepted Answer

Website traffic. Leading indicators predict future outcomes; website traffic and number of qualified leads are forward-looking.

Answer

Net profit margin

Answer

Monthly revenue

Answer

Customer churn rate

Question 13

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 14

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

Question 15

An e-commerce company is merging customer data from three legacy systems. Two systems use email as unique identifier, but one system allows multiple customers per email. The third uses phone number. To create a unified customer view, the analyst should first:

Accepted Answer

Build a customer matching rule that uses multiple attributes (email, phone, name) with a confidence score. Merging data from systems with different identifier schemas requires a probabilistic matching approach. Using multiple attributes (email, phone, name) with a confidence score allows the analyst to resolve conflicts where email is not unique and phone numbers may be missing or formatted differently, creating a unified customer view without forcing a single key.

Answer

Request the IT team to modify the legacy system

Answer

Use email as primary key and ignore conflicts

Answer

Assign new unique IDs and discard existing identifiers