DA0-002 Data Governance Practice Test 6 — 15 Questions

Question 1

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 2

Refer to the exhibit. A data analyst receives this error when running a data load script. What is the most likely cause?

Accepted Answer

The customer_id 12345 already exists in the table. The error message states 'Duplicate entry '12345' for key 'PRIMARY'', indicating that a record with customer_id 12345 already exists in the table. Option A (email too long) would produce a data truncation error, not a duplicate key error. Option B (connection lost) would result in a connection timeout or similar error. Option D (name field null) could cause a constraint violation if the column is not nullable, but the specific error here is a primary key violation.

Answer

The email field is too long

Answer

The database connection is lost

Answer

The name field is null

Question 3

Refer to the exhibit. A data analyst is creating a report that includes customer transaction data from 6 years ago. According to the policy, what should the analyst do?

Accepted Answer

Exclude the data because it exceeds the retention period. The data retention policy specifies that customer transaction data must be retained for only 5 years. Since the data is from 6 years ago, it exceeds the retention period and must be excluded from the report to comply with data governance and regulatory requirements. Including or modifying such data would violate policy and potentially expose the organization to legal or compliance risks.

Answer

Anonymize the data before inclusion

Answer

Flag the data for review

Answer

Include the data since it is valuable for analysis

Question 4

A data analyst creates a line chart showing monthly sales over the past year. The chart uses a y-axis starting at $100,000 instead of zero. What is the most likely misinterpretation a viewer might have?

Accepted Answer

The differences between months are exaggerated, making small changes look large.. Starting the y-axis at $100,000 instead of zero truncates the baseline, which visually exaggerates the relative differences between monthly sales values. This is a common data visualization pitfall that can mislead viewers into perceiving small fluctuations as significant trends, violating the principle of using a zero baseline for bar and line charts to accurately represent proportional change.

Answer

The sales appear to be decreasing when they are actually increasing.

Answer

The chart is correctly scaled, so no misinterpretation occurs.

Answer

The sales appear to be increasing when they are actually decreasing.

Question 5

A data team created a dashboard for executives. The dashboard updates daily and includes several KPIs. Executives complain that they cannot quickly identify the most critical issues. Which design change would best address this?

Accepted Answer

Incorporate conditional formatting with color alerts.. Conditional formatting with color alerts (e.g., red for critical thresholds, yellow for warnings) directly addresses the executives' need to quickly identify critical issues at a glance. This design change leverages pre-attentive visual processing, allowing users to spot anomalies without manually scanning each KPI. It is a standard best practice in dashboard design for executive reporting, as it reduces cognitive load and speeds up decision-making.

Answer

Use a single aggregated metric to simplify.

Answer

Increase the refresh rate to every hour.

Answer

Add more detailed charts to each KPI.

Question 6

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.

Question 7

A data analyst needs to present findings about customer churn to business stakeholders. The analysis identified that churn is highest among customers who have called customer support more than three times in the last month. Which of the following is the best way to communicate this insight?

Accepted Answer

A bar chart comparing churn rates for different support call counts.. A bar chart directly compares churn rates across discrete categories of support call counts (e.g., 0, 1, 2, 3, 4+ calls), making it easy for stakeholders to see the spike at 'more than three calls'. This aligns with the insight that churn is highest among customers with >3 support calls, and a bar chart is the standard visualization for comparing a continuous metric (churn rate) across categorical bins.

Answer

A scatter plot to show the relationship between support calls and churn.

Answer

A pie chart showing the proportion of churned vs. retained customers.

Answer

A table of raw churn data by customer ID.

Question 8

A data analyst creates a dashboard that includes a map showing sales by region. The map uses a continuous color gradient from light yellow to dark blue. Some regions with very high sales appear as dark blue, but many regions with moderate sales appear similar. Which improvement would most enhance the readability?

Accepted Answer

Use a discrete color scale with distinct bins for sales ranges.. A discrete color scale with distinct bins for sales ranges eliminates the ambiguity caused by a continuous gradient, where moderate sales values blend together. By grouping sales into defined intervals (e.g., $0–$10K, $10K–$50K, etc.), each region is assigned a unique, easily distinguishable color, making it immediately clear which sales bracket a region falls into without requiring precise color differentiation.

Answer

Switch to a diverging color scheme with a neutral midpoint.

Answer

Increase the map size to show more detail.

Answer

Add data labels to each region showing exact sales numbers.

Question 9

A data team is preparing a quarterly business review for the CEO. The report must include both high-level summaries and the ability for the CEO to drill down into specific departments. Which reporting technique best meets this requirement?

Accepted Answer

An interactive dashboard with drill-down capabilities.. An interactive dashboard with drill-down capabilities (Option B) is the correct choice because it directly addresses the requirement for both high-level summaries and the ability to explore specific departments. Dashboards allow the CEO to view aggregated KPIs at a glance and then click through to detailed views for each department, providing a seamless, user-driven exploration experience without switching between separate reports or slides.

Answer

A slide deck with one slide per department.

Answer

A static PDF with a summary page and appendices.

Answer

A data dump in Excel with filters.

Question 10

A data analyst is asked to create a visualization showing the trend of monthly revenue over the last five years. Which chart type is most suitable?

Accepted Answer

Line chart.. A line chart is the most suitable choice because it explicitly shows the trend of monthly revenue over a continuous time period (five years). The x-axis represents time (months), and the y-axis represents revenue, allowing the viewer to easily identify patterns, seasonality, and overall direction. This makes it ideal for time-series data visualization.

Answer

Pie chart.

Answer

Histogram.

Answer

Bar chart.

Question 11

A company's sales dashboard shows that the current month's revenue is $1.2M, which is 10% below the target of $1.33M. The analyst wants to highlight this shortfall. Which method of data presentation is most effective?

Accepted Answer

Use a bullet chart showing actual vs. target.. A bullet chart is the most effective method because it is specifically designed to show performance against a target, combining a bar for the actual value ($1.2M) with a reference line or marker for the target ($1.33M). This allows the analyst to immediately visualize the 10% shortfall in a compact, high-density format without needing to compare separate numbers or interpret a trend. It directly addresses the goal of highlighting the variance, which is a core principle in data presentation for performance dashboards.

Answer

Show a trend line of the last 12 months.

Answer

Provide a table of all monthly targets and actuals.

Answer

Display the actual revenue only.

Question 12

A data analyst is creating a presentation for the board of directors. The board members have varying levels of data literacy. The analyst wants to ensure that the key insight—that customer satisfaction scores have declined by 15% due to longer wait times—is understood by everyone. Which approach is best?

Accepted Answer

Use a simple annotated line chart with a clear callout on the decline.. A simple annotated line chart with a clear callout on the decline is intuitive and draws attention to the key insight. Options A, B, and C are either too complex or not focused.

Answer

Include a complex statistical model showing the correlation.

Answer

Show a scatter plot of wait time vs. satisfaction.

Answer

Provide raw data in a spreadsheet for review.

Question 13

A data analyst is designing a dashboard for a sales team. Which TWO of the following are best practices for dashboard design?

Accepted Answer

Use consistent color coding for similar metrics.. Consistent color coding for similar metrics reduces cognitive load and helps users quickly interpret data without re-learning visual cues. In dashboard design, this aligns with Gestalt principles of similarity and proximity, ensuring that revenue metrics, for example, always appear in the same color across charts. This practice is recommended by data visualization experts like Stephen Few and is a standard in tools like Tableau and Power BI.

Answer

Use complex visualizations to impress users.

Answer

Include as many KPIs as possible on one screen.

Answer

Use a single chart type for all visuals.

Question 14

A data analyst is preparing a data storytelling presentation for a non-technical audience. Which THREE techniques are most effective for communicating insights?

Accepted Answer

Using relevant visuals such as charts and graphs.. Data storytelling for non-technical audiences relies on visuals like charts and graphs to make complex data patterns immediately understandable, reducing cognitive load and enabling faster insight absorption. Effective visuals should be simple, clearly labeled, and directly tied to the narrative, avoiding clutter that could confuse the audience.

Answer

Including raw data tables for reference.

Answer

Adding complex statistical terms to demonstrate expertise.

Question 15

A data team is creating a report for the board of directors. The board wants to see both the big picture and the ability to explore details for specific regions. Which TWO approaches should the team implement?

Accepted Answer

Include an interactive dashboard with filters by region.. Interactive dashboards with filters allow the board to see high-level summaries while drilling into region-specific details on demand. This approach aligns with modern BI tools like Tableau or Power BI, which support dynamic filtering and cross-filtering without requiring separate report pages.

Answer

Use a single summary metric for all regions.

Answer

Embed a table of data for each region in an appendix.

Answer

Provide a static executive summary with no drill-down.