DA0-002 Data Governance Practice Test 1 — 15 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.

Question 11

A data analyst wants to compare the sales performance of four different stores over the same time period. Which chart type is most suitable?

Accepted Answer

Grouped bar chart. A grouped bar chart is the most suitable choice because it allows direct comparison of discrete categories (four stores) across a common time period, with each group representing a time interval and individual bars representing each store's sales. This chart type excels at side-by-side comparisons of multiple entities over the same categorical axis, making it ideal for the analyst's goal.

Answer

Line chart with multiple lines

Answer

Stacked bar chart

Answer

Pie chart with multiple pies

Question 12

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.. Correlation does not imply causation. It is important for the analyst to include this caveat to prevent misinterpretation of the relationship. Option B is incorrect because a bar chart is not appropriate for showing the relationship between two continuous variables. Option C is incorrect because removing outliers without justification can distort the analysis; outliers should be handled transparently. Option D is incorrect because while a trend line could be added, it is not mandatory and the question specifically asks for ensuring accurate communication, which is primarily about the correlation-causation warning.

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 13

A data analyst is presenting a weekly sales report to a diverse audience that includes sales managers, marketing team, and finance. The analyst wants to ensure the data is understood correctly. Which communication strategy is most effective?

Accepted Answer

Create a slide deck with key insights and contextual explanations.. A slide deck with key insights and contextual explanations tailors the presentation to a diverse audience, ensuring that sales managers, marketing, and finance can each grasp the relevant data without being overwhelmed. This approach aligns with best practices for data communication, where visual summaries and narrative context improve comprehension over raw data or overly technical jargon.

Answer

Use a single complex chart to show all data at once.

Answer

Email the raw data table to all stakeholders.

Answer

Use technical terms such as 'variance' and 'standard deviation'.

Question 14

Which TWO of the following are best practices for designing a data dashboard?

Accepted Answer

Use consistent color schemes to indicate performance levels.. Consistent color schemes (e.g., red for critical, yellow for warning, green for normal) allow users to instantly interpret performance levels without cognitive overload. This aligns with dashboard design principles that prioritize clarity and rapid pattern recognition over decorative elements.

Answer

Include animated transitions between data views.

Answer

Use 3D effects to make charts more visually appealing.

Answer

Include as many charts as possible to provide comprehensive data.

Question 15

Which THREE of the following are appropriate ways to handle outliers when communicating data insights?

Accepted Answer

Document the outlier and its potential impact in the report.. Documenting the outlier and its potential impact in the report is a best practice for transparent and ethical data communication. It allows stakeholders to understand the anomaly's influence on the analysis and make informed decisions, rather than hiding or misrepresenting the data.

Answer

Ignore the outlier and proceed with the analysis.

Answer

Remove the outlier from the dataset to clean the data.