DA0-002 Data Governance Practice Test 8 — 15 Questions

Question 1

A retail company has a data warehouse that integrates sales data from multiple sources including online transactions, in-store POS, and third-party marketplaces. The data team recently updated the ETL pipeline to add a new data source: mobile app purchases. After the update, the daily sales report shows a 15% increase in total sales compared to the previous day, which is unexpected because the mobile app is new and only contributed 2% of sales in tests. The report is created by a SQL script that aggregates sales by date and runs every morning. The data team needs to identify the cause of the discrepancy. Which of the following should the team do first?

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

Accepted Answer

Verify that the date filter in the SQL script is correct and not including future dates.. The correct first step because an unexpected 15% increase in total sales, especially when the new mobile app source accounts for only 2% in tests, suggests a data integrity issue rather than a real sales surge. The most common cause is a date filter error in the SQL script, such as including future dates or applying an incorrect date range, which would inflate the daily total. Verifying the date filter is a quick, low-effort check that can confirm the data source before investigating more complex issues like double-counting (Option D). Options B and C are premature: comparing raw transaction counts is a secondary step after confirming the date filter, and assuming the increase is real (C) ignores the most likely data problem.

Answer

Compare the raw transaction counts from each source for that day.

Answer

Assume the increase is due to the mobile app and update the forecast.

Answer

Check if the ETL pipeline is double-counting transactions from the mobile app source.

Question 2

A data analyst creates a dashboard for executives to monitor quarterly sales. Which best practice ensures the dashboard is effective?

Accepted Answer

Place the most important metric in the top-left corner with simple charts.. Placing the most important metric in the top-left corner leverages the natural reading pattern (left-to-right, top-to-bottom) to immediately draw the executive's attention to the key insight. Using simple charts (e.g., bar or line charts) reduces cognitive load, enabling rapid comprehension of quarterly sales trends without distracting details. This aligns with dashboard design principles that prioritize clarity and actionability over data density.

Answer

Use a dark background with bright colors for contrast.

Answer

Include raw data tables for detailed analysis.

Answer

Use as many charts as possible to show all data.

Question 3

After presenting a data analysis to stakeholders, they ask for additional details on a specific trend. The analyst needs to provide a follow-up report. What is the best approach?

Accepted Answer

Provide a detailed written report with charts and explanations.. A detailed written report with charts and explanations allows stakeholders to review at their own pace and provides depth. Option A is wrong because creating a new dashboard for every request is inefficient. Option B is wrong because raw data files lack context and interpretation. Option D is wrong because holding another meeting delays information.

Answer

Create a new dashboard with all the data.

Answer

Send the raw data file to the stakeholders.

Answer

Hold another meeting to verbally explain the trend.

Question 4

A data analyst is preparing a presentation on customer churn. The audience consists of both technical and non-technical stakeholders. Which visualization approach is most effective?

Accepted Answer

A simple bar chart showing churn rate by segment.. A simple bar chart showing churn rate by segment is most effective because it directly communicates the key metric (churn rate) across categorical segments (e.g., customer demographics or plan types) in a format that is immediately understandable to both technical and non-technical stakeholders. Bar charts excel at comparing discrete categories without requiring statistical literacy, making them ideal for mixed audiences in a presentation context.

Answer

A box plot showing distribution of churn.

Answer

A heatmap showing correlation of churn factors.

Answer

A scatter plot with multiple variables.

Question 5

An analyst needs to communicate a data insight about a sudden drop in website traffic. Which communication method should be used first?

Accepted Answer

Schedule a live meeting to walk through the findings.. A sudden drop in website traffic is a critical, time-sensitive insight that requires immediate discussion and validation. A live meeting allows the analyst to present the data, answer questions, and collaboratively determine the root cause (e.g., a server outage, SEO penalty, or broken tracking code) before taking action. This aligns with the DA0-001 domain of Communicating Data Insights, where urgency and context demand interactive, real-time communication.

Answer

Update the dashboard without notification.

Answer

Post on the company wiki.

Answer

Send an email with a data dump.

Question 6

A data analyst creates a report and wants to ensure it tells a compelling story. Which element is most important for data storytelling?

Accepted Answer

Using a narrative arc with context.. Data storytelling relies on a narrative arc—introducing context, building tension through data insights, and resolving with actionable conclusions—to engage the audience and make the data memorable. Without a narrative, even the most accurate data fails to drive understanding or decision-making. This aligns with the DA0-001 objective of communicating data insights effectively.

Answer

Using only one chart type for consistency.

Answer

Avoiding any visual elements to keep focus on text.

Answer

Including all data without filtering.

Question 7

While reviewing a dashboard, an analyst notices that the data in a trend line chart does not match the underlying data due to a filter setting. The dashboard is used for weekly executive meetings. What should the analyst do?

Accepted Answer

Document the issue and fix the filter before the next meeting.. The analyst has identified a data integrity issue caused by a filter setting that directly impacts the accuracy of the trend line chart. The dashboard is used for weekly executive meetings, so the analyst must document the discrepancy and correct the filter before the next meeting to ensure data-driven decisions are based on accurate visualizations. This aligns with best practices in data governance and the principle of maintaining trust in reporting tools.

Answer

Ignore the discrepancy if it is small.

Answer

Wait for someone to complain before acting.

Answer

Immediately remove the dashboard and send raw data.

Question 8

A data analyst is designing a dashboard for non-technical managers. Which TWO design principles should be applied? (Choose TWO.)

Accepted Answer

Place the most important metrics at the top.. Placing the most important metrics at the top follows the principle of visual hierarchy, ensuring that non-technical managers immediately see key performance indicators without scrolling. This aligns with dashboard design best practices for executive audiences, where attention span is limited and decisions rely on top-level data first.

Answer

Use pie charts for all comparisons.

Answer

Include complex statistical terms in labels.

Answer

Provide interactive filters for drill-down.

Question 9

An analyst is presenting findings to stakeholders. Which TWO techniques effectively communicate uncertainty in data? (Choose TWO.)

Accepted Answer

Include confidence intervals.. Confidence intervals provide a range of values that likely contain the true population parameter, offering a clear measure of uncertainty around a point estimate. This technique is fundamental in inferential statistics and directly communicates the precision of the data, helping stakeholders understand the reliability of the findings.

Answer

Use only point estimates.

Answer

Remove all outliers from the data.

Answer

State exact numbers without ranges.

Question 10

A data analyst is creating a data story about sales performance. Which THREE elements are essential for effective data storytelling? (Choose THREE.)

Accepted Answer

A clear narrative with a beginning, middle, and end.. A clear narrative with a beginning, middle, and end is the structural backbone of effective data storytelling. It guides the audience through the data insights in a logical, engaging sequence, transforming raw numbers into a compelling story that drives understanding and retention.

Answer

Raw data tables for reference.

Answer

Use of multiple chart types to show variety.

Question 11

A retail company has a dashboard that tracks daily sales across all stores. The dashboard is used by the CEO during monthly board meetings. Recently, the CEO complained that the dashboard is confusing and takes too long to interpret. The data analyst is asked to redesign the dashboard to improve usability. The analyst has access to all sales data. The CEO prefers a high-level overview with the ability to drill down into regions if needed. The analyst must decide on a course of action. What should the analyst do first?

Accepted Answer

Interview the CEO to determine key performance indicators and preferred layout.. The correct first step is to interview the CEO to determine key performance indicators and preferred layout. This ensures the dashboard is designed around the specific high-level metrics the CEO needs for monthly board meetings, with the ability to drill down into regions. Starting with stakeholder requirements prevents wasted effort on irrelevant visualizations or formats.

Answer

Revamp the dashboard with as many visualizations as possible.

Answer

Conduct a survey of all employees to understand their needs.

Answer

Create a static PDF report instead of a dashboard.

Question 12

A healthcare company's data analyst is tasked with presenting patient readmission rates to a group of doctors and nurses. The data shows that readmission rates are higher among patients with certain chronic conditions. The audience has limited data literacy, but they are familiar with clinical terms. The analyst wants to communicate the insights effectively and encourage discussion on preventive measures. The presentation will last 15 minutes, and the audience expects actionable insights. What should the analyst do?

Accepted Answer

Use a simple bar chart comparing readmission rates by condition.. A simple bar chart directly compares readmission rates across chronic conditions using a visual format that is intuitive for an audience with limited data literacy. It avoids overwhelming them with raw numbers or complex statistical outputs, enabling quick comprehension and fostering discussion on actionable preventive measures within the 15-minute timeframe.

Answer

Present a table of raw numbers for each condition.

Answer

Show a complex regression model output to demonstrate correlation.

Answer

Show a scatter plot of age vs. readmission rate.

Question 13

A financial analyst at a bank is preparing a report on loan default risks to the risk management committee. The committee includes both technical (quantitative analysts) and non-technical (business managers) members. The analyst has built a logistic regression model that outputs probability scores for default. The model's performance is good, but the committee wants to understand the key drivers of default. The analyst needs to communicate both the model's accuracy and the impact of each feature. The report should be concise and persuasive, leading to policy changes. What is the best approach?

Accepted Answer

Use a waterfall chart showing the impact of each feature on a sample prediction.. A waterfall chart visually decomposes a single prediction into the additive contributions of each feature, making it intuitive for both technical and non-technical stakeholders to see which factors drive default risk. This approach directly addresses the committee's need to understand key drivers while keeping the report concise and persuasive for policy changes, unlike abstract metrics or tables.

Answer

Provide a technical white paper.

Answer

Present a feature importance bar chart and a table of coefficients.

Answer

Show the confusion matrix and AUC-ROC curve.

Question 14

A data analyst at a marketing firm is creating a weekly performance report for the marketing team. The report includes metrics like click-through rates, conversion rates, and cost per acquisition. The team prefers a quick overview of the week's performance to identify trends and make decisions in their Monday morning meeting. The meeting is only 30 minutes, and the team has limited time to review data. The analyst wants to provide a report that is concise and actionable. What format should the analyst use?

Accepted Answer

A one-page executive summary with key metrics highlighted.. A one-page executive summary with key metrics highlighted provides the marketing team with a concise, actionable overview that can be quickly reviewed in a 30-minute meeting. This format aligns with the requirement for a quick overview to identify trends and make decisions without overwhelming the team with excessive detail or requiring interactive exploration.

Answer

A live dashboard with interactive filters.

Answer

A detailed spreadsheet with all data.

Answer

A 20-slide presentation.

Question 15

A logistics company tracks delivery times and customer satisfaction scores. The data analyst finds that delivery times have increased over the past quarter, correlating with a drop in satisfaction. The analyst needs to present this to the operations team, which is interested in root cause analysis. The team wants to identify whether the increase is due to specific regions, routes, or time periods. The analyst has access to granular data including timestamps, route IDs, and region codes. The presentation should lead to actionable insights for process improvement. What visualization should the analyst use as the primary chart?

Accepted Answer

A line chart showing delivery times and satisfaction over time.. A line chart with dual axes (or separate panels) can clearly show the trend of delivery times and satisfaction scores over the same time period, directly addressing the operations team's need to identify whether the increase is due to specific time periods. This visualization allows the team to correlate changes in delivery times with satisfaction drops over time, supporting root cause analysis by highlighting temporal patterns. The granular timestamp data makes a time-series line chart the most effective primary chart for revealing trends and potential seasonality.

Answer

A scatter plot of delivery time vs. satisfaction.

Answer

A histogram of delivery times.

Answer

A pie chart showing proportion of late deliveries.