DA0-002 Practice Test 24 — 15 Questions

Question 1

Which of the following is a key difference between a Key Performance Indicator (KPI) and a metric?

Accepted Answer

KPIs are tied to strategic objectives, while metrics are broader operational measurements. KPIs are tied to strategic objectives and measure progress toward goals, while metrics can be any operational measurement that may not be directly linked to strategy.

Answer

Metrics are always quantitative, while KPIs can be qualitative

Answer

There is no difference; the terms are interchangeable

Answer

KPIs are always lagging indicators, while metrics are leading indicators

Question 2

A data analyst is preparing a dataset for analysis and needs to address data quality issues. Which TWO of the following are common data cleaning tasks?

Accepted Answer

Imputing missing values. Handling missing values and removing duplicates are standard data cleaning tasks.

Answer

Performing hypothesis testing

Answer

Building a regression model

Answer

Calculating correlation coefficients

Question 3

In logistic regression, the output is a probability between 0 and 1. If the predicted probability for a customer churning is 0.7 and the decision threshold is 0.5, what is the predicted class?

Accepted Answer

Churn (class 1). Since 0.7 > 0.5, the predicted class is churn (usually coded as 1).

Answer

Not churn (class 0)

Answer

Both classes equally likely

Answer

Uncertain, need more data

Question 4

Which TWO of the following are true about Pearson correlation coefficient (r)?

Accepted Answer

It measures the strength and direction of a linear relationship. Pearson r ranges from -1 to 1, measuring linear relationship; +1 indicates perfect positive linear correlation.

Answer

An r of 0 means no relationship exists

Answer

It ranges from 0 to 1

Answer

It can be used for categorical variables

Question 5

A data analyst is preparing data for a k-nearest neighbors algorithm. The features include age (0-100) and income (0-200,000). Which technique should be applied to ensure the distance metric is not dominated by income?

Accepted Answer

Min-max normalization. Min-max normalization scales features to a 0-1 range, ensuring each feature contributes equally to distance calculations.

Answer

Log transformation

Answer

Z-score standardization

Answer

One-hot encoding

Question 6

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 7

An analyst is creating a dashboard in Power BI to track sales performance. They want to ensure that when a user selects a specific product category on a slicer, all other visuals on the page filter to show data only for that category. Which TWO actions should the analyst take?

Accepted Answer

Edit interactions between the slicer and other visuals to ensure filtering is enabled. In Power BI, slicers by default filter all visuals on a page. However, if the analyst wants to ensure cross-filtering, they can edit interactions to enable filtering. Also, using the 'Sync slicers' pane is for syncing slicers across pages, not for enabling filtering. The 'Filters' pane is for manual filters, not for slicer interactions.

Answer

Use the 'Sync slicers' pane to synchronize the slicer across all pages

Answer

In the 'Format' pane, set the slicer to 'Single select'

Answer

Create a measure using the CALCULATE function with ALLEXCEPT

Question 8

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 9

An analyst is conducting an A/B test to compare two website designs. The null hypothesis is that there is no difference in conversion rates. The p-value obtained is 0.03, and the significance threshold is 0.05. What should the analyst conclude?

Accepted Answer

Reject the null hypothesis; there is a significant difference.. Since p-value (0.03) < α (0.05), we reject the null hypothesis, indicating a statistically significant difference.

Answer

Accept the alternative hypothesis that the new design is better.

Answer

The test is inconclusive; need a larger sample size.

Answer

Fail to reject the null hypothesis; there is no significant difference.

Question 10

A data analyst calculates the mean, median, and mode of a dataset. Which of the following best describes how these measures are used in descriptive statistics?

Accepted Answer

To describe the central tendency of the data. Descriptive statistics summarize data using measures like mean, median, and mode to describe central tendency.

Answer

To identify outliers using standard deviation

Answer

To test hypotheses about population parameters

Answer

To determine the probability of an event

Question 11

An analyst needs to create a report in Power BI that shows year-to-date sales compared to the same period last year, with the ability to drill down from year to quarter. Which DAX function combination is most appropriate for the year-to-date calculation?

Accepted Answer

TOTALYTD and SAMEPERIODLASTYEAR. TOTALYTD calculates year-to-date values, and SAMEPERIODLASTYEAR shifts the comparison to the prior year. Together they allow YTD vs prior YTD comparison.

Answer

CALCULATE and ALL

Answer

SUM and FILTER

Answer

RANKX and TOPN

Question 12

A data analyst is building a dashboard for executives and wants to ensure the most important metric, total revenue, is immediately visible. Which design principle should the analyst apply?

Accepted Answer

Visual hierarchy. Visual hierarchy means arranging elements so that the most important information is most prominent, often by placing it in the top-left or center and making it larger.

Answer

Appropriate precision

Answer

Consistent color coding

Answer

Data-ink ratio

Question 13

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 14

In A/B testing, which factor is increased by having a larger sample size?

Accepted Answer

Statistical power. Larger sample size increases statistical power (ability to detect a true effect).

Answer

P-value

Answer

Effect size

Answer

Type I error rate

Question 15

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