DA0-002 Data Governance — 20 Questions

Question 1

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?

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

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 2

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?

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 3

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 4

An analyst is creating a report to show the relationship between advertising spend and website traffic over the past 12 months. The data has a few outliers due to special promotional events. Which chart type should the analyst use to clearly show the trend while minimizing the impact of outliers?

Accepted Answer

Scatter plot with a trend line. A scatter plot with a trend line (Option D) is the best choice because it plots each data point individually, allowing the analyst to see the overall relationship between advertising spend and website traffic while the trend line (often a linear regression line) smooths out the influence of outliers. This chart type minimizes the visual impact of extreme values by focusing on the central tendency and direction of the data, making it ideal for identifying trends over 12 months despite promotional event spikes.

Answer

Pie chart

Answer

Bar chart

Answer

Heatmap

Question 5

During a presentation, a stakeholder questions the validity of a data insight because the sample size appears small. The analyst knows the sample is statistically significant. What is the best way to address this concern?

Accepted Answer

Explain the margin of error and confidence interval used.. It directly addresses the stakeholder's concern by explaining the statistical concepts of margin of error and confidence interval, which demonstrate that the sample size is sufficient for the desired level of precision. This approach validates the data insight's reliability without dismissing the stakeholder's valid question, aligning with best practices in communicating data insights.

Answer

Ignore the question and continue the presentation.

Answer

Ask the stakeholder to trust the analysis and move on.

Answer

Agree to collect more data before finalizing the report.

Question 6

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?

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 7

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 8

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 9

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 10

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 11

A company is designing a dashboard for real-time monitoring. Which THREE considerations are most critical?

Accepted Answer

Alert thresholds. For a real-time monitoring dashboard, alert thresholds (B) are critical because they define the exact metric values or conditions that trigger notifications, enabling operators to detect and respond to incidents promptly. Mobile responsiveness (C) is essential so that on-call engineers and stakeholders can view and act on live monitoring data from smartphones or tablets anywhere, not just at a desktop. Data refresh frequency (E) is also critical because real-time monitoring depends on how often metrics are polled or streamed (e.g., sub-second, 5-second, or 1-minute intervals), directly affecting how quickly anomalies become visible. The unmarked options do not belong: color palette aesthetics (A) is a cosmetic styling choice rather than a functional monitoring requirement, and drill-down capability (D), while useful for root-cause analysis, is a secondary investigative feature rather than one of the three most critical considerations for real-time monitoring.

Answer

Color palette aesthetics

Answer

Drill-down capability

Question 12

Refer to the exhibit. A data analyst is unable to run a query on the customers table after October 1, 2023. What is the reason?

Accepted Answer

The policy allows access only before October 1, 2023. The policy explicitly allows access only before October 1, 2023, meaning any query attempt on or after that date is denied. This is a time-based access control condition often implemented using a policy engine that checks the current time against a condition. Since the query fails after October 1, 2023, the policy's effective date restriction is the direct cause.

Answer

The resource name is incorrect

Answer

The action should be READ not SELECT

Answer

The policy denies access after October 1, 2023

Question 13

Refer to the exhibit. An ETL pipeline failed. What is the most likely root cause?

Accepted Answer

Network connectivity issues. The exhibit shows an ETL pipeline failure with a timeout error, which is a classic symptom of network connectivity issues. When the pipeline cannot reach the source or target system due to a network interruption, the process hangs until a timeout threshold is exceeded, causing the job to fail. This is the most likely root cause because timeouts are directly associated with network problems, not with data format, authentication, or storage issues.

Answer

Data format mismatch

Answer

Authentication failure

Answer

Insufficient disk space

Question 14

When designing a report for executive leadership, which aspect is most important?

Accepted Answer

High-level summaries with key insights. Executive leadership requires actionable insights, not raw data. High-level summaries with key insights (Option D) allow leaders to quickly grasp trends, make decisions, and align with business goals without getting bogged down in technical details. This aligns with the DA0-001 objective of communicating data insights effectively to non-technical stakeholders.

Answer

Detailed technical notes

Answer

Raw data tables

Answer

All raw SQL queries

Question 15

An analyst finds that a key metric drops significantly after a data pipeline update. How should the analyst proceed?

Accepted Answer

Compare data before and after update to identify discrepancies. The first step in diagnosing a sudden metric drop after a pipeline update is to perform a controlled comparison of pre- and post-update data. This involves validating data schemas, row counts, and distribution statistics to pinpoint whether the update introduced a transformation error, a filtering issue, or a data type mismatch. Without this comparison, the analyst cannot determine if the drop is due to a genuine data change or a pipeline defect.

Answer

Assume it's a seasonal effect

Answer

Revert the pipeline immediately

Answer

Document the drop and report it

Question 16

An analyst is creating a report for both technical and executive audiences. Which two strategies are effective? (Choose TWO.)

Accepted Answer

Use visual summaries for executives and detailed tables for technical. Option B is correct because pairing visual summaries (e.g., dashboards, trend charts) for executives with detailed tables (e.g., metrics, logs, or statistical breakdowns) for technical readers tailors the same report to each audience's needs without losing rigor. Option E is correct because structuring the report into separate sections with different levels of detail — such as an executive summary followed by a technical deep-dive — lets each audience read at the appropriate depth while keeping one coherent document. Option A is not ideal because dumping all raw data into an appendix can overwhelm readers and dilute the key findings rather than communicate them effectively. Option C is wrong because completely avoiding technical terms would strip necessary precision for the technical audience and could make the report vague. Option D is wrong because a single chart cannot simultaneously satisfy executives who need high-level takeaways and technical readers who need granular, accurate detail.

Answer

Include all raw data in the appendix

Answer

Avoid any technical terms

Answer

Provide a single chart for all audiences

Question 17

Refer to the exhibit. A data analyst is unable to access the dataset during weekends. Based on the policy, what is the most likely reason?

Accepted Answer

The condition restricts access to business hours only. The policy explicitly includes a condition that restricts access to business hours only (e.g., Monday–Friday, 9 AM–5 PM). Since the analyst is attempting to access the dataset during a weekend, the condition denies access regardless of the analyst's role or network location. This is a common attribute-based access control (ABAC) rule where time-based conditions are evaluated before granting permissions.

Answer

The analyst's role is not in the list

Answer

The policy is misconfigured

Answer

The access condition requires being on the internal network

Question 18

Refer to the exhibit. What is the impact of the validation result?

Accepted Answer

The staging table is missing the 'age' column, which may cause query errors. The validation result shows that the staging table has a different schema than the target table, specifically missing the 'age' column. This mismatch will cause query errors when attempting to insert or query data that references the 'age' column, as the staging table lacks the required column definition. The validation result explicitly flags this schema discrepancy, making option A correct.

Answer

The validation passed successfully

Answer

Only duplicates were found

Answer

The row counts match, so data is complete

Question 19

Refer to the exhibit. The data shows sales by product category for two years. Which product category had the highest percentage increase from 2023 to 2024?

Accepted Answer

Home & Garden. Home & Garden had the highest percentage increase from 2023 to 2024. Based on the data, its sales grew from $19,000 to $22,000, a 15.8% increase. In contrast, Clothing increased by 10% ($100,000 to $110,000), Books by 8% ($25,000 to $27,000), and Electronics by 12% ($30,000 to $33,600). Therefore, Home & Garden's percentage increase of 15.8% is the highest among all categories.

Answer

Clothing

Answer

Books

Answer

Electronics

Question 20

A data analyst is presenting results from a customer segmentation analysis to a non-technical audience. The segmentation was performed using k-means clustering, and the analyst wants to explain the characteristics of each cluster. Which visualization is most appropriate for this audience?

Accepted Answer

A bar chart comparing the average values of key metrics for each cluster.. A bar chart comparing average values of key metrics per cluster is the most appropriate choice because it directly translates the numerical output of k-means clustering into a simple, intuitive visual that non-technical audiences can easily interpret. Unlike complex multivariate plots, a bar chart focuses on the distinct characteristics of each cluster without requiring knowledge of clustering algorithms or dimensionality reduction. This aligns with the DA0-001 objective of communicating data insights effectively to stakeholders.

Answer

A parallel coordinates plot displaying all variables used in clustering.

Answer

A heatmap of the distance matrix between cluster centroids.

Answer

A scatter plot with two principal components showing cluster boundaries.