DA0-002 Data Governance Practice Test 3 — 15 Questions

Question 1

You are a data analyst at a retail company. The marketing team has asked you to analyze the effectiveness of a recent email campaign. You have data on email open rates, click-through rates, and conversion rates. The campaign targeted 50,000 customers; 20,000 opened the email, 5,000 clicked a link, and 500 made a purchase. The marketing director wants to know the campaign's overall performance and whether the email content was engaging. You prepare a dashboard but notice that the click-through rate (CTR) is 25% and the conversion rate is 10%, which seem high. Upon reviewing the data, you discover that the click-through rate was calculated as (clicks / opens) * 100, and the conversion rate as (purchases / clicks) * 100. The director expects the conversion rate to be calculated as (purchases / opens) * 100. Which action should you take to ensure accurate communication of insights?

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

Accepted Answer

Present both conversion rates (purchases/opens and purchases/clicks) with clear labels and definitions.. The marketing director expects conversion rate as purchases/opens, but the analyst initially used purchases/clicks. Presenting both metrics with clear labels ensures transparency and avoids misinterpretation, allowing the director to see the full funnel performance. This aligns with best practices in data communication, where stakeholders may have different definitions of a metric.

Answer

Change the conversion rate calculation to purchases/opens without informing the director.

Answer

Recalculate the click-through rate as opens/sent to align with industry standards.

Answer

Present the dashboard as is, because the calculations are technically correct.

Question 2

Drag and drop the steps to conduct a hypothesis test in the correct order.

Accepted Answer

State hypotheses, Set significance level (alpha), Collect data, Compute test statistic, Make decision. Hypothesis testing involves stating hypotheses, setting alpha, collecting data, computing test statistic, and making a decision.

Answer

Collect data, State hypotheses, Set significance level (alpha), Compute test statistic, Make decision

Answer

State hypotheses, Set significance level (alpha), Compute test statistic, Collect data, Make decision

Answer

State hypotheses, Collect data, Set significance level (alpha), Compute test statistic, Make decision

Question 3

Drag and drop the steps to perform a root cause analysis on data quality issues in the correct order.

Accepted Answer

Define the problem, Gather data, Identify potential causes, Determine root cause, Implement corrective actions. Root cause analysis involves defining the problem, gathering data, identifying causes, finding root cause, and acting.

Answer

Gather data, Define the problem, Identify potential causes, Determine root cause, Implement corrective actions

Answer

Define the problem, Identify potential causes, Determine root cause, Gather data, Implement corrective actions

Answer

Implement corrective actions, Define the problem, Gather data, Identify potential causes, Determine root cause

Question 4

Match each ETL process step to its description.

Accepted Answer

Extract: Retrieving data from various source systems. In ETL, Extract involves retrieving data from sources, Transform involves cleaning and converting data, and Load involves writing data to a target system. Common confusions include swapping the definitions of Extract and Transform, or misattributing real-time data capture to Load.

Answer

Extract: Converting data into a suitable format for analysis

Answer

Transform: Retrieving data from various source systems

Answer

Load: Capturing changes from source systems in real time

Question 5

Match each data security concept to its description.

Accepted Answer

Encryption: Process of converting data into a coded form to prevent unauthorized access.. The correct matches are: Encryption - encoding data, Authentication - verifying identity, Authorization - access control, Non-repudiation - denying actions. Common confusions arise from swapping Encryption and Authentication.

Answer

Encryption: Process of verifying identity.

Answer

Authentication: Process of converting data into code.

Question 6

A data analyst is creating a dashboard for executives to show monthly sales trends over the past year. Which chart type is most appropriate?

Accepted Answer

Line chart. A line chart is the most appropriate choice because it excels at showing continuous data trends over time, such as monthly sales over a year. The x-axis represents the time dimension (months), and the y-axis represents sales values, allowing executives to easily identify upward or downward trends, seasonality, and inflection points. This aligns with the goal of communicating data insights clearly and effectively.

Answer

Stacked bar chart

Answer

Scatter plot

Answer

Pie chart

Question 7

An analyst is presenting findings to a non-technical audience. The data shows a 20% increase in customer churn after a price change. Which presentation approach is BEST?

Accepted Answer

Use a simple bar chart comparing churn before and after. A simple bar chart visually and intuitively communicates the 20% increase in churn to a non-technical audience without requiring statistical literacy. This approach aligns with best practices for presenting data insights to stakeholders who need clear, actionable takeaways rather than technical details.

Answer

Explain the p-value

Answer

Provide the raw data table

Answer

Show a complex statistical model

Question 8

A healthcare organization must ensure patient data privacy when sharing reports with external auditors. Which practice is most important?

Accepted Answer

Use pseudonymization. Pseudonymization replaces identifying information with pseudonyms, allowing data utility while protecting privacy. Aggregation reduces granularity but may still reveal identities; encryption secures transport but not the content; obtaining consent is impractical for large datasets.

Answer

Encrypt the report file

Answer

Obtain consent from patients

Answer

Aggregate data at low granularity

Question 9

A dashboard automatically refreshes every hour, but users report stale data. What is the most likely issue?

Accepted Answer

The refresh interval is too long. The most likely issue is that the refresh interval is too long. If the dashboard refreshes every hour but users are seeing stale data, the data source may update more frequently than the dashboard's refresh cycle, causing a lag between data changes and dashboard updates. This is a common scheduling mismatch in BI tools like Tableau or Power BI where the refresh interval must align with data source update frequency.

Answer

The dashboard is not published

Answer

The dashboard uses cached data

Answer

The data source connection is broken

Question 10

When creating a data story, what should be the FIRST step?

Accepted Answer

Identify the key message. The first step in creating a data story is to identify the key message because the entire narrative, data selection, and visualization choices must align with a central insight. Without a clear message, subsequent steps like gathering data or designing layouts risk being unfocused and failing to communicate actionable findings. This ensures the story is driven by the insight, not by the data or tools.

Answer

Design the layout of the report

Answer

Gather all available data

Answer

Choose visualization tools

Question 11

A data analyst includes a map showing customer locations by zip code. The map reveals exact addresses for a few customers due to data granularity. This violates which principle?

Accepted Answer

Anonymization. The map reveals exact addresses for a few customers due to the granularity of zip code data. This directly violates the principle of anonymization, which requires that data be processed in such a way that individuals cannot be identified. By exposing precise locations, the data is no longer anonymized, as it allows re-identification of specific individuals.

Answer

Informed consent

Answer

Data minimization

Answer

Data quality

Question 12

A report uses red and green colors to indicate performance; a stakeholder who is colorblind complains. What is the BEST remedy?

Accepted Answer

Add patterns or labels in addition to color. Adding patterns or labels alongside color ensures that the data encoding is accessible to colorblind viewers without removing the informational value of color for those who can see it. This approach follows WCAG (Web Content Accessibility Guidelines) 2.1 Success Criterion 1.4.1, which requires that color is not the sole means of conveying information. In data visualization tools like Tableau or Power BI, this is implemented by adding shape markers or text annotations to series, preserving the original color scheme for non-colorblind users while providing redundant encoding.

Answer

Remove color entirely

Answer

Change colors to blue and orange

Answer

Use a different chart type

Question 13

An analyst needs to present quarterly sales data to the board. The CEO wants to see both overall trend and breakdown by region. Which dashboard layout is most effective?

Accepted Answer

A combination of a line chart for total and a stacked area chart for regional breakdown. It simultaneously satisfies the CEO's dual requirement: a line chart clearly shows the overall quarterly sales trend, while a stacked area chart breaks down total sales by region, allowing the board to see both the aggregate performance and the contribution of each region over time. This combination leverages the strengths of each chart type—line for trend clarity and stacked area for part-to-whole relationships—without overloading the viewer with data.

Answer

A single line chart with all regions

Answer

A KPI card with total sales

Answer

A table with all quarterly figures

Question 14

A company must comply with GDPR when reporting customer data. What must be included in the report?

Accepted Answer

A notice about data processing purposes. Under GDPR, when reporting customer data, the controller must provide a notice about the purposes of data processing to ensure transparency and lawful basis for processing. This is required by Article 13 of the GDPR, which mandates that data subjects be informed of the specific purposes for which their personal data is being processed. Including this notice in the report demonstrates compliance with the accountability principle.

Answer

Customer names and emails

Answer

The source of the data

Answer

Data retention period

Question 15

Which TWO are best practices for data storytelling?

Accepted Answer

Start with the conclusion. Starting with the conclusion is a best practice for data storytelling because it immediately communicates the key insight to the audience, allowing them to understand the takeaway before diving into supporting details. This approach aligns with the inverted pyramid structure used in data communication, where the most critical finding is presented first to capture attention and provide context for the subsequent data. It ensures that even if the audience does not follow every detail, they still grasp the primary message.

Answer

Use complex jargon to show expertise

Answer

Use a single visualization to avoid confusion

Answer

Include all data points for completeness