DA0-001 Practice Test 3 — 10 Questions

Question 1

A data team is preparing a dashboard for executives. The team wants to highlight key performance indicators (KPIs) that are below target. Which of the following visualization techniques would most effectively draw attention to underperforming metrics without causing confusion?

Accepted Answer

Apply conditional formatting to turn KPI values red when below target.. Conditional formatting that turns KPI values red when below target is the most effective technique because it leverages pre-attentive visual processing — the human eye naturally notices color changes (especially red) before other visual elements. This allows executives to instantly identify underperforming metrics without needing to interpret complex chart types, reducing cognitive load and confusion.

Answer

Remove underperforming KPIs from the dashboard to avoid confusion.

Answer

Use a scatter plot to show the relationship between KPIs.

Answer

Use a pie chart showing the proportion of each KPI.

Question 2

A data analyst creates a scatter plot showing the relationship between advertising spend and revenue. The plot shows a strong positive correlation. Which of the following should the analyst include in the report to ensure accurate communication?

Accepted Answer

Include a note that correlation does not imply causation.. Option B is correct because correlation does not imply causation, and this caveat is essential. Option A is wrong because the scatter plot already shows the relationship. Option C is wrong because removing points could bias the analysis. Option D is wrong because a regression line is not necessary for every scatter plot.

Answer

Replace the scatter plot with a bar chart.

Answer

Remove any outliers from the plot.

Answer

Add a trend line to the scatter plot.

Question 3

A data analyst encounters the above error log when trying to connect to a database. The analyst needs to explain the issue to the database administrator. Which of the following correctly describes the problem?

Accepted Answer

The database connection pool has reached its maximum limit.. The error log indicates a 'connection pool exhausted' or 'too many connections' message, which occurs when the database connection pool has reached its maximum limit. This means all available connections are in use, and no new connections can be established until existing ones are released. The analyst should explain to the DBA that the application is attempting to open more connections than the pool allows, often due to a connection leak or insufficient pool size.

Answer

The database table is corrupted.

Answer

The database server is out of disk space.

Answer

The database authentication credentials are invalid.

Question 4

A data analyst creates a report showing sales by product category. The analyst notices that one category has a very high sales figure due to a one-time bulk order. Which of the following is the best way to communicate this insight to stakeholders?

Accepted Answer

Add a note to the chart explaining the bulk order.. Option B is correct because it maintains data integrity while providing necessary context. Adding a note to the chart allows stakeholders to understand the anomaly without distorting the underlying data. This approach aligns with best practices in data communication, where transparency about outliers is critical for accurate interpretation.

Answer

Delete the bulk order from the dataset.

Answer

Remove the category with the bulk order from the report.

Answer

Use a pie chart to show the proportion of each category.

Question 5

A healthcare analytics team is responsible for producing a monthly dashboard for hospital administrators. The dashboard includes key metrics such as patient admission rates, average length of stay, readmission rates, and bed occupancy. For the current month, the data shows a significant increase in average length of stay. The data analyst suspects that this increase is due to a new chronic disease management program that was implemented at the beginning of the month. However, the analyst also notices that the data for the previous month had an error: some discharge dates were incorrectly recorded, causing the average length of stay to be artificially low. The analyst needs to communicate the insights to the administrators, who are concerned about the increase. Which of the following is the best course of action?

Accepted Answer

Correct the previous month's data, recalculate the change, and present the increase alongside an explanation of the new program and the data correction.. Option D is the best course of action because it addresses both the data quality issue and the business concern. By correcting the previous month's erroneous discharge dates, the analyst recalculates the true baseline, ensuring the reported increase in average length of stay is accurate. Presenting the corrected data alongside an explanation of the new chronic disease management program provides a complete, transparent narrative that separates the impact of the data error from the program's effect, which is essential for informed decision-making by hospital administrators.

Answer

Correct the previous month's data and present the adjusted increase, emphasizing the data error.

Answer

Present the raw data as-is and explain that the increase is due to the new program.

Answer

Delay the report until the next month to gather more data on the program's effect.

Question 6

Match each data governance role to its responsibility.

Question 7

Match each data quality dimension to its description.

Question 8

Match each data analysis technique to its primary purpose.

Question 9

Match each ETL process step to its description.

Question 10

Match each data visualization type to its best use case.