DA0-002 Data Governance Practice Test 7 — 15 Questions

Question 1

Refer to the exhibit. A data analyst wants to create a visualization that best shows the trend of sales over time for each department. Which chart type should be used?

Accepted Answer

Line chart with multiple lines.. A line chart with multiple lines is the best choice because it clearly shows the trend of sales over time for each department, with time on the x-axis and sales on the y-axis. Each line represents a department, making it easy to compare trends across departments while preserving the continuous nature of time. This aligns with the goal of visualizing trends, as line charts excel at showing changes over a continuous interval.

Answer

Stacked bar chart.

Answer

Pie chart for each quarter.

Answer

Grouped bar chart.

Question 2

Refer to the exhibit. A data analyst is troubleshooting a failed dashboard refresh. The error log shows repeated SQL syntax errors. Which of the following is the most likely cause?

Accepted Answer

The query contains a syntax mistake.. The error log explicitly states 'repeated SQL syntax errors,' which directly indicates that the SQL query being executed is malformed. A syntax mistake in the query (e.g., missing keyword, incorrect clause order, or mismatched parentheses) will cause the database to reject the statement before any execution begins, leading to the exact error described.

Answer

The database server is offline.

Answer

The user does not have permissions to access the table.

Answer

The network connection timed out.

Question 3

Refer to the exhibit. A data analyst is reviewing the configuration of an executive dashboard. The dashboard refreshes daily at 6:00 AM. Which of the following best describes a potential issue with this dashboard for executive use?

Accepted Answer

The dashboard uses a table visualization which may not be suitable for quick insights.. An executive dashboard should provide quick, at-a-glance insights, and a table visualization forces the viewer to read through rows of data rather than immediately grasping trends or outliers. For high-level decision-making, visualizations like line charts, bar charts, or KPI tiles are more effective at conveying key metrics without cognitive overload.

Answer

The data sources do not include all necessary tables.

Answer

The alert condition for revenue is set too low.

Answer

The refresh schedule is too frequent.

Question 4

A data analytics team has created a report for stakeholders. The report includes complex statistical terms and raw data tables. Stakeholders are confused and ask for clarification. Which of the following should the team do to improve communication?

Accepted Answer

Simplify the report by using clear visualizations and plain language summaries.. Effective data communication requires tailoring the message to the audience. By replacing complex statistical terms and raw data tables with clear visualizations and plain language summaries, the team makes insights accessible to stakeholders who may lack technical expertise, directly addressing the confusion.

Answer

Schedule a follow-up meeting to explain each term individually.

Answer

Provide a glossary of statistical terms and keep the report as is.

Answer

Remove all data and only give conclusions.

Question 5

A data analyst is creating a data story for a marketing campaign results. Which of the following narrative structures is most effective for engaging the audience?

Accepted Answer

Start with a key insight or finding, then provide supporting evidence.. Starting with a key insight or finding captures the audience's attention immediately, and then providing supporting evidence builds a compelling narrative that keeps the audience engaged. Option A uses a question-and-answer format without a clear flow, which can be confusing and lacks direction. Option B presents all data points chronologically, which may be monotonous and fail to highlight the most important insights. Option C starts with methodology, which is technical and may lose the audience before the key findings are presented.

Answer

Use a question-and-answer format without a clear flow.

Answer

Present all data points chronologically.

Answer

Start with the methodology, then data, then results.

Question 6

A company wants to ensure that data visualizations are accessible to colorblind users. Which of the following is a best practice?

Accepted Answer

Combine color with patterns or labels.. Combining color with patterns or labels ensures that information is conveyed through multiple visual channels, making it accessible to colorblind users who may not distinguish certain hues. This practice aligns with WCAG (Web Content Accessibility Guidelines) 2.1, which recommend using more than one sensory characteristic (e.g., shape, text, or pattern) to communicate data, rather than relying solely on color.

Answer

Avoid using any colors.

Answer

Rely solely on color to convey information.

Answer

Use only shades of green and red.

Question 7

A data analyst is troubleshooting a dashboard that displays incorrect totals for sales by region. The data source queries are correct. Which of the following is the most likely cause?

Accepted Answer

The filter context is inadvertently excluding some regions.. Filter context can inadvertently exclude certain regions, leading to incorrect totals. Options A, B, and C are less likely: A affects performance not accuracy; B would be caught by correct queries; C could cause aggregation differences but filters are a common issue.

Answer

The visualizations are using a different aggregation level.

Answer

The data model includes duplicate records.

Answer

The dashboard is using a live connection instead of an extract.

Question 8

A data team needs to communicate insights about customer churn to the sales team. The insights include confidence intervals and p-values. The sales team is not familiar with statistics. Which of the following should the data team do?

Accepted Answer

Explain the practical implications of the results without statistical jargon.. The sales team lacks statistical background, so presenting confidence intervals and p-values directly would cause confusion. The data team should translate these results into practical business implications—such as 'customers with a 30-day inactivity are 40% more likely to churn'—without using terms like p-value or confidence interval. This aligns with the DA0-001 objective of tailoring communication to the audience's expertise level.

Answer

Assume the sales team will learn the terms over time.

Answer

Use technical terms but provide written definitions.

Answer

Include a detailed statistical appendix.

Question 9

When presenting data insights to a technical audience, which of the following is most important to include?

Accepted Answer

Details on data sources, transformations, and methodology.. For a technical audience, the most important element is transparency in data provenance and methodology, as they need to assess the validity and reproducibility of the analysis. Including details on data sources, transformations, and methodology allows them to verify assumptions, identify potential biases, and understand the analytical pipeline. This aligns with the DA0-001 domain of Communicating Data Insights, where technical stakeholders require rigorous documentation over persuasive elements.

Answer

A call to action for the next steps.

Answer

Colorful charts and infographics.

Answer

High-level summaries and executive recommendations.

Question 10

A data team is communicating findings from a machine learning model that predicts equipment failure. The model has high accuracy but low recall. Which of the following statements is the most accurate way to communicate the model's performance to the maintenance team?

Accepted Answer

"The model has a high precision but low recall, so it misses many failures.". It directly states that the model has high precision but low recall, which means that when the model predicts a failure, it is likely correct (few false positives), but it fails to identify many actual failures (many false negatives). This is the most accurate way to communicate the trade-off to the maintenance team, as it clearly indicates that the model will miss some failures despite its high accuracy.

Answer

"The model has a high precision, so when it alerts, it is usually correct, but it may miss some failures."

Answer

"The model rarely misses a failure, but may have false positives."

Answer

"The model is highly reliable and catches almost all failures."

Question 11

A data analyst is creating a report on customer satisfaction scores across different regions. The analyst wants to highlight regions that are significantly below average. Which of the following statistical methods is most appropriate for identifying these outliers?

Accepted Answer

Box plot with interquartile range (IQR) to identify outliers.. A box plot with interquartile range (IQR) is the most appropriate method because it explicitly identifies outliers as data points falling below Q1 - 1.5*IQR or above Q3 + 1.5*IQR. This directly addresses the analyst's goal of highlighting regions significantly below average, as the IQR method is a standard statistical technique for detecting extreme values in a distribution.

Answer

Bar chart with average line.

Answer

Pie chart of satisfaction categories.

Answer

Scatter plot of satisfaction vs. region.

Question 12

A data analyst is preparing a presentation for a mixed audience of executives and technical staff. Which two of the following practices would be most effective? (Select TWO.)

Accepted Answer

Provide a detailed appendix for technical staff.. A detailed appendix allows technical staff to access granular data, methodology, and supporting statistics without overwhelming the executive audience. This practice aligns with the principle of audience segmentation in data communication, ensuring that each stakeholder group receives the appropriate level of detail without disrupting the presentation flow.

Answer

Use only text-heavy slides to include all details.

Answer

Avoid any data visualizations to prevent confusion.

Answer

Use complex statistical terms without explanation.

Question 13

A data analyst is troubleshooting a dashboard that displays slowly. Which two of the following are common causes of dashboard performance issues? (Select TWO.)

Accepted Answer

Large unaggregated datasets.. Large unaggregated datasets force the dashboard to process every row of raw data at query time, which dramatically increases load times and memory consumption. Aggregated or pre-summarized tables reduce the volume of data scanned, improving performance.

Answer

Minimal use of filters.

Answer

Use of summary tables.

Answer

Excessive use of live data connections.

Question 14

A data analyst is communicating insights about a sales forecast to stakeholders. Which three of the following should the analyst include to build trust and clarity? (Select THREE.)

Accepted Answer

The confidence intervals around the forecast.. Confidence intervals are correct because they quantify the uncertainty around the forecast, providing a range within which the true value is expected to fall with a certain probability (e.g., 95%). This directly builds trust by showing stakeholders that the analyst acknowledges variability and does not present a single point estimate as absolute truth.

Answer

Only the most optimistic scenario.

Answer

The raw data used for the forecast.

Question 15

Refer to the exhibit. A data analyst is reviewing a data quality report. Which of the following actions should the analyst take first?

Accepted Answer

Investigate the source system to understand why emails are missing.. The first step in data quality remediation is root cause analysis. Without understanding why 1200 records have null emails (e.g., a source system bug, a failed ETL join, or a missing required field), any corrective action like deletion or placeholder insertion risks introducing bias or masking a systemic issue. Investigating the source system aligns with the data governance principle of 'fix the source, not the symptom.'

Answer

Delete the 1200 records with null emails.

Answer

Fill null emails with a placeholder.

Answer

Ignore the nulls as they are not critical.