DA0-002 Practice Test 6 — 10 Questions

Question 1

A data governance team is defining roles and responsibilities for data management. Which TWO of the following are common data governance roles? (Select TWO).

Accepted Answer

Data steward. Data owner and data steward are standard roles in data governance, responsible for data ownership and stewardship respectively.

Answer

Data scientist

Answer

Database administrator

Answer

Data analyst

Question 2

A data analyst is preparing features for a machine learning model that uses distance-based algorithms (e.g., K-means, KNN). The dataset contains numerical features with different scales: age (0-100), income (20,000-200,000), and credit score (300-850). Which data transformation technique is most appropriate to ensure all features contribute equally to the distance calculations?

Accepted Answer

Min-max normalization. Min-max normalization rescales features to a fixed range (e.g., 0 to 1), making distances computed equally weighted. Standardization is better for algorithms assuming Gaussian distributions.

Answer

Z-score standardization

Answer

One-hot encoding

Answer

Log transformation

Question 3

A data analyst needs to show the relationship between advertising spend (in dollars) and monthly sales revenue (in dollars) for the past 12 months. Which chart type is most appropriate?

Accepted Answer

Scatter plot. A scatter plot is used to visualize the correlation between two continuous variables.

Answer

Line chart

Answer

Bar chart

Answer

Pie chart

Question 4

A data analyst needs to identify the most frequently occurring value in a dataset. Which measure of central tendency should they use?

Accepted Answer

Mode. The mode is the measure of central tendency that identifies the most frequently occurring value in a dataset. Unlike the mean or median, the mode directly counts the frequency of each distinct value and returns the value with the highest count, making it the correct choice for this specific requirement.

Answer

Standard deviation

Answer

Median

Answer

Mean

Question 5

An e-commerce company is acquiring product data from multiple supplier APIs. The APIs return JSON with inconsistent field naming conventions. Which data acquisition technique should be applied?

Accepted Answer

Data mapping and transformation. Data mapping and transformation is the correct technique because the JSON responses from different supplier APIs use inconsistent field naming conventions (e.g., 'product_id' vs. 'ProductID'). This technique defines a schema to map source fields to a standardized target format, ensuring data consistency before loading into the company's system. Without transformation, downstream processes like analytics or inventory management would fail due to mismatched field names.

Answer

Data compression

Answer

Data deduplication

Answer

Data aggregation

Question 6

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

Accepted Answer

Box plot. Histogram shows frequency bins; box plot shows quartiles and outliers.

Answer

Scatter plot

Answer

Line chart

Answer

Pie chart

Question 7

A data analyst discovers that the sales data for the current quarter shows a 15% increase in revenue. However, the analyst notes that the data does not include returns from the last week due to a system lag. How should the analyst communicate this uncertainty?

Accepted Answer

Include a caveat that returns from the last week are missing and revenue may be overstated.. When data has limitations, it's important to disclose them, such as missing returns, to avoid misleading conclusions.

Answer

Delay the report until returns are processed.

Answer

Report the 15% increase as final, because the returns are insignificant.

Answer

State that the revenue increase is exactly 15% and provide a confidence interval.

Question 8

Drag and drop the steps to perform a data audit in the correct order.

Accepted Answer

1. Inventory, 2. Quality Assessment, 3. Compliance Check, 4. Documentation, 5. Recommendations. Data audit begins with inventory, quality assessment, compliance check, documentation, and recommendations.

Answer

1. Quality Assessment, 2. Inventory, 3. Compliance Check, 4. Documentation, 5. Recommendations

Answer

1. Inventory, 2. Compliance Check, 3. Quality Assessment, 4. Documentation, 5. Recommendations

Answer

1. Inventory, 2. Quality Assessment, 3. Documentation, 4. Compliance Check, 5. Recommendations

Question 9

A healthcare data analyst is presenting findings on patient readmission rates to a group of hospital administrators. The analysis reveals a 15% increase in readmissions over the past quarter for patients aged 65+ from a specific zip code. However, the administrators are skeptical because previous quarterly reports showed no such trend, and they suspect data quality issues. The analyst must communicate this insight effectively while maintaining credibility. Which of the following approaches should the analyst take?

Accepted Answer

Acknowledge the discrepancy and explain possible reasons such as changes in data collection methods or patient population. It demonstrates the core competency of 'Communicating Data Insights' by acknowledging the discrepancy between the current finding and previous reports, which builds trust with skeptical stakeholders. By explaining possible reasons such as changes in data collection methods or patient population, the analyst maintains credibility and invites collaborative investigation into data quality issues, rather than dismissing concerns or hiding details.

Answer

Emphasize the statistical significance of the finding and ignore previous reports

Answer

Present the data without any explanation and let them draw conclusions

Answer

Remove the demographic detail to avoid controversy

Question 10

An analyst is creating a report to show the relationship between advertising spend and website traffic over the past 12 months. The data has a few outliers due to special promotional events. Which chart type should the analyst use to clearly show the trend while minimizing the impact of outliers?

Accepted Answer

Scatter plot with a trend line. A scatter plot with a trend line (Option D) is the best choice because it plots each data point individually, allowing the analyst to see the overall relationship between advertising spend and website traffic while the trend line (often a linear regression line) smooths out the influence of outliers. This chart type minimizes the visual impact of extreme values by focusing on the central tendency and direction of the data, making it ideal for identifying trends over 12 months despite promotional event spikes.

Answer

Pie chart

Answer

Bar chart

Answer

Heatmap