DA0-002 Data Governance Practice Test 2 — 15 Questions

Question 1

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 2

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 3

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 4

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 5

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

Question 6

A data analyst creates a dashboard for operational metrics. The operations team reports that the dashboard is confusing because it shows too many metrics on one screen. Which design principle should the analyst apply?

Accepted Answer

Apply progressive disclosure. Progressive disclosure is a design principle that presents only the most critical information initially, with the option to reveal additional details as needed. This directly addresses the operations team's complaint of too many metrics on one screen by reducing cognitive load and allowing users to drill down into specific metrics when required. In dashboard design, this is often implemented through expandable sections, hover-over tooltips, or click-through layers.

Answer

Increase white space

Answer

Use a single chart type

Answer

Add more filters

Question 7

An analyst presents a report to stakeholders who are not data-savvy. The report includes a box plot showing the distribution of customer satisfaction scores. One stakeholder asks, 'What do the whiskers mean?' Which communication strategy should the analyst use?

Accepted Answer

Explain that the whiskers show the range of typical scores, like the spread of data.. It uses plain language ('range of typical scores') to explain whiskers to a non-technical audience, aligning with the DA0-001 domain of communicating data insights effectively. The whiskers in a box plot typically extend to the minimum and maximum values within 1.5 times the interquartile range (IQR), representing the spread of data without outliers, which is accurately described as 'typical scores' for stakeholders who are not data-savvy.

Answer

Provide a handout with definitions of box plot elements.

Answer

Replace the box plot with a bar chart of average scores.

Answer

State that the whiskers represent the minimum and maximum values excluding outliers.

Question 8

A data analyst needs to present the results of a customer segmentation analysis to the marketing team. The analysis identified four segments based on purchasing behavior. Which visualization is most effective for showing the characteristics of each segment?

Accepted Answer

Radar chart. A radar chart is the most effective visualization for comparing multiple quantitative variables across different categories, such as the purchasing behavior characteristics of each customer segment. It allows the marketing team to see the profile of each segment at a glance by plotting each characteristic on a separate axis radiating from a central point, making it easy to identify strengths, weaknesses, and similarities between segments.

Answer

Histogram

Answer

Heatmap

Answer

Scatter plot

Question 9

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 10

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 11

Which TWO actions are appropriate when creating a data visualization for a diverse audience with varying levels of data literacy? (Choose two.)

Accepted Answer

Use clear and descriptive axis labels.. Clear and descriptive axis labels ensure that all viewers, regardless of their data literacy level, can understand what the axes represent. This directly supports accessibility and reduces misinterpretation, which is critical when presenting to a diverse audience.

Answer

Use only one chart type throughout the report.

Answer

Include interactive elements like drill-downs for all charts.

Answer

Include a legend only if there are more than three data series.

Question 12

Which THREE elements should be included in a data insight report to ensure it is actionable? (Choose three.)

Accepted Answer

The level of confidence or statistical significance.. An actionable data insight report must include the level of confidence or statistical significance to allow decision-makers to assess the reliability of the findings. Without this, stakeholders cannot determine whether the observed patterns are likely to be real or due to random chance, which is critical for making data-driven decisions.

Answer

The source code of the analysis scripts.

Answer

All raw data used in the analysis.

Question 13

You are a data analyst at a retail company. Your team has deployed a new dashboard that displays real-time inventory levels across all warehouses. The dashboard uses a traffic light color scheme (green = sufficient, yellow = low, red = out of stock). After one week, the warehouse managers complain that the dashboard is overwhelming because it shows all 500+ products at once, and they cannot quickly identify which items need immediate attention. They request a way to prioritize items that are red or yellow. Additionally, the dashboard updates every second, causing the screen to flicker constantly, which they find distracting. You need to redesign the dashboard to address these issues. Which course of action should you take?

Accepted Answer

Add a filter to show only items with red or yellow status, and reduce the refresh rate to every 5 minutes.. It directly addresses both user complaints: adding a filter to show only red/yellow items reduces cognitive overload by hiding the 500+ products that are not critical, and reducing the refresh rate from every second to every 5 minutes eliminates distracting screen flicker while still providing near-real-time inventory updates. This approach balances usability with the need for timely alerts without overwhelming the user.

Answer

Replace the dashboard with a static table that shows all products sorted alphabetically, and increase the refresh rate to every 2 seconds.

Answer

Remove the color scheme and display only numerical values, and keep the refresh rate at 1 second.

Answer

Add additional colors to distinguish more inventory levels and increase the refresh rate to every 500 milliseconds.

Question 14

A data analyst needs to present findings to a non-technical executive audience. Which visualization type is most appropriate to communicate a clear comparison of sales performance across multiple regions for the current quarter?

Accepted Answer

Bar chart. A bar chart is the most appropriate choice because it excels at comparing discrete categories (regions) using a common baseline, making it easy for a non-technical audience to quickly see which regions performed best or worst in the current quarter. The vertical or horizontal bars provide a clear, direct visual comparison of sales performance without requiring interpretation of trends or correlations.

Answer

Scatter plot

Answer

Line chart

Answer

Heatmap

Question 15

Which TWO of the following are best practices when creating a data visualization for a presentation to stakeholders?

Accepted Answer

Including interactive filters when possible to allow stakeholders to explore data. Interactive filters (e.g., slicers, parameter controls) empower stakeholders to drill down into specific data subsets, ask ad-hoc questions, and uncover insights without overwhelming the initial view. This aligns with the principle of user-driven exploration, which is a best practice for stakeholder presentations where different audience members may have varying interests. Including interactivity also reduces the need for multiple static charts, keeping the presentation concise while still offering depth.

Answer

Placing the legend at the bottom of the chart

Answer

Using 3D effects to make the chart visually appealing

Answer

Using only one type of chart throughout the presentation for consistency