DA0-002 Data Governance — 10 Questions

Question 1

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?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

The database connection pool has reached its maximum limit.. In this scenario of a database connection failure, the most likely cause is that the connection pool has reached its maximum limit. This means all available connections are in use, preventing new connections. The other options are less common causes for such connection issues.

Answer

The database table is corrupted.

Answer

The database server is out of disk space.

Answer

The database authentication credentials are invalid.

Question 2

A data analyst is presenting findings to a non-technical audience. Which data visualization technique is most appropriate?

Accepted Answer

Bar chart. Bar charts are the most appropriate visualization for a non-technical audience because they present categorical comparisons in a simple, intuitive format that requires no statistical background to interpret. Unlike box plots, heat maps, or scatter plots, bar charts clearly show relative magnitudes with minimal cognitive load, making them ideal for communicating data insights to stakeholders who may not be familiar with data analysis conventions.

Answer

Box plot

Answer

Heat map

Answer

Scatter plot

Question 3

A data analyst is tasked with presenting the results of a customer churn analysis to a group of marketing managers. The model identified that customers with low engagement scores are 3 times more likely to churn. The analyst wants to effectively communicate this finding to persuade the managers to focus on engagement. Which of the following is the most compelling way to present this insight?

Accepted Answer

Calculate the potential revenue increase if engagement improves by 10%. Translating the analytical finding into potential revenue impact directly addresses the managers' business goals and provides a persuasive, actionable argument for focusing on engagement. In contrast, options A, B, and C present the data factually but lack the compelling business context needed to drive decision-making.

Answer

Show a table with raw churn rates by engagement score

Answer

Use a bar chart comparing churn rates of low vs. high engagement

Answer

Show a scatter plot of engagement score vs. churn

Question 4

A data analyst creates a dashboard for executives that shows a key metric trending downward. The analyst notices that the metric is highly volatile day-to-day. Which visualization type is most appropriate to show the underlying trend?

Accepted Answer

7-day moving average line chart.. A 7-day moving average line chart smooths out daily volatility to reveal the trend. A daily bar chart shows noise; a pie chart is inappropriate for trends; a scatter plot with regression line could show correlation but not trend over time as clearly.

Answer

Pie chart showing proportion of days.

Answer

Scatter plot with regression line.

Answer

Daily bar chart.

Question 5

Refer to the exhibit. A data analyst is reviewing the job log. Which of the following best explains the reduction in record count?

Accepted Answer

The job aggregated data by region and date, reducing granularity.. The job aggregated data by region and date, reducing granularity from transactional to summary level. The null exclusion of 50 records is minor and cannot account for the substantial reduction. Options A, B, and D are incorrect: A is wrong because null exclusion is minor; B is wrong because no filter is mentioned; D is wrong because the job completed successfully.

Answer

The null region exclusion caused the reduction.

Answer

The job applied a filter to only include top regions.

Answer

The job failed to process half the data.

Question 6

A data analyst notices that a line chart showing monthly sales over the past two years has a steep drop in one month. Upon investigation, the analyst discovers that a new sales region was added mid-month and the data was not normalized. Which of the following best practices should the analyst apply to communicate this insight accurately?

Accepted Answer

Normalize the sales data by region and explain the data anomaly in the report.. The core issue is that the sales data is not normalized by region, causing a misleading drop when a new region was added mid-month. By normalizing the data (e.g., calculating per-region averages or percentages) and explicitly noting the anomaly in the report, the analyst ensures accurate communication of insights. This aligns with the DA0-001 domain of Communicating Data Insights, where transparency and data integrity are paramount.

Answer

Remove the month with the drop from the report.

Answer

Use a bar chart instead to show the data.

Answer

Present the data as-is and let stakeholders interpret the drop.

Question 7

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 8

A data analyst needs to present the distribution of customer ages to a non-technical audience. Which type of chart would be most appropriate?

Accepted Answer

Histogram. A histogram is the most appropriate chart for displaying the distribution of a single continuous variable, such as customer ages, to a non-technical audience. It groups ages into bins and shows the frequency of customers within each bin, making the shape, center, and spread of the distribution immediately visible. This aligns with the DA0-001 objective of selecting visualizations that clearly communicate data insights to stakeholders.

Answer

Scatter plot

Answer

Pie chart

Answer

Line chart

Question 9

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.. 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 10

A data analyst is building a dashboard that will be used by both executives and operational managers. The executives need high-level summaries, while managers need granular details. Which dashboard design principle should the analyst apply?

Accepted Answer

Design the dashboard with drill-down capabilities from summary to detail.. Drill-down capabilities allow users to start with a high-level summary (e.g., total revenue by region) and then interactively navigate to granular details (e.g., individual transactions) without overwhelming either audience. This design principle supports both executive and operational manager needs within a single dashboard, maintaining clarity and performance by loading only the required level of detail on demand.

Answer

Use a single chart that shows both summary and detail simultaneously.

Answer

Display all available data on one page for transparency.

Answer

Create two separate dashboards for each audience.