DA0-002 Data Governance — Timed 50 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?

50 minute time limit — choose an answer to begin.

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.

Question 16

Which TWO of the following are effective techniques for presenting data to a non-technical audience?

Accepted Answer

Highlight the most important insights using callouts.. Highlighting key insights with callouts directly addresses the needs of a non-technical audience by drawing attention to the most important findings without requiring them to interpret complex data. This technique aligns with best practices for data storytelling, where visual emphasis on critical points improves comprehension and retention for stakeholders who may not have a technical background.

Answer

Explain the statistical methods used in the analysis.

Answer

Include detailed data tables for reference.

Answer

Use many different colors to distinguish data points.

Question 17

A data analyst is reviewing a data lake access policy that controls access to a data lake. The analyst wants to communicate that the current policy restricts data downloads to a specific IP range. Which of the following best describes the policy's effect?

Accepted Answer

The policy restricts data downloads to a specific IP range.. The access policy explicitly restricts data downloads to a specific IP range by using a condition in the policy statement, such as a source IP address with a CIDR block. This means only requests originating from IP addresses within that range are allowed to perform the download action, effectively limiting downloads to authorized network locations.

Answer

The policy allows all users to download data.

Answer

The policy denies data downloads to all users.

Answer

The policy allows data uploads from a specific IP range.

Question 18

A large e-commerce company has a data warehouse that stores daily sales transactions. The data analytics team creates a weekly report for the executive team that includes total revenue, number of orders, and average order value. Recently, the report showed a sudden 20% drop in total revenue compared to the previous week. Upon investigation, the data analyst discovers that a major promotional event ended the previous week, and the current week's data includes a new product launch with lower prices. The analyst needs to present this data to the executives in a way that accurately reflects the business situation. The analyst must also provide recommendations for actions. Which of the following is the best course of action?

Accepted Answer

Present the data with annotations explaining the promotion end and new product launch, and recommend analyzing customer retention and cross-selling opportunities.. It adheres to the principle of transparent data communication: the analyst must present the full dataset with contextual annotations (promotion end, new product launch) to avoid misleading executives. This approach enables informed decision-making, and the recommendation to analyze customer retention and cross-selling opportunities directly addresses the underlying business dynamics—understanding whether the revenue drop is temporary or signals a shift in customer behavior. In a data warehouse context, this ensures that the weekly report reflects the true state of the business rather than a manipulated or incomplete view.

Answer

Remove the new product launch data from the report to show a clearer comparison.

Answer

Present only the data from the new product launch to show growth potential.

Answer

Present the drop as-is and recommend cutting costs to compensate for the revenue decline.

Question 19

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

A data analyst creates a bar chart showing monthly sales for the current year. The CEO asks to see the same data but grouped by region. Which chart type is most appropriate for this new requirement?

Accepted Answer

Grouped bar chart. A grouped bar chart is the most appropriate choice because it allows the CEO to compare monthly sales across different regions side by side within each month. This chart type effectively displays two categorical variables (month and region) and one quantitative variable (sales), making it easy to see both regional performance and monthly trends simultaneously.

Answer

Pie chart

Answer

Stacked bar chart

Answer

Line chart