Knowledge + Practice

CCNA Data Governance Questions

75 of 119 questions · Page 1/2 · Data Governance · Answers revealed

Practice these questions Domain overview All questions

1

Multi-Selecteasy

Which TWO of the following are effective techniques for presenting data to a non-technical audience?

Select 2 answers

A.Explain the statistical methods used in the analysis.

B.Include detailed data tables for reference.

C.Highlight the most important insights using callouts.

D.Use many different colors to distinguish data points.

E.Use simple language and avoid jargon.

AnswersC, E

Callouts place short annotations directly beside the relevant data points, directing a non-technical audience's attention to the key insight without requiring them to interpret axes or legends. This satisfies the constraint of presenting effectively to viewers lacking analytical background, reducing cognitive effort.

Why this answer

Option C is correct because callouts draw a non-technical audience's attention directly to the key insights, letting them grasp the main message without needing to interpret raw data or charts themselves. Option E is correct because using simple language and avoiding jargon makes the presentation accessible to listeners who lack a technical or statistical background, ensuring the findings are understood rather than obscured. Options A and B do not belong because explaining statistical methods and providing detailed data tables cater to a technical or analytical audience and tend to overwhelm non-technical listeners with unnecessary detail.

Option D is also incorrect because using many different colors can create visual clutter and confusion rather than clarifying the data for a general audience.

Exam trap

CompTIA often tests the misconception that non-technical audiences need more data (tables, statistics) to understand insights, when in fact they need less—focusing on simplicity, visual emphasis, and clear language—so candidates mistakenly choose options A, B, or D thinking they are thorough.

Practice this question →

2

MCQhard

A data analyst creates a dashboard for executives that shows a key metric trending downward. The analyst notices that the metric is highly volatile day-to-day. Which visualization type is most appropriate to show the underlying trend?

A.7-day moving average line chart.

B.Pie chart showing proportion of days.

C.Scatter plot with regression line.

D.Daily bar chart.

AnswerA

A 7-day moving average smooths daily volatility by averaging each point with the preceding six days, revealing the underlying directional trend. Executives see the genuine trajectory rather than noise, directly addressing the highly volatile day-to-day readings in the stem.

Why this answer

A 7-day moving average line chart smooths out day-to-day volatility by averaging each point with the preceding six days, revealing the underlying directional trend that executives need to see. Because the metric is highly volatile, plotting raw daily values would obscure the trend in noise; the moving average makes the downward trajectory visually obvious while preserving the time-series nature of the data.

Exam trap

The trap here is confusing 'showing the data' with 'showing the trend' — candidates pick the daily bar chart because it is the most detailed, but the question explicitly asks for the underlying trend, which requires smoothing.

How to eliminate wrong answers

Option B is wrong because a pie chart shows parts of a whole at a single point in time and cannot represent a trend over time at all — it is a categorical composition chart, not a time-series chart. Option C is wrong because a scatter plot with regression line is used to show correlation between two continuous variables, not to display a single metric's trend over time; it also does not smooth volatility. Option D is wrong because a daily bar chart plots every raw data point, so the day-to-day volatility the analyst already noticed would dominate the visual and hide the trend.

Practice this question →

3

MCQmedium

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?

A.A single line chart with all regions

B.A KPI card with total sales

C.A combination of a line chart for total and a stacked area chart for regional breakdown

D.A table with all quarterly figures

AnswerC

A line chart shows the overall quarterly trend while a stacked area chart decomposes the same timeline by region, satisfying the CEO's dual requirement. Both share one time axis, letting the board read total and regional contribution together without switching views.

Why this answer

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.

Exam trap

The trap here is that candidates often choose a single line chart (Option A) thinking it shows both trend and breakdown, but they overlook that multiple overlapping lines make it hard to see the aggregate trend, which is the CEO's primary need.

How to eliminate wrong answers

Option A is wrong because a single line chart with all regions would create visual clutter and make it difficult to discern the overall trend from the regional lines, especially if regions have overlapping values; it fails to provide a clear aggregate view. Option B is wrong because a KPI card with total sales only shows a single number, which cannot convey the quarterly trend or regional breakdown required by the CEO. Option D is wrong because a table with all quarterly figures forces the board to manually parse numbers to identify trends and regional contributions, which is inefficient for a high-level presentation and violates the principle of data visualization for quick insight.

Practice this question →

4

MCQhard

A multinational retailer must comply with GDPR for its European customers. The governance team is mapping where personal data originates, how it flows between the CRM, marketing automation platform, and analytics warehouse, and which transformations occur at each hop. Which governance capability does this mapping effort primarily establish?

A.Data lineage

B.Data quality profiling

C.Data stewardship assignment

D.Master data management

AnswerA

Data lineage documents the origin, movement, and transformation of data across systems. By tracing personal data from the CRM through marketing automation into the analytics warehouse, the team builds the end-to-end visibility GDPR requires for subject access requests, deletion propagation, and breach impact analysis. This capability directly answers where data comes from and what happens to it.

Why this answer

Mapping origins, flows, and transformations of personal data across systems is the definition of data lineage. GDPR requires organizations to know where personal data resides and how it moves to fulfill access requests, propagate erasure, and assess breach scope. Lineage provides that traceability, whereas quality profiling, master data management, and stewardship address different governance concerns.

Exam trap

The trap here is equating any governance mapping exercise with master data management or stewardship, when the specific trace of origin, flow, and transformation is lineage.

Practice this question →

5

MCQhard

A government agency's data analyst is commissioned to produce a report on public transportation usage trends. The report will be read by policymakers, transit planners, and the general public. The data includes ridership numbers, delay rates, and demographic breakdowns. The analyst needs to ensure the report is accessible and persuasive, especially to non-technical readers. The goal is to advocate for increased funding in underserved areas. The report must be data-driven but also tell a compelling story. What strategy should the analyst prioritize?

A.Provide raw data in appendices only.

B.Create a narrative that highlights the impact of delayed trains on low-income commuters.

C.Use complex statistical analysis to show significance of trends.

D.Focus solely on ridership numbers without context.

AnswerB

Framing delay rates around low-income commuters converts ridership and demographic data into a human impact story, satisfying the stem's demand for a persuasive, non-technical narrative that advocates funding for underserved areas. Policymakers and the public grasp consequences faster than raw statistics, making the funding case compelling.

Why this answer

It directly addresses the need to make data accessible and persuasive to non-technical readers by weaving a narrative around a specific, relatable impact (delayed trains on low-income commuters). This approach aligns with the goal of advocating for increased funding in underserved areas, as it humanizes the data and creates a compelling story that policymakers and the public can understand and act upon, without requiring technical expertise.

Exam trap

The trap here is that candidates often choose Option C (complex statistical analysis) because they equate 'data-driven' with technical rigor, failing to recognize that the exam's focus on 'communicating data insights' prioritizes accessibility and persuasion over statistical complexity for non-technical stakeholders.

How to eliminate wrong answers

Option A is wrong because providing raw data only in appendices fails to make the report accessible or persuasive; it buries the key insights and requires readers to perform their own analysis, which is ineffective for non-technical audiences. Option C is wrong because using complex statistical analysis (e.g., p-values, regression coefficients) would alienate non-technical readers like the general public and many policymakers, making the report inaccessible and undermining its persuasive power. Option D is wrong because focusing solely on ridership numbers without context (e.g., demographic breakdowns, delay rates) provides no narrative or actionable insight, failing to tell a compelling story or advocate for specific funding needs.

Practice this question →

6

Multi-Selecteasy

A data analyst discovers an anomaly in a dataset. Which two actions should be taken before reporting? (Choose TWO.)

Select 2 answers

A.Assume the anomaly is real and report it

B.Immediately alert all stakeholders

C.Verify the data source and extraction process

D.Check for data entry errors or technical glitches

E.Remove the anomaly without documentation

AnswersC, D

Verifying the source and extraction process confirms the anomaly reflects real data rather than a pipeline fault, satisfying the need to validate findings before reporting. Checking lineage, transformation logic and load errors distinguishes genuine outliers from artefacts introduced during ETL, preventing false alarms reaching stakeholders.

Why this answer

Option C is correct because verifying the data source and extraction process ensures the anomaly is not an artifact of how the data was pulled, transformed, or joined before it is escalated. Option D is correct because checking for data entry errors or technical glitches (e.g., sensor faults, ETL failures, or duplicate records) confirms whether the anomaly reflects a genuine signal or a data quality issue. Both steps establish validity and reproducibility of the finding, which is essential prior to reporting.

Option A is wrong because assuming the anomaly is real without validation risks reporting a false positive. Option B is wrong because alerting all stakeholders immediately is premature before the anomaly is verified. Option E is wrong because removing the anomaly without documentation destroys evidence and violates data integrity and auditability practices.

Exam trap

The trap here is that candidates may confuse 'immediate reporting' with proactive communication, but CompTIA Data+ expects the understanding that data validation must precede any stakeholder notification to maintain data credibility.

Practice this question →

7

MCQeasy

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?

A.The differences between months are exaggerated, making small changes look large.

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

C.The chart is correctly scaled, so no misinterpretation occurs.

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

AnswerA

A truncated y-axis compresses the visual distance that represents zero, so equal dollar gaps occupy unequal chart heights. Monthly variations therefore appear steeper than they are, exaggerating differences and making minor fluctuations look like significant shifts.

Why this answer

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.

Exam trap

The trap here is that candidates may think a truncated y-axis only affects bar charts or that it reverses trends, but CompTIA often tests the specific misinterpretation that small changes appear exaggerated due to the loss of a zero baseline, not that the direction of the trend is flipped.

How to eliminate wrong answers

Option B is wrong because a truncated y-axis does not inherently reverse the direction of a trend; it only amplifies the visual magnitude of changes, so sales that are actually increasing would still appear to increase, just more dramatically. Option C is wrong because the chart is not correctly scaled for accurate proportional interpretation; starting the y-axis at a non-zero value is a deliberate distortion that can mislead viewers, and best practices for data visualization recommend a zero baseline for line charts showing magnitude. Option D is wrong because a truncated y-axis does not reverse the direction of a trend; if sales are actually decreasing, they would still appear to decrease, but the visual drop would be exaggerated, not inverted.

Practice this question →

8

Multi-Selecthard

A data analyst is creating a data story about sales performance. Which THREE elements are essential for effective data storytelling? (Choose THREE.)

Select 3 answers

A.Raw data tables for reference.

B.A clear narrative with a beginning, middle, and end.

C.Context and background information.

D.Use of multiple chart types to show variety.

E.A call to action.

AnswersB, C, E

A clear narrative with a beginning, middle and end gives the sales data a logical structure, guiding the audience from the situation through the analysis to the conclusion, which is essential for coherent, persuasive data storytelling.

Why this answer

Option B is correct because effective data storytelling requires a clear narrative arc — a beginning that sets up the situation, a middle that presents the analysis and insights, and an end that resolves the story — which guides the audience logically from data to meaning. Option C is correct because context and background information are essential to make the data interpretable, helping the audience understand the business situation, benchmarks, and why the findings matter. Option E is correct because a call to action directs the audience toward a specific decision or next step, which is the ultimate purpose of a data story and distinguishes storytelling from mere data reporting.

Option A does not belong because raw data tables are supporting evidence, not an essential storytelling element; dumping raw data can overwhelm the audience and obscure the narrative. Option D does not belong because using multiple chart types is a stylistic choice for variety, not a requirement — a single well-chosen visualization can be more effective than several charts used merely for the sake of variety.

Exam trap

CompTIA often tests the distinction between supporting elements (like raw data tables or chart variety) and the core structural components (narrative, context, call to action) that define effective data storytelling.

Practice this question →

9

Multi-Selectmedium

A data analyst at a healthcare organization is preparing a dataset for analysis that includes patient identifiers. The organization must comply with HIPAA and internal data governance policies. Which two actions should the analyst take to protect patient privacy while enabling analysis? (Choose two.)

Select 2 answers

A.Aggregate all patient data into summary statistics before any analysis is performed.

B.Replace patient names and Social Security numbers with pseudonyms before sharing the dataset with analysts.

C.Store the dataset on a shared network drive with read permissions for the entire department.

D.Remove or mask direct identifiers such as names, addresses, and phone numbers from the dataset.

E.Encrypt the dataset using AES-256 and share the decryption key with all analysts.

AnswersB, D

Pseudonymization replaces direct identifiers with artificial identifiers, reducing privacy risk while preserving the ability to link records. It is a recognized HIPAA-safe harbor technique when applied correctly. This allows analysts to work with the data without exposing protected health information directly, supporting both privacy and utility.

Why this answer

To protect patient privacy while enabling analysis, the analyst should apply de-identification techniques. Masking or removing direct identifiers prevents immediate identification, and pseudonymization further reduces risk by replacing identifiers with codes. Together, these actions support HIPAA compliance and internal governance by minimizing exposed protected health information while preserving data utility for analysis.

Exam trap

The trap here is thinking that encryption alone or broad access controls are sufficient, when the core need is to de-identify the data itself.

Practice this question →

10

MCQeasy

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?

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

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

C.A bar chart comparing churn rates for different support call counts.

D.A table of raw churn data by customer ID.

AnswerC

A bar chart plotting churn rate against support call count directly exposes the threshold relationship, showing churn rising beyond three calls. This visual encoding satisfies the need to communicate a quantitative pattern to business stakeholders clearly and immediately.

Why this answer

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.

Exam trap

The trap here is that candidates may choose a scatter plot (Option A) because they think it shows 'relationship', but they fail to recognize that a scatter plot is inappropriate for a binary dependent variable and discrete independent variable, whereas a bar chart is the correct choice for comparing rates across categories.

How to eliminate wrong answers

Option A is wrong because a scatter plot is used to show the relationship between two continuous variables, but here the independent variable (number of support calls) is discrete and the dependent variable (churn) is binary, so a scatter plot would produce overlapping points and fail to clearly communicate the categorical threshold of 'more than three calls'. Option B is wrong because a pie chart only shows the overall proportion of churned vs. retained customers, which does not convey the relationship between support call frequency and churn, missing the key insight entirely. Option D is wrong because a table of raw churn data by customer ID presents unaggregated, granular data that obscures the pattern and is not suitable for a high-level stakeholder presentation; it would require the audience to manually compute churn rates per call count.

Practice this question →

11

MCQhard

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?

A.Bar chart with average line.

B.Pie chart of satisfaction categories.

C.Box plot with interquartile range (IQR) to identify outliers.

D.Scatter plot of satisfaction vs. region.

AnswerC

The IQR defines the middle 50% of scores; values falling below Q1 minus 1.5×IQR sit statistically apart from the distribution, flagging regions genuinely below average. A box plot displays this spread and its outliers directly, satisfying the requirement to highlight underperforming regions.

Why this answer

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.

Exam trap

The trap here is that candidates may choose a bar chart with an average line (Option A) because it visually shows deviations, but it lacks a formal statistical criterion to define 'significantly below average,' which the IQR-based box plot provides.

How to eliminate wrong answers

Option A is wrong because a bar chart with an average line only shows the mean and individual region values, but does not provide a statistical threshold to determine which regions are significantly below average; it merely visualizes deviations without identifying outliers. Option B is wrong because a pie chart of satisfaction categories shows proportions of categorical data, not numerical scores across regions, and cannot identify outliers or deviations from the mean. Option D is wrong because a scatter plot of satisfaction vs. region treats region as a categorical variable on one axis, which does not produce a meaningful distribution for outlier detection; it would simply plot points per region without any statistical measure of dispersion or outlier boundaries.

Practice this question →

12

MCQeasy

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?

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

B.Present all data points chronologically.

C.Start with the methodology, then data, then results.

D.Start with a key insight or finding, then provide supporting evidence.

AnswerD

Leading with the key insight satisfies the stem's engagement constraint by immediately giving the audience the campaign's headline result, then supplying supporting evidence to substantiate it. This inverted-pyramid structure exploits the primacy effect, so the most decision-relevant finding lands first rather than being buried after methodology or background.

Why this answer

Starting with a key insight or finding and then providing supporting evidence follows the inverted pyramid structure, which is the most effective narrative for engaging an audience. It immediately captures attention with the 'so what' and then justifies it with data. This approach aligns with best practices in data storytelling, where the headline finding drives interest before details are presented.

Exam trap

DA0-002 often tests the confusion between chronological/report-style structures (methodology first) and audience-centric structures (insight first), so candidates pick the familiar 'methodology, data, results' order thinking it is logical, when the exam expects the inverted pyramid.

How to eliminate wrong answers

Option A is wrong because a question-and-answer format without a clear flow lacks narrative structure and fails to guide the audience through a logical progression. Option B is wrong because presenting all data points chronologically is a data dump that buries the insight and does not prioritize what matters most. Option C is wrong because starting with methodology, then data, then results is a report-style structure that delays the key finding and risks losing audience engagement before the payoff.

Practice this question →

13

MCQhard

A telecommunications company's data governance audit reveals that a marketing analyst downloaded a full customer call detail record dataset to a personal laptop for weekend analysis. The dataset contains names, phone numbers, and call timestamps. The governance team must recommend a control that most directly prevents this specific scenario from recurring while preserving legitimate analytical work. Which control is most appropriate?

A.Encrypt the call detail record dataset at rest in the warehouse

B.Reduce the retention period for call detail records from five years to one year

C.Require annual security awareness training for all employees

D.Implement data loss prevention software that blocks transfers of classified data to unmanaged endpoints

AnswerD

DLP tools inspect outbound activity and block or alert when restricted data moves to unmanaged devices. This directly addresses the scenario by preventing the download itself while allowing analysts to work within sanctioned environments. It preserves legitimate analysis because approved endpoints and secure workspaces remain accessible, aligning control with the specific exfiltration path observed.

Why this answer

The observed risk is an authorized user moving restricted data to an unmanaged device, so the control must intercept that transfer path. Data loss prevention inspects and blocks such movements while leaving sanctioned analytical workflows intact. Training, encryption at rest, and retention reduction address different risks and would not have stopped this specific download.

Exam trap

The trap here is choosing a broad awareness or encryption control that sounds protective but does not intercept the actual data movement to a personal laptop.

Practice this question →

14

MCQeasy

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?

A.Stacked bar chart.

B.Pie chart for each quarter.

C.Line chart with multiple lines.

D.Grouped bar chart.

AnswerC

Multiple lines share one time axis, so each department's sales trajectory is plotted as a continuous series, making trends and divergences visible. This satisfies the stem's requirement to show sales trend over time per department, which categorical charts cannot express.

Why this answer

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.

Exam trap

CompTIA often tests the distinction between showing trends over time versus comparing discrete categories; the trap here is that candidates may choose a grouped bar chart (Option D) because it can display multiple departments, but they overlook that bars are better for comparing values at specific points rather than showing the continuous flow of time.

How to eliminate wrong answers

Option A is wrong because a stacked bar chart shows part-to-whole relationships over time, but it obscures individual department trends by stacking values on top of each other, making it difficult to compare the trend of each department separately. Option B is wrong because a pie chart for each quarter shows proportions within a single time period, not trends over time; pie charts are designed for static composition, not continuous temporal changes. Option D is wrong because a grouped bar chart compares discrete categories side by side, but it does not effectively convey the continuous trend of sales over time; the gaps between bars can make it harder to perceive the overall direction of change for each department.

Practice this question →

15

Multi-Selecthard

A data analyst is presenting a complex statistical analysis to a group of data scientists. The audience is highly knowledgeable. Which TWO approaches are most appropriate? (Choose two.)

Select 2 answers

A.Avoid mentioning uncertainty to maintain confidence

B.Use basic visualizations like pie charts

C.Include technical details and methodology

D.Present assumptions and limitations of the analysis

E.Simplify the findings to avoid confusion

AnswersC, D

A specialist audience of data scientists needs the statistical method, model choice and parameter settings to judge validity themselves. Omitting methodology would leave them unable to assess the analysis, so technical depth satisfies the stem's knowledgeable-audience constraint.

Why this answer

Option C is correct because a highly knowledgeable audience of data scientists can evaluate and trust the analysis when the presenter includes the technical details and methodology, such as the statistical tests, model choices, and parameter settings used. Option D is correct because presenting the assumptions and limitations of the analysis is essential for a technical audience to properly interpret the results, assess validity, and understand the boundaries of the conclusions. Options A, B, and E are not appropriate: hiding uncertainty undermines scientific integrity, basic visualizations like pie charts are inadequate for complex statistical findings, and oversimplifying would frustrate or mislead an expert audience rather than clarify the analysis.

Exam trap

CompTIA often tests the misconception that simplifying findings is always best for any audience, but the trap here is that highly knowledgeable audiences require technical precision and transparency, not oversimplification.

Practice this question →

16

Multi-Selectmedium

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

Select 3 answers

A.Using relevant visuals such as charts and graphs.

B.Including raw data tables for reference.

C.Adding complex statistical terms to demonstrate expertise.

D.Highlighting the most important finding with annotations.

E.Using a clear narrative with a beginning, middle, and end.

AnswersA, D, E

Relevant visuals translate quantitative findings into patterns a non-technical audience can grasp immediately, satisfying the stem's requirement to communicate insights effectively. Charts and graphs encode comparisons, trends and outliers spatially, bypassing statistical literacy barriers. This makes the insight accessible without requiring the audience to interpret raw tables or numerical summaries.

Why this answer

Option A is correct because relevant visuals such as charts and graphs translate quantitative findings into patterns a non-technical audience can grasp quickly, which is the core of effective data storytelling. Option D is correct because annotations that call out the most important finding direct audience attention to the key insight instead of forcing them to hunt for it, which sharpens the message. Option E is correct because a clear narrative with a beginning, middle, and end gives the presentation a logical flow that builds context, delivers the insight, and lands the takeaway for non-specialists.

Option B does not belong because raw data tables overwhelm non-technical listeners with detail and belong in an appendix rather than the main story. Option C does not belong because complex statistical terminology creates a barrier for a non-technical audience and shifts focus from insight to jargon.

Exam trap

The trap here is that candidates often confuse 'data completeness' with 'effective communication,' selecting raw data tables (Option B) thinking they provide transparency, when in fact they hinder comprehension for non-technical stakeholders.

Practice this question →

17

MCQhard

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?

A.Include a complex statistical model showing the correlation.

B.Show a scatter plot of wait time vs. satisfaction.

C.Provide raw data in a spreadsheet for review.

D.Use a simple annotated line chart with a clear callout on the decline.

AnswerD

An annotated line chart shows the trend over time, and the callout directs every reader to the 15% decline regardless of data literacy. This satisfies the need to communicate one key insight simply and unambiguously to a mixed audience.

Why this answer

A simple annotated line chart with a clear callout directly communicates the trend (15% decline) and the causal factor (longer wait times) without requiring statistical literacy. Board members with varying data literacy need a visual that highlights the 'so what' immediately, and annotation removes ambiguity about which part of the chart matters. This aligns with best practices for executive dashboards: one message per chart, minimal cognitive load, and explicit labeling of the insight.

Exam trap

The trap here is confusing 'more data' with 'better communication'—candidates may pick the scatter plot or statistical model because they seem more rigorous, but the exam tests audience-appropriate visualization, not analytical depth.

How to eliminate wrong answers

Option A is wrong because a complex statistical model showing correlation assumes the audience can interpret regression output, which contradicts the stated low data literacy and buries the insight in math. Option B is wrong because a scatter plot of wait time vs. satisfaction shows correlation but does not explicitly state the 15% decline or the causal narrative, leaving interpretation to the viewer. Option C is wrong because raw data in a spreadsheet forces the board to perform their own analysis, which is inappropriate for a presentation and does not guarantee the key insight is understood.

Practice this question →

18

Multi-Selectmedium

A data governance council is reviewing how a national retailer handles its customer master data. The council must document the people and groups accountable for the data across its lifecycle. Which TWO roles should be formally defined in the governance charter to establish clear accountability? (Choose two.)

Select 2 answers

A.Help desk technician, who resets passwords and triages user support tickets

B.Database administrator, who tunes indexes, manages backups, and performs schema migrations

C.Data steward, who applies governance policy day to day by maintaining definitions, quality rules, and issue resolution

D.Data owner, who is accountable for the quality, protection, and appropriate use of a data domain

E.Network engineer, who configures firewalls, routing, and segment isolation for the data center

AnswersC, D

A data steward operationalizes governance: curating definitions, monitoring quality, resolving discrepancies, and coordinating remediation. Defining this role in the charter connects policy to practice, so customer master data issues have a named operational point of contact rather than languishing without ownership between business and IT teams.

Why this answer

Accountability for a data domain is split between a decision-making owner and an operational steward. The owner answers for quality, protection, and use, while the steward executes policy through definitions, quality monitoring, and issue resolution. Infrastructure and support roles such as database administrators, network engineers, and help desk technicians keep systems running but hold no mandate over the business data itself.

Exam trap

The trap here is equating technical custody of a database with accountability for the business data, which belongs to owner and steward roles.

Practice this question →

19

MCQeasy

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?

A.Histogram

B.Heatmap

C.Radar chart

D.Scatter plot

AnswerC

A radar chart plots multiple variables on radial axes sharing one centre, letting viewers compare four segments across several purchasing-behaviour dimensions simultaneously. This multi-axis profile view exposes each segment's distinctive shape, which a bar or pie chart cannot convey for multivariate characteristics.

Why this answer

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.

Exam trap

The trap here is that candidates often choose a scatter plot or heatmap because they are more common in exploratory analysis, but the question specifically asks for showing the characteristics (multiple attributes) of each segment, which is best served by a radar chart's multi-axis comparison.

How to eliminate wrong answers

Option A is wrong because a histogram is used to show the distribution of a single continuous variable (e.g., frequency of purchase amounts) and cannot display multiple characteristics for multiple segments simultaneously. Option B is wrong because a heatmap is best for showing the magnitude of a single value across two categorical dimensions (e.g., segment vs. time period) but does not allow direct comparison of multiple distinct characteristics per segment. Option D is wrong because a scatter plot is designed to show the relationship between two continuous variables (e.g., age vs. spending) and cannot effectively display the multi-attribute profile of each segment.

Practice this question →

20

Drag & Dropmedium

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

Drag or tap steps into the slots.

Steps

Order

1Step 1

2Step 2

3Step 3

4Step 4

Why this order

Hypothesis testing involves stating hypotheses, setting alpha, collecting data, computing test statistic, and making a decision.

Practice this question →

21

MCQmedium

During a data presentation, an audience member questions the accuracy of the data shown. Which of the following is the best way for the analyst to respond?

A.Provide documentation of data sources and transformation steps

B.Change the topic

C.Offer to send the raw data later

D.Dismiss the question and continue

AnswerA

Supplying documentation of sources and transformation steps lets the questioner independently verify lineage, directly addressing the accuracy challenge with evidence rather than assertion. This traceability demonstrates the figures were derived through auditable, repeatable processes, which is the defensible response when data credibility is questioned during a presentation.

Why this answer

Providing documentation of data sources and transformation steps directly addresses the audience member's concern about accuracy by demonstrating transparency and traceability. This approach aligns with best practices in data governance, as it allows the audience to verify the data lineage and any ETL processes that may have introduced errors. It also builds trust by showing the analyst has a clear understanding of the data pipeline.

Exam trap

The trap here is that candidates may choose Option C, thinking that providing raw data is sufficient, but they overlook that raw data without transformation documentation does not prove accuracy and may even raise more questions about how the data was prepared.

How to eliminate wrong answers

Option B is wrong because changing the topic avoids the question entirely, which undermines the credibility of the analyst and fails to address the legitimate concern about data accuracy. Option C is wrong because offering to send raw data later delays the response and does not provide immediate clarification; raw data alone may also be insufficient without context on how it was processed. Option D is wrong because dismissing the question and continuing is dismissive and unprofessional, likely eroding audience trust and suggesting the analyst cannot defend the data's integrity.

Practice this question →

22

MCQmedium

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?

A.The database server is offline.

B.The query contains a syntax mistake.

C.The user does not have permissions to access the table.

D.The network connection timed out.

AnswerB

Repeated SQL syntax errors indicate malformed SQL statements in the query itself, such as misspelled keywords, misplaced commas or unbalanced parentheses. Correcting the query's syntax resolves the refresh failure, since the database rejects unparseable statements before execution.

Why this answer

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.

Exam trap

CompTIA often tests the distinction between error types (syntax vs. runtime vs. connectivity) to see if candidates can map the exact error message to its root cause, rather than guessing based on general troubleshooting assumptions.

How to eliminate wrong answers

Option A is wrong because if the database server were offline, the error would be a connection timeout or 'cannot connect to server' message, not a SQL syntax error. Option C is wrong because a permissions issue would produce an 'access denied' or 'permission denied' error, not a syntax error. Option D is wrong because a network timeout would result in a timeout or connection reset error, not a SQL syntax error.

Practice this question →

23

MCQmedium

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

A.The email field is too long

B.The database connection is lost

C.The customer_id 12345 already exists in the table

D.The name field is null

AnswerC

The load fails because customer_id 12345 already exists, breaching the primary key or unique constraint on that column. The insert is rejected rather than duplicating the row, confirming a uniqueness violation rather than a datatype or connection fault.

Why this answer

The error shown in the exhibit is a duplicate key / unique constraint violation, which occurs when the load script attempts to insert a customer_id value that already exists in the target table. Since customer_id is the primary key (or has a unique constraint), the database rejects the insert with a duplicate entry error. The most likely cause is that customer_id 12345 is already present in the table, so the load must use an upsert, deduplication, or filtered insert strategy.

Exam trap

DA0-002 often tests whether candidates can distinguish between constraint violations (duplicate key, NOT NULL, foreign key) and other error classes like connection loss or data truncation, so the trap is picking a generic 'connection lost' answer instead of reading the specific error code.

How to eliminate wrong answers

Option A is wrong because a field-length overflow produces a 'data too long for column' or truncation error, not a duplicate-key violation. Option B is wrong because a lost database connection raises a connection timeout or 'server has gone away' error, not a constraint violation on a specific row. Option D is wrong because a NULL value in a NOT NULL column raises a 'column cannot be null' error, which is a different constraint class than a duplicate primary key.

Practice this question →

24

MCQmedium

A stakeholder asks for the exact number of customers who churned last month. Which metric should the analyst report?

A.Churn trend

B.Churn rate percentage

C.Count of churned customers

D.Churn probability

AnswerC

The stakeholder requested an exact number, so a discrete count of churned customers answers precisely. Rates or percentages would obscure the absolute figure requested, making the raw count the appropriate metric for this reporting need.

Why this answer

The stakeholder explicitly asks for the 'exact number' of customers who churned, which is a discrete count. Option C, 'Count of churned customers,' directly provides this integer value without any normalization or ratio. The analyst should report the raw metric that matches the request's specificity.

Exam trap

The trap here is that candidates often confuse 'churn rate percentage' (a relative metric) with the 'exact count' (an absolute metric), assuming the stakeholder wants the rate when they explicitly ask for the number.

How to eliminate wrong answers

Option A is wrong because a 'churn trend' shows the direction or pattern over time (e.g., increasing or decreasing), not a single exact number. Option B is wrong because 'churn rate percentage' is a ratio (churned customers divided by total customers), which normalizes the count and does not give the exact number requested. Option D is wrong because 'churn probability' is a predictive model output (e.g., a score between 0 and 1) indicating likelihood of future churn, not a historical count of past churned customers.

Practice this question →

25

MCQeasy

A business user asks a data analyst to include several charts in a weekly report. The user wants to see the trend of sales over the last 12 months at a glance. Which chart type should the analyst use?

A.Line chart

B.Stacked bar chart

C.Treemap

D.Pie chart

AnswerA

A line chart plots the continuous time dimension on the x-axis and sales on the y-axis, connecting points to expose direction and rate of change. This makes the twelve-month trend immediately visible at a glance.

Why this answer

A line chart is the correct choice because it is specifically designed to display trends over continuous time intervals, such as sales over 12 months. The x-axis represents time (months), and the y-axis represents sales values, allowing the user to quickly see upward, downward, or cyclical patterns. This aligns with the requirement to visualize a trend at a glance, which is a core strength of line charts in data visualization.

Exam trap

The trap here is that candidates often confuse a stacked bar chart's ability to show cumulative totals over time with a clear trend line, but the stacked segments actually make it harder to discern the overall sales trajectory at a glance.

How to eliminate wrong answers

Option B (Stacked bar chart) is wrong because it emphasizes part-to-whole relationships across categories over time, not a single trend line; it can obscure the overall sales trend due to stacked segments. Option C (Treemap) is wrong because it uses nested rectangles to show hierarchical proportions, making it unsuitable for time-series trend analysis. Option D (Pie chart) is wrong because it shows proportions of a whole at a single point in time, not changes over a continuous period like 12 months.

Practice this question →

26

MCQeasy

A data analyst needs to communicate findings to a non-technical audience that is concerned with overall performance but not interested in details. Which approach is best?

A.Provide a summary dashboard with key KPIs

B.Include complex model outputs

C.Share raw data tables

D.Use detailed statistical jargon

AnswerA

A summary dashboard with key KPIs matches the non-technical audience's need for overall performance without granular detail. Aggregated visual indicators surface trends immediately, avoiding raw tables or statistical nuance that would obscure the message. This directly satisfies the stem's constraint of communicating findings at an executive level rather than an analytical one.

Why this answer

A summary dashboard with key KPIs is best because it distills complex data into visual, high-level metrics that non-technical stakeholders can quickly grasp. This approach aligns with the principle of data storytelling, where the focus is on actionable insights rather than technical details. Dashboards using tools like Tableau or Power BI allow for interactive filtering without overwhelming the audience.

Exam trap

The trap here is that candidates may overestimate the audience's technical comfort and choose raw data or jargon, forgetting that the question explicitly states the audience is 'non-technical' and 'not interested in details.'

How to eliminate wrong answers

Option B is wrong because complex model outputs (e.g., regression coefficients or decision tree splits) require statistical literacy and obscure the main performance narrative, causing confusion. Option C is wrong because raw data tables present unaggregated, granular information that is difficult to interpret and irrelevant for high-level performance review. Option D is wrong because detailed statistical jargon (e.g., p-values, confidence intervals) alienates non-technical audiences and violates the principle of communicating insights in plain language.

Practice this question →

27

MCQmedium

A data analyst is creating a report to compare the performance of different sales regions. The report will be used by regional managers to identify areas needing improvement. Which of the following visualization techniques would be most effective?

A.A bar chart comparing each region's sales

B.A line chart showing overall company sales

C.A pie chart showing each region's contribution

D.A scatter plot of sales vs. expenses

AnswerA

A bar chart maps each region to a discrete bar, letting managers compare magnitudes across categories at a glance. This directly satisfies the requirement to rank regions and spot underperformance, which continuous or part-to-whole charts would obscure.

Why this answer

A bar chart is most effective because it allows direct, side-by-side comparison of discrete categories (sales regions) using a common baseline, making it easy for regional managers to quickly identify which regions are underperforming. The vertical bars encode exact values with high perceptual accuracy, supporting the report's goal of highlighting areas needing improvement.

Exam trap

The trap here is that candidates often choose a pie chart (Option C) because they think 'contribution to the whole' is the goal, but the question asks for comparing performance across regions, which requires a common baseline — a task for which pie charts are notoriously poor.

How to eliminate wrong answers

Option B is wrong because a line chart is designed to show trends over continuous time intervals, not to compare discrete categories like sales regions; it would obscure regional differences by aggregating data into a single overall trend. Option C is wrong because a pie chart shows parts of a whole, making it difficult to compare individual region performance accurately due to the lack of a common baseline and poor perceptual precision for small differences. Option D is wrong because a scatter plot is used to explore the relationship between two continuous variables (e.g., correlation between sales and expenses), not to compare performance across distinct categories like regions.

Practice this question →

28

Multi-Selecteasy

Which TWO are common pitfalls when communicating data insights?

Select 2 answers

A.Explaining assumptions clearly

B.Using misleading scales on charts

C.Including a clear call to action

D.Providing context for the data

E.Overloading the audience with too many visuals

AnswersB, E

Truncated or non-zero-baseline axes exaggerate small differences, so audiences draw conclusions the underlying data does not support. This satisfies the pitfall constraint because the distortion is introduced by presentation choices rather than the analysis itself, misleading decision-makers.

Why this answer

Option B is correct because using misleading scales on charts—such as truncating the y-axis so it does not start at zero or using inconsistent intervals—distorts the visual representation of data and can lead the audience to draw false conclusions, making it a classic data-communication pitfall. Option E is correct because overloading the audience with too many visuals (chart junk or excessive dashboards) exceeds cognitive capacity, dilutes the key message, and causes the audience to miss the most important insights. By contrast, option A (explaining assumptions clearly) is a best practice that builds trust and transparency, not a pitfall.

Option C (including a clear call to action) is also a best practice because it tells the audience what to do with the insight. Option D (providing context for the data) is likewise a best practice, since context such as baselines, benchmarks, and timeframes is essential for correct interpretation.

Exam trap

CompTIA often tests the distinction between best practices and common pitfalls, so the trap here is that candidates may confuse beneficial actions (like explaining assumptions or providing context) with pitfalls, leading them to select those as wrong answers instead of recognizing them as correct practices.

Practice this question →

29

MCQeasy

A junior data analyst at an e-commerce company wants to query a production customer table that contains email addresses and purchase history. Company policy states that analysts may access only the columns needed for their assigned task and must request elevated access for sensitive fields. Which data governance principle is the policy enforcing?

A.Data sovereignty

B.Data archiving

C.Data redundancy

D.Least privilege

AnswerD

Least privilege means granting users only the minimum access necessary to perform their assigned tasks. Allowing the analyst to query only needed columns and requiring an elevated request for sensitive fields such as email addresses directly implements this principle, making it the correct governance concept in this scenario.

Why this answer

Least privilege restricts access to only what is required for a user's role and task. The policy lets the junior analyst query necessary columns while requiring an elevated request for sensitive fields like email addresses, which is a direct application of that principle. It reduces exposure of personal data without blocking legitimate analytical work.

Exam trap

The trap here is confusing least privilege with data minimization, since both limit data, but least privilege governs user access rights while minimization governs collection and retention.

Practice this question →

30

MCQeasy

A data analyst creates a dashboard for executives to monitor quarterly sales. Which best practice ensures the dashboard is effective?

A.Place the most important metric in the top-left corner with simple charts.

B.Use a dark background with bright colors for contrast.

C.Include raw data tables for detailed analysis.

D.Use as many charts as possible to show all data.

AnswerA

Executives scan dashboards briefly, so placing the primary sales metric top-left follows natural reading order and guarantees immediate visibility. Simple charts reduce cognitive load, letting decision-makers grasp performance without interpretation effort, satisfying the stem's effectiveness requirement.

Why this answer

Placing the most important metric in the top-left corner leverages the natural reading pattern (left-to-right, top-to-bottom) to immediately draw the executive's attention to the key insight. Using simple charts (e.g., bar or line charts) reduces cognitive load, enabling rapid comprehension of quarterly sales trends without distracting details. This aligns with dashboard design principles that prioritize clarity and actionability over data density.

Exam trap

CompTIA often tests the misconception that more data or flashy visuals improve a dashboard, when in fact effective data communication relies on minimalism and strategic placement of the most critical insight.

How to eliminate wrong answers

Option B is wrong because a dark background with bright colors can cause eye strain and reduce readability, especially in well-lit executive meeting rooms; effective dashboards typically use light backgrounds with high-contrast, accessible color schemes. Option C is wrong because including raw data tables in an executive dashboard defeats its purpose—executives need summarized insights, not granular data, which should be available in a separate drill-down report. Option D is wrong because using as many charts as possible leads to clutter and information overload, obscuring the key sales metrics and making the dashboard ineffective for quick decision-making.

Practice this question →

31

MCQhard

An insurer's data governance team discovers that a legacy reporting pipeline transforms policy effective dates using a hard-coded time zone offset that was correct five years ago but is now wrong for a newly acquired business unit. The team must document where the defect originates, which downstream reports are affected, and how to prevent recurrence. Which governance capability is MOST directly suited to this investigation?

A.Data masking, which obfuscates sensitive fields so non-production environments can be used safely

B.Data lineage, which maps source-to-target transformations and downstream dependencies across the pipeline

C.Data retention scheduling, which automates archival and deletion of records past their required lifecycle

D.Data profiling, which statistically summarizes column distributions to detect outliers and anomalies

AnswerB

Lineage documents how data moves and transforms from source systems through each processing step to consuming reports. That lets the team pinpoint the transformation containing the hard-coded offset and enumerate every downstream report and dashboard that inherits the defect, directly supporting both impact assessment and a targeted fix with regression testing.

Why this answer

Lineage is the capability that records transformation logic and dependency chains, making it the right tool to locate the hard-coded offset and trace every downstream report affected by it. Profiling detects value anomalies without explaining logic, masking protects non-production data, and retention manages lifecycle duration. Only lineage ties the defect's origin to its consumers for impact assessment and regression planning.

Exam trap

The trap here is assuming data profiling can identify transformation logic errors, when profiling only surfaces value-level anomalies.

Practice this question →

32

MCQhard

During a presentation, a stakeholder questions the validity of a correlation found. What is the best response?

A.Correlation does not imply causation, but we can perform further analysis.

B.We can accept the correlation as true.

C.We used a large sample so it's valid.

D.The p-value is low, so it's significant.

AnswerA

Acknowledging that correlation does not imply causation addresses the validity challenge honestly, while offering further analysis keeps the investigation open rather than defensive. This satisfies the stakeholder's concern about the correlation's meaning, distinguishing statistical association from causal mechanism without dismissing the finding outright.

Why this answer

It directly addresses the stakeholder's concern about validity by acknowledging the fundamental statistical principle that correlation does not imply causation. It then proposes a constructive next step—further analysis—which aligns with best practices in data communication, where validating insights requires additional testing (e.g., controlled experiments or causal inference methods). This response demonstrates both technical honesty and a commitment to rigorous data-driven decision-making.

Exam trap

The trap here is that candidates often confuse statistical significance (p-value) or sample size with validity of a correlation, overlooking the core principle that correlation does not imply causation, which is a classic pitfall in data interpretation questions.

How to eliminate wrong answers

Option B is wrong because accepting a correlation as true without scrutiny ignores the possibility of spurious correlations, confounding variables, or sampling bias, which undermines data integrity. Option C is wrong because a large sample size reduces sampling error but does not guarantee that a correlation is meaningful or causal; it can still be due to chance or hidden confounders. Option D is wrong because a low p-value indicates statistical significance (i.e., the correlation is unlikely to be due to random chance), but it does not prove practical importance or causation, and significance can be inflated with large samples.

Practice this question →

33

Multi-Selecteasy

A data analyst is designing a dashboard for senior executives who need to quickly monitor key business metrics. Which TWO design principles should the analyst follow? (Choose two.)

Select 2 answers

A.Include detailed data tables for reference

B.Display only the most important KPIs

C.Use consistent formatting and clear labels

D.Add complex interactive filters

E.Use as many colors as possible to make it visually appealing

AnswersB, C

Executives need rapid comprehension, so restricting the dashboard to the most important KPIs reduces cognitive load and directs attention to decision-critical metrics. This satisfies the stem's requirement for quick monitoring by senior executives, since every displayed metric competes for limited attention and dilutes the signal from genuinely vital indicators.

Why this answer

Option B is correct because executive dashboards should surface only the most important KPIs so senior leaders can grasp critical business metrics at a glance without being distracted by secondary data. Option C is correct because consistent formatting and clear labels reduce cognitive load and ensure that executives interpret the displayed KPIs accurately and quickly. Option A is not appropriate because detailed data tables add clutter and slow down high-level decision-making rather than supporting rapid monitoring.

Option D is not appropriate because complex interactive filters increase complexity and require extra effort, which conflicts with the need for quick executive oversight. Option E is not appropriate because using many colors creates visual noise and can obscure meaning instead of improving clarity.

Exam trap

CompTIA often tests the misconception that more data and interactivity always improve a dashboard, when in fact, for executive audiences, simplicity and focus on the most important KPIs are paramount.

Practice this question →

34

MCQmedium

A mid-sized insurance company stores policyholder records in a Microsoft SQL Server database. The compliance team must ensure that any column containing Social Security numbers is masked whenever the data is queried by analysts who are not authorized to view full identifiers. The database administrators want a solution that enforces masking at query time without altering the stored values or requiring application changes. Which SQL Server feature should they implement?

A.Row-Level Security

B.Dynamic Data Masking

C.Always Encrypted

D.Transparent Data Encryption

AnswerB

Dynamic Data Masking applies masking rules at query time based on the user's permissions, so unauthorized analysts see masked values while authorized users see the original data. It does not change stored data or require application changes, which directly satisfies the scenario's requirement to protect Social Security numbers without altering the underlying records.

Why this answer

Dynamic Data Masking is the correct choice because it enforces masking at query time based on user permissions, leaving stored data unchanged and requiring no application modifications. It allows authorized users to see full values while unauthorized users see masked results, which precisely matches the compliance requirement for protecting Social Security numbers in the insurance database.

Exam trap

The trap here is confusing encryption features such as Transparent Data Encryption or Always Encrypted with masking, even though encryption protects data at rest or in use but does not obscure values for authorized queries.

Practice this question →

35

Multi-Selecteasy

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

Select 2 answers

A.Use complex visualizations to impress users.

B.Include as many KPIs as possible on one screen.

C.Use consistent color coding for similar metrics.

D.Place the most important information at the top or left.

E.Use a single chart type for all visuals.

AnswersC, D

Assigning the same colour to equivalent metrics lets the sales team compare values across charts without relearning the legend each time. Consistent colour coding reduces cognitive load and misinterpretation, a core dashboard design principle for recurring operational reporting.

Why this answer

Option C is correct because consistent color coding for similar metrics reduces cognitive load and lets viewers instantly associate a color with a metric's meaning across the dashboard, improving readability and faster interpretation. Option D is correct because placing the most important information at the top or left follows the natural F-pattern/Z-pattern reading flow in left-to-right cultures, ensuring key KPIs are seen first. Option A is wrong because complex visualizations prioritize aesthetics over clarity and can confuse users rather than inform decisions.

Option B is wrong because cramming too many KPIs onto one screen creates clutter and dilutes focus from the metrics that matter most. Option E is wrong because using a single chart type for all visuals ignores data-appropriate visualization choices, such as bars for comparison and lines for trends.

Exam trap

The trap here is that candidates often confuse 'impressive visuals' with effective communication, or assume that more data equals better insights, when in fact simplicity and consistency are the hallmarks of professional dashboard design.

Practice this question →

36

Multi-Selecthard

Which THREE of the following are appropriate ways to handle outliers when communicating data insights?

Select 3 answers

A.Document the outlier and its potential impact in the report.

B.Ignore the outlier and proceed with the analysis.

C.Investigate the cause of the outlier.

D.Use a box plot to visualize the distribution including outliers.

E.Remove the outlier from the dataset to clean the data.

AnswersA, C, D

Documenting an outlier and its potential impact preserves analytical transparency without distorting the underlying distribution, satisfying the requirement to communicate insights honestly. Rather than deleting or capping extreme values, this approach flags them for stakeholders, enabling informed interpretation. It suits reporting scenarios where the outlier may signal genuine business events warranting investigation.

Why this answer

Option A is correct because documenting an outlier and its potential impact preserves transparency and lets stakeholders judge how the anomaly may affect conclusions. Option C is correct because investigating the cause of an outlier determines whether it is a data-entry error, a measurement fault, or a genuine signal that must be retained. Option D is correct because a box plot visualizes the distribution and explicitly displays outliers beyond the whiskers, making them visible rather than hidden.

Option B is not appropriate because silently ignoring an outlier conceals potentially important information and biases the analysis. Option E is not appropriate because automatically removing an outlier without justification can distort the dataset and discard legitimate extreme values.

Exam trap

The trap here is that candidates may think removing outliers is always a standard data cleaning step, but the exam emphasizes that outliers must be investigated and documented rather than automatically deleted, as they can carry significant meaning.

Practice this question →

37

MCQeasy

A payroll analyst receives a spreadsheet of employee compensation and needs to share aggregate salary statistics with an external benchmarking vendor. Which action best aligns with data minimization principles?

A.Encrypt the spreadsheet with a shared password and email the password in a separate message

B.Replace employee names with randomly generated identifiers before sending the file

C.Send only the calculated aggregates, such as median and quartile salaries by job family

D.Redact Social Security numbers and bank account fields, then send the remaining compensation rows

AnswerC

Data minimization means disclosing only the personal data necessary for the stated purpose. Since the vendor needs aggregate salary statistics, providing computed aggregates by job family eliminates exposure of individual compensation records entirely. This satisfies the benchmarking need while removing the risk of re-identification or misuse of row-level payroll data, making it the strongest alignment with the principle.

Why this answer

Data minimization requires that personal data processing and disclosure be limited to what is adequate, relevant, and necessary for the purpose. The benchmarking vendor needs statistics, not records, so computing aggregates by job family removes individual exposure while meeting the business need. Techniques that merely obscure or protect row-level data, such as pseudonyms, encryption, or partial redaction, leave unnecessary personal data in scope.

Exam trap

The trap here is equating any privacy-protective technique, such as encryption or pseudonymization, with data minimization even though the underlying row-level data is still disclosed.

Practice this question →

38

MCQmedium

A retail company's data analyst developed a dashboard for store managers to monitor daily sales performance. The dashboard includes numerous metrics such as sales by hour, product category, employee, and customer demographics, along with trend lines and forecast graphs. Despite the comprehensive data, store managers are ignoring the dashboard because they find it cluttered and confusing. They prefer to rely on their intuition and verbal updates from shift leads. The analyst needs to improve communication of data insights to ensure the dashboard is used effectively. Which of the following actions should the analyst take FIRST?

A.Send the raw data in a spreadsheet instead

B.Simplify the dashboard by focusing on key metrics and using clear visual hierarchy

C.Schedule a training session to explain all metrics

D.Add more data points to provide a comprehensive view

AnswerB

The dashboard fails because excessive metrics create cognitive overload, so managers abandon it. Reducing to key metrics with clear visual hierarchy directly addresses the stated clutter and confusion constraint, making insights scannable and actionable before any deeper redesign or training is attempted.

Why this answer

The core issue is that the dashboard is cluttered and confusing, which directly undermines its usability. Option B addresses this by simplifying the dashboard to focus on key metrics and using a clear visual hierarchy, which is the foundational step in effective data communication. Without first reducing cognitive load, no amount of training or additional data will make the dashboard useful for time-constrained store managers.

Exam trap

The trap here is that candidates may confuse 'comprehensive data' with 'effective communication,' leading them to choose options that add more information (D) or provide raw data (A), rather than recognizing that clarity and focus are the primary drivers of dashboard adoption.

How to eliminate wrong answers

Option A is wrong because sending raw data in a spreadsheet would exacerbate the problem by overwhelming managers with unstructured, granular data, requiring them to perform their own analysis—the opposite of a dashboard's purpose. Option C is wrong because scheduling a training session to explain all metrics assumes the problem is a lack of understanding, not the dashboard's poor design; training a user to navigate a cluttered interface is inefficient and does not fix the root cause. Option D is wrong because adding more data points would increase clutter and confusion, directly contradicting the user feedback that the dashboard is already too complex.

Practice this question →

39

Multi-Selecthard

A data analyst at a healthcare insurer is building a new analytics dataset that combines claims data with member demographic data. The compliance team requires the analyst to apply data governance controls that support accountability and traceability. Which TWO actions best satisfy this requirement? (Choose two.)

Select 2 answers

A.Document the source systems, transformation logic, and refresh schedule for each field in the dataset.

B.Convert all numeric claim amounts to a different currency to standardize reporting across regions.

C.Increase the storage capacity of the data warehouse to accommodate future growth of the combined dataset.

D.Schedule a weekly full backup of the analytics database to a secondary data center.

E.Assign a named data steward who is responsible for approving access requests and resolving data quality issues.

AnswersA, E

Documenting source systems, transformations, and refresh schedules creates data lineage, which is a core governance control for traceability. It allows auditors and data stewards to trace any value back to its origin and understand how it was changed, directly supporting accountability for the combined claims and demographic dataset.

Why this answer

Accountability and traceability in data governance are achieved through documented lineage and clearly assigned ownership. Recording source systems, transformation logic, and refresh schedules provides traceability, while naming a data steward who approves access and resolves quality issues provides accountability. Together these two actions directly satisfy the compliance team's requirement.

Exam trap

The trap here is selecting operational or infrastructure tasks such as backups or storage expansion, which feel responsible but do not create governance accountability or traceability.

Practice this question →

40

MCQmedium

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?

A.Apply progressive disclosure

B.Increase white space

C.Use a single chart type

D.Add more filters

AnswerA

Progressive disclosure initially presents only high-level metrics, revealing detail on demand, which directly resolves the stem's complaint of too many metrics crowding one screen. It reduces cognitive load while preserving access to deeper data, unlike simply removing metrics.

Why this answer

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.

Exam trap

The trap here is that candidates often confuse 'reducing clutter' (white space) with 'reducing information overload' (progressive disclosure), or they mistakenly believe that adding more filters will simplify the initial view, when in fact filters only change what is shown without addressing the core issue of too many metrics displayed at once.

How to eliminate wrong answers

Option B is wrong because increasing white space improves visual clarity and reduces clutter, but it does not solve the problem of too many metrics being displayed simultaneously; it merely spaces them out. Option C is wrong because using a single chart type does not reduce the number of metrics shown; it may even force inappropriate visualization of diverse data types, leading to misinterpretation. Option D is wrong because adding more filters gives users control over what data is displayed, but it does not address the initial overload of visible metrics; filters are a complementary feature, not a primary solution for reducing on-screen complexity.

Practice this question →

41

MCQmedium

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?

A.Scatter plot

B.Line chart

C.Bar chart

D.Heatmap

AnswerC

A bar chart encodes each region's sales as a separate bar on a common axis, so executives can compare magnitudes at a glance without interpreting scales or trends. Position and length are the most accurately judged visual encodings, making categorical comparison across regions immediate and unambiguous.

Why this answer

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.

Exam trap

The trap here is that candidates often choose a line chart (Option B) because they associate sales data with time series, but the question specifies a single quarter comparison across regions, not a trend over time.

How to eliminate wrong answers

Option A is wrong because a scatter plot is designed to show the relationship or correlation between two continuous variables, not to compare discrete categories like regions; it would confuse a non-technical audience with unnecessary data point dispersion. Option B is wrong because a line chart is best for showing trends over time, but the question asks for a comparison across regions for a single time period (current quarter), making the line chart misleading as it implies a temporal sequence. Option D is wrong because a heatmap uses color intensity to represent values in a matrix, which is effective for spotting patterns in large datasets but is less intuitive for direct, side-by-side comparisons of a single metric across a small number of categories.

Practice this question →

42

MCQmedium

A data team is creating a dashboard to monitor real-time sales. What design principle is critical?

A.Provide downloadable raw data

B.Use auto-refresh and clear alert thresholds

C.Include all historical data

D.Minimize use of color

AnswerB

Auto-refresh keeps the dashboard current without manual intervention, satisfying the real-time monitoring requirement, while clear alert thresholds convert raw sales figures into actionable signals. Together they ensure the team detects anomalies promptly rather than reviewing stale data, which is the critical design principle for a real-time sales dashboard.

Why this answer

For a real-time sales dashboard, the critical design principle is to ensure data freshness and immediate actionability. Option B is correct because auto-refresh keeps the dashboard current without manual intervention, and clear alert thresholds enable the team to instantly identify when sales metrics deviate from expected ranges, which is essential for real-time monitoring.

Exam trap

The trap here is that candidates often confuse general dashboard design principles (like minimizing color or providing raw data) with the specific, non-negotiable requirements of a real-time monitoring system, where data freshness and alerting are paramount.

How to eliminate wrong answers

Option A is wrong because providing downloadable raw data is a feature for offline analysis or auditing, not a critical principle for real-time monitoring; it can even introduce latency and security risks. Option C is wrong because including all historical data would overwhelm the dashboard's performance and cognitive load, contradicting the need for real-time, focused insights. Option D is wrong because minimizing color use is a general design best practice for accessibility, but it is not the critical principle for a real-time dashboard; color can be effectively used to highlight alerts and thresholds.

Practice this question →

43

Multi-Selecthard

A financial services firm is establishing a data governance program for its customer analytics platform. The chief data officer wants to ensure that data quality issues are detected and resolved systematically. Which two of the following practices are most appropriate for maintaining data quality on an ongoing basis? (Choose two.)

Select 2 answers

A.Establishing a data quality issue log with defined severity levels, owners, and service-level agreements for resolution.

B.Encrypting all customer data at rest and in transit to prevent unauthorized access.

C.Implementing automated data quality rules that validate completeness, uniqueness, and referential integrity during ETL loads.

D.Assigning a data steward to manually review a random sample of records each quarter and document findings in a spreadsheet.

E.Relying on business users to report data errors through ad hoc emails to the IT help desk.

AnswersA, C

A formal issue log with severity levels, assigned owners, and SLAs ensures that detected quality problems are tracked, prioritized, and resolved within agreed timeframes. This creates accountability and a repeatable process, which is a core component of an ongoing data governance program for customer analytics.

Why this answer

Automated data quality rules during ETL and a formal issue log with severity levels and SLAs together provide a systematic, repeatable approach to detecting and resolving data quality problems. The automated rules catch issues early, while the issue log ensures accountability and timely resolution, which are essential for an ongoing governance program in financial services.

Exam trap

The trap here is selecting manual sampling or ad hoc reporting as quality practices, when they are reactive and not systematic enough for ongoing governance.

Practice this question →

44

MCQmedium

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?

A.Use a single aggregated metric to simplify.

B.Increase the refresh rate to every hour.

C.Incorporate conditional formatting with color alerts.

D.Add more detailed charts to each KPI.

AnswerC

Conditional formatting applies rule-based colour coding directly to KPI values, so executives spot threshold breaches without reading every figure. This satisfies the stem's constraint of quickly identifying critical issues, since colour draws attention pre-attentively. Static daily updates remain unchanged; only the visual encoding of exceptions is added.

Why this answer

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.

Exam trap

The trap here is that candidates may confuse 'increasing data freshness' (Option B) with 'improving data interpretability,' when in fact the core issue is about visual salience and rapid issue detection, not data latency.

How to eliminate wrong answers

Option A is wrong because using a single aggregated metric oversimplifies the data and hides the specific KPIs that executives need to monitor, potentially masking critical issues in individual metrics. Option B is wrong because increasing the refresh rate to every hour does not help executives quickly identify critical issues; it only updates data more frequently, which could even cause confusion if alerts are not visually highlighted. Option D is wrong because adding more detailed charts to each KPI increases visual clutter and cognitive load, making it harder for executives to quickly spot the most critical issues, contrary to the goal of rapid identification.

Practice this question →

45

Multi-Selectmedium

A data governance council at an insurance company is establishing a data stewardship program. The council wants to define the core responsibilities that data stewards will own within their assigned domains. Which two responsibilities are most appropriate for data stewards? (Choose two.)

Select 2 answers

A.Negotiating vendor contracts for third-party data purchases

B.Approving the enterprise-wide data governance budget

C.Defining and maintaining data quality rules and standards for their domain

D.Resolving data quality issues and documenting root causes within their domain

E.Building the physical ETL pipelines that load data into the warehouse

AnswersC, D

Data stewards are accountable for the fitness of data in their domains, which includes authoring quality rules such as validity ranges, completeness thresholds, and referential integrity checks. They translate business expectations into measurable criteria and monitor adherence. This custodial responsibility directly supports the council's goal of embedding accountability for data health across domains.

Why this answer

Data stewards own the health of data in their domains, which centers on defining quality rules and standards and resolving quality issues with documented root causes. Budget approval, pipeline engineering, and vendor contracting are responsibilities of executives, engineers, and procurement respectively. Keeping stewards focused on quality definition and remediation preserves clear accountability within the governance model.

Exam trap

The trap here is expanding the steward role into technical or commercial territory, when stewardship centers on defining and defending data quality within a domain.

Practice this question →

46

Multi-Selectmedium

Which TWO are best practices for data storytelling?

Select 2 answers

A.Start with the conclusion

B.Use complex jargon to show expertise

C.Tailor the story to the audience

D.Use a single visualization to avoid confusion

E.Include all data points for completeness

AnswersA, C

Beginning with the conclusion respects the audience's limited attention, delivering the key insight before supporting detail. This satisfies the stem's storytelling best-practise requirement by structuring the narrative around the decision the data must inform, rather than chronological analysis order, which buries the actionable message.

Why this answer

Option A (Start with the conclusion) is correct because effective data storytelling follows the inverted-pyramid principle: leading with the key insight or recommendation ensures the audience immediately grasps the 'so what' before diving into supporting evidence, which is especially critical for time-constrained executive stakeholders. Option C (Tailor the story to the audience) is correct because the same data must be framed differently depending on the audience's technical depth, role, and decision-making needs — for example, executives need business impact and KPIs, while analysts need methodology and granular metrics — so audience adaptation is a core best practice. Option B is incorrect because complex jargon obscures meaning and alienates non-specialist stakeholders rather than demonstrating genuine expertise.

Option D is incorrect because relying on a single visualization can oversimplify or hide important patterns; best practice is to use multiple complementary charts that each serve a specific narrative purpose. Option E is incorrect because including every data point creates cognitive overload and dilutes the message — storytellers should curate only the data that supports the narrative.

Exam trap

CompTIA often tests the misconception that data storytelling should prioritize completeness or technical complexity over audience comprehension, leading candidates to select options like 'include all data points' or 'use complex jargon' instead of focusing on clarity and narrative flow.

Practice this question →

47

Multi-Selectmedium

An analyst is presenting findings to stakeholders. Which TWO techniques effectively communicate uncertainty in data? (Choose TWO.)

Select 2 answers

A.Include confidence intervals.

B.Use only point estimates.

C.Use error bars on charts.

D.Remove all outliers from the data.

E.State exact numbers without ranges.

AnswersA, C

Confidence intervals quantify the range within which a population parameter likely falls, directly satisfying the need to communicate statistical uncertainty to stakeholders. Unlike point estimates, they expose sampling variability and precision, letting decision-makers judge reliability rather than assuming false certainty from a single figure.

Why this answer

Confidence intervals (option A) are the standard statistical technique for expressing uncertainty around an estimate, giving stakeholders a range of plausible values at a stated confidence level (e.g., 95%), which directly communicates the precision of the finding. Error bars on charts (option C) visually convey uncertainty—such as standard deviation, standard error, or confidence intervals—around plotted data points, making variability and reliability immediately apparent to a non-technical audience. Together these techniques quantify and visualize uncertainty rather than hiding it.

In contrast, using only point estimates (B) and stating exact numbers without ranges (E) falsely imply perfect precision and conceal variability, while removing all outliers (D) is a data-cleaning decision that can bias results and does not communicate uncertainty at all.

Exam trap

CompTIA often tests the distinction between measures of central tendency (point estimates) and measures of variability (confidence intervals, error bars), trapping candidates who think stating exact numbers or removing outliers is a valid way to handle uncertainty.

Practice this question →

48

MCQeasy

A data analyst at a marketing firm is creating a weekly performance report for the marketing team. The report includes metrics like click-through rates, conversion rates, and cost per acquisition. The team prefers a quick overview of the week's performance to identify trends and make decisions in their Monday morning meeting. The meeting is only 30 minutes, and the team has limited time to review data. The analyst wants to provide a report that is concise and actionable. What format should the analyst use?

A.A one-page executive summary with key metrics highlighted.

B.A live dashboard with interactive filters.

C.A detailed spreadsheet with all data.

D.A 20-slide presentation.

AnswerA

A one-page executive summary surfaces click-through, conversion and cost-per-acquisition figures with highlights, letting the team absorb performance in minutes. This satisfies the stem's 30-minute Monday meeting constraint by being concise and actionable rather than a detailed multi-page report.

Why this answer

A one-page executive summary with key metrics highlighted provides the marketing team with a concise, actionable overview that can be quickly reviewed in a 30-minute meeting. This format aligns with the requirement for a quick overview to identify trends and make decisions without overwhelming the team with excessive detail or requiring interactive exploration.

Exam trap

The trap here is that candidates often confuse 'interactive' with 'efficient,' choosing a live dashboard (Option B) because it seems modern and flexible, but they overlook the specific constraint of a 30-minute meeting where pre-digested, static summaries are more actionable than tools requiring active exploration.

How to eliminate wrong answers

Option B is wrong because a live dashboard with interactive filters, while powerful for ad-hoc analysis, requires time to explore and manipulate, which is not suitable for a quick 30-minute meeting where the team needs a pre-digested overview. Option C is wrong because a detailed spreadsheet with all data presents raw, unsummarized information that would take too long to parse and interpret, defeating the goal of conciseness and quick trend identification. Option D is wrong because a 20-slide presentation is too lengthy and detailed for a 30-minute meeting, likely leading to information overload and insufficient time for discussion and decision-making.

Practice this question →

49

Multi-Selectmedium

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

Select 3 answers

A.The level of confidence or statistical significance.

B.The source code of the analysis scripts.

C.All raw data used in the analysis.

D.A clear recommendation based on the insight.

E.An estimate of the potential business impact.

AnswersA, D, E

Confidence helps stakeholders assess reliability.

Why this answer

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.

Exam trap

CompTIA often tests the distinction between technical artifacts (like source code or raw data) and actionable business insights, so candidates mistakenly include all supporting materials instead of focusing on elements that directly drive decision-making.

Practice this question →

50

MCQhard

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?

A.Anonymize the data before inclusion

B.Flag the data for review

C.Exclude the data because it exceeds the retention period

D.Include the data since it is valuable for analysis

AnswerC

The retention policy caps how long customer transaction data may be kept, and six-year-old records exceed that limit. Excluding them complies with the stated retention period, avoiding the regulatory and privacy breach that retaining or reporting expired personal data would create.

Why this answer

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.

Exam trap

The trap here is that candidates may assume data can be retained or modified (e.g., anonymized) if it is valuable for analysis, but the policy strictly prohibits using data beyond its retention period, regardless of its potential value or transformation.

How to eliminate wrong answers

Option A is wrong because anonymizing the data does not address the policy violation; the data has already exceeded the retention period and should not be used at all, regardless of anonymization. Option B is wrong because flagging the data for review implies it might still be used after evaluation, but the policy is clear that data beyond the retention period must be excluded, not reviewed for potential inclusion. Option D is wrong because including the data for its analytical value directly violates the retention policy, which prioritizes compliance over data utility.

Practice this question →

51

Multi-Selecthard

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.)

Select 3 answers

A.Only the most optimistic scenario.

B.The raw data used for the forecast.

C.The confidence intervals around the forecast.

D.The assumptions made in the forecast model.

E.A discussion of potential risks and uncertainties.

AnswersC, D, E

Confidence intervals quantify the uncertainty around the forecast, directly satisfying the need for clarity about prediction reliability. Stakeholders can judge the plausible range of sales outcomes rather than treating a single point estimate as certain, which builds trust through honest disclosure of model precision and variability.

Why this answer

Option C is correct because confidence intervals quantify the range within which the true forecast value is likely to fall, giving stakeholders an honest measure of the forecast's precision rather than a single misleading point estimate. Option D is correct because stating the assumptions made in the forecast model (e.g., growth rates, seasonality, market conditions) lets stakeholders judge whether those premises match reality and understand how the results were derived. Option E is correct because discussing potential risks and uncertainties prepares stakeholders for scenarios where the forecast may not hold, which builds credibility and supports better contingency planning.

Option A does not belong because presenting only the most optimistic scenario hides downside risk and biases decisions, undermining trust. Option B does not belong because dumping raw data on stakeholders adds noise without interpretation; the analyst should present summarized, relevant evidence instead of the full raw dataset.

Exam trap

CompTIA often tests the distinction between transparency and information overload, so the trap here is that candidates think sharing raw data (Option B) is always good practice, but in stakeholder communication, raw data without context or summary statistics can confuse rather than clarify.

Practice this question →

52

MCQhard

A data analyst is preparing a presentation on customer churn. The audience consists of both technical and non-technical stakeholders. Which visualization approach is most effective?

A.A box plot showing distribution of churn.

B.A heatmap showing correlation of churn factors.

C.A simple bar chart showing churn rate by segment.

D.A scatter plot with multiple variables.

AnswerC

A simple bar chart encodes churn rate by segment using length, which both technical and non-technical stakeholders can read without statistical training. This satisfies the stem's mixed-audience constraint, since it avoids model internals while still conveying the segment-level comparison the presentation requires.

Why this answer

A simple bar chart showing churn rate by segment is most effective because it directly communicates the key metric (churn rate) across categorical segments (e.g., customer demographics or plan types) in a format that is immediately understandable to both technical and non-technical stakeholders. Bar charts excel at comparing discrete categories without requiring statistical literacy, making them ideal for mixed audiences in a presentation context.

Exam trap

The trap here is that candidates often choose complex visualizations like heatmaps or scatter plots to appear 'data-savvy', forgetting that the primary goal is clear communication to a mixed audience, not technical sophistication.

How to eliminate wrong answers

Option A is wrong because a box plot, while useful for showing distribution and outliers, requires understanding of quartiles and median, which is not intuitive for non-technical stakeholders and does not directly highlight churn rate by segment. Option B is wrong because a heatmap showing correlation of churn factors is a multivariate tool that implies a level of statistical understanding (e.g., interpreting correlation coefficients) that non-technical audiences typically lack, and it does not present churn rate in a straightforward, actionable manner. Option D is wrong because a scatter plot with multiple variables is designed to reveal relationships between continuous variables and can become cluttered or confusing when used for categorical comparisons, making it unsuitable for a mixed audience that needs clear, digestible insights.

Practice this question →

53

MCQeasy

A marketing analyst wants to append a purchased third-party demographic file to the company's customer records. The vendor's contract states the data may be used for internal analytics but not redistributed. Which data governance concept governs how the analyst may lawfully use this dataset?

A.Data use agreement, which defines permitted purposes, restrictions, and obligations for the licensed dataset

B.Data classification, which labels the dataset as confidential based on sensitivity

C.Data quality rule, which validates that the purchased records meet accuracy thresholds

D.Data retention policy, which specifies how long the records may be stored before deletion

AnswerA

A data use agreement is the contractual instrument that spells out allowable purposes, prohibitions such as redistribution, and the obligations of the receiving party. Because the vendor explicitly limits use to internal analytics and forbids redistribution, the analyst must consult the data use agreement to confirm the append is permitted and to understand downstream sharing limits.

Why this answer

Licensing and permitted-use questions are governed by data use agreements, which articulate allowable purposes, redistribution prohibitions, and the receiving party's obligations. Classification handles sensitivity, retention handles lifecycle duration, and quality rules handle fitness of values. Only the data use agreement speaks directly to whether the purchased demographic data may be appended and how resulting outputs may be shared.

Exam trap

The trap here is conflating data classification with contractual usage rights, when sensitivity labels do not define permitted purposes.

Practice this question →

54

MCQmedium

A multinational retailer stores customer records in a cloud data warehouse. The governance council must classify each attribute by its sensitivity so downstream masking rules can be applied automatically. The privacy officer asks which classification label should be applied to a field containing government-issued identification numbers that, if exposed, would create legal liability and identity-theft risk.

A.Restricted

B.Confidential

C.Internal

D.Public

AnswerA

Restricted classification is reserved for the most sensitive data, where exposure causes severe legal, financial, or personal harm. Government-issued identifiers fall into this tier because their disclosure enables identity theft and triggers mandatory breach notification. Labeling the field Restricted ensures the data warehouse enforces the strongest access controls and masking rules automatically for every downstream consumer.

Why this answer

Government-issued identification numbers create severe personal and legal harm when exposed, which places them in the highest sensitivity tier. The governance council must map each attribute to the tier whose definition matches that worst-case impact so the data warehouse can enforce masking and access rules automatically. Restricted classification drives those strongest controls for every downstream consumer.

Exam trap

The trap here is assuming any non-public label is sufficient, when the classification tier must reflect the severity of harm rather than merely being internal or confidential.

Practice this question →

55

MCQmedium

Refer to the exhibit. An analyst runs a query to count orders in June 2023 and gets 12,345. However, a dashboard shows 12,298 for the same month. What is the most likely cause?

A.The dashboard includes time zone conversion

B.The query has a syntax error

C.The query excludes orders that were canceled

D.The dashboard is using a different data source

AnswerA

Time zone conversion shifts order timestamps across month boundaries, moving some June orders into May or July depending on the offset applied. This reclassification explains why the dashboard total differs from the raw query count.

Why this answer

The most likely cause is that the dashboard applies a time zone conversion to the order timestamps, while the analyst's query counts orders based on UTC or a different time zone. If the dashboard converts timestamps to a local time zone (e.g., US/Eastern), orders placed near midnight UTC may fall into a different calendar day or month, causing a discrepancy of 47 orders. This is a common issue when raw data is stored in UTC but reporting tools apply a time zone offset without adjusting the query logic.

Exam trap

CompTIA often tests the concept that time zone conversion can cause subtle count discrepancies in reporting, and the trap here is that candidates assume the dashboard is always correct or that the query must have an error, rather than recognizing that both can be technically correct but apply different time zone interpretations.

How to eliminate wrong answers

Option B is wrong because a syntax error would typically cause the query to fail entirely or return an error, not produce a valid count of 12,345 that differs from the dashboard. Option C is wrong because excluding canceled orders would reduce the count, but the query returned a higher number (12,345) than the dashboard (12,298), so the query includes more orders, not fewer. Option D is wrong because using a different data source would likely produce a fundamentally different dataset, not a small, consistent offset of 47 orders; the close proximity of the counts suggests the same underlying data with a transformation difference.

Practice this question →

56

Matchingmedium

Match each ETL process step to its description.

Drag a concept onto its matching description — or click a concept then click the description.

Concepts

Matches

Retrieve data from source systems

Clean, format, and apply business rules

Insert processed data into target system

Analyze source data to understand structure

Correct or remove inaccurate records

Why these pairings

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.

Practice this question →

57

MCQmedium

A regional bank's analytics team maintains a data catalog. A new analyst needs to know which column in the 'loan_applications' table stores the customer's country of residence, what values are permitted, and who owns the table. Which data governance artifact should the analyst consult FIRST to obtain all three pieces of information?

A.The enterprise data dictionary, because it defines each field's business meaning and permissible values

B.The data lineage diagram, because it traces the column's origin and downstream transformations

C.The business glossary, because it lists approved acronyms and metric formulas used across the bank

D.The data catalog, because it combines technical metadata, business definitions, permitted values, and ownership in one searchable inventory

AnswerD

A data catalog is the central inventory that consolidates technical metadata, business definitions, value constraints, and stewardship or ownership assignments for each asset. Searching the 'loan_applications' entry surfaces the column meaning, allowed values, and the accountable owner together, which is exactly the consolidated view this new analyst requires.

Why this answer

A data catalog aggregates metadata from multiple governance artifacts into a single searchable inventory, so it can answer definitional, value-domain, and ownership questions in one place. A data dictionary alone lacks ownership, a business glossary lacks column-level value constraints, and lineage addresses flow rather than meaning. The catalog is the artifact designed to unify these perspectives.

Exam trap

The trap here is assuming a business glossary contains column-level value constraints and table ownership, when it only defines business terminology.

Practice this question →

58

MCQhard

A healthcare data analyst is presenting findings on patient readmission rates to a group of hospital administrators. The analysis reveals a 15% increase in readmissions over the past quarter for patients aged 65+ from a specific zip code. However, the administrators are skeptical because previous quarterly reports showed no such trend, and they suspect data quality issues. The analyst must communicate this insight effectively while maintaining credibility. Which of the following approaches should the analyst take?

A.Emphasize the statistical significance of the finding and ignore previous reports

B.Present the data without any explanation and let them draw conclusions

C.Remove the demographic detail to avoid controversy

D.Acknowledge the discrepancy and explain possible reasons such as changes in data collection methods or patient population

AnswerD

This approach maintains trust and provides context, making the insight more believable.

Why this answer

It demonstrates the core competency of 'Communicating Data Insights' by acknowledging the discrepancy between the current finding and previous reports, which builds trust with skeptical stakeholders. By explaining possible reasons such as changes in data collection methods or patient population, the analyst maintains credibility and invites collaborative investigation into data quality issues, rather than dismissing concerns or hiding details.

Exam trap

The trap here is that candidates may choose Option A, thinking statistical significance alone validates the finding, but the DA0-001 exam emphasizes that effective communication requires acknowledging and addressing stakeholder concerns about data quality, not just presenting numbers.

How to eliminate wrong answers

Option A is wrong because ignoring previous reports undermines credibility and fails to address the administrators' legitimate skepticism about data quality; statistical significance does not automatically validate data integrity. Option B is wrong because presenting data without explanation shifts the burden of interpretation to the audience, which can lead to misinterpretation and erodes trust, especially when stakeholders have already flagged potential issues. Option C is wrong because removing demographic detail to avoid controversy is unethical and violates the principle of transparency in data communication; it also prevents the administrators from understanding the full context of the readmission trend.

Practice this question →

59

MCQmedium

A data analyst needs to communicate a forecast with uncertainty. Which visualization is best?

A.Stacked bar chart

B.Pie chart

C.Line chart with confidence intervals

D.Histogram

AnswerC

A line chart with confidence intervals displays the forecast trajectory while explicitly shading the uncertainty range around each estimate, directly satisfying the requirement to communicate uncertainty. Unlike a plain line chart, which implies false precision, the interval band conveys the plausible upper and lower bounds at each time point.

Why this answer

A line chart with confidence intervals is the best choice because it explicitly visualizes the forecast trend over time while also displaying the range of uncertainty (e.g., 95% confidence bands). This allows the data analyst to communicate both the central projection and the variability around it, which is essential for informed decision-making.

Exam trap

The trap here is that candidates may confuse a histogram (which shows data distribution) with a line chart that includes uncertainty bands, or they may think a pie chart can somehow represent forecast uncertainty through slices.

How to eliminate wrong answers

Option A is wrong because a stacked bar chart is designed to show part-to-whole relationships across categories, not time-series forecasts with uncertainty. Option B is wrong because a pie chart represents proportions of a whole at a single point in time and cannot convey temporal trends or confidence intervals. Option D is wrong because a histogram displays the distribution of a single variable's frequency, not a forecast over time with uncertainty bands.

Practice this question →

60

MCQeasy

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

A.Avoid using any colors.

B.Combine color with patterns or labels.

C.Rely solely on color to convey information.

D.Use only shades of green and red.

AnswerB

Combining colour with patterns or labels adds a second, non-colour channel that encodes the same distinction, so colourblind users can still differentiate categories when hue perception fails. This directly satisfies the stem's accessibility constraint, unlike palettes relying on colour alone.

Why this answer

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.

Exam trap

The trap here is that candidates may think avoiding color entirely (Option A) is the safest approach, but CompTIA often tests the nuance that accessibility is about inclusive design—combining color with other cues—not eliminating color altogether.

How to eliminate wrong answers

Option A is wrong because avoiding any colors entirely removes a valuable data encoding dimension and can reduce clarity for non-colorblind users; accessibility best practices encourage inclusive design, not elimination of color. Option C is wrong because relying solely on color to convey information violates WCAG 1.4.1 (Use of Color), which requires that color is not the only means of conveying information, as this excludes users with color vision deficiencies. Option D is wrong because using only shades of green and red is particularly problematic for the most common form of colorblindness (deuteranopia and protanopia), where red and green appear similar; this choice directly contradicts accessibility guidelines.

Practice this question →

61

MCQeasy

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

A.Stacked bar chart

B.Scatter plot

C.Line chart

D.Pie chart

AnswerC

A line chart plots continuous data points connected by lines, making it ideal for showing trends over time. Monthly sales across twelve months form a sequential time series, so the line's slope directly reveals growth or decline. This satisfies the stem's requirement to display monthly sales trends over the past year.

Why this answer

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.

Exam trap

The trap here is that candidates often confuse 'showing trends over time' with 'comparing parts of a whole' and incorrectly select a stacked bar chart or pie chart, failing to recognize that line charts are the standard for time-series trend visualization.

How to eliminate wrong answers

Option A is wrong because a stacked bar chart is designed to show the composition of parts relative to a whole across categories, not to emphasize a single continuous trend over time; it would obscure the month-over-month sales trajectory. Option B is wrong because a scatter plot is used to display the relationship between two numerical variables (e.g., correlation), not to visualize a single variable's progression over a sequential time period. Option D is wrong because a pie chart is meant to show proportions of a whole at a single point in time, making it unsuitable for depicting trends or changes across multiple time periods.

Practice this question →

62

Multi-Selecteasy

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.)

Select 2 answers

A.Use only text-heavy slides to include all details.

B.Provide a detailed appendix for technical staff.

C.Avoid any data visualizations to prevent confusion.

D.Use complex statistical terms without explanation.

E.Start with a high-level summary for executives.

AnswersB, E

An appendix lets the main narrative stay executive-focused while preserving depth for technical readers, satisfying the mixed-audience constraint without diluting either group's needs. It separates detail by audience rather than forcing one register on everyone, so executives retain the headline findings and technical staff can verify methodology, assumptions and data lineage at their own pace.

Why this answer

Option B is correct because a detailed appendix lets the analyst include the full technical depth—methodology, data sources, statistical tests, and assumptions—that technical staff need, without cluttering the main presentation for executives. Option E is correct because opening with a high-level summary (key findings, business impact, and recommendations) gives executives the decision-relevant context first, following the inverted-pyramid approach to audience-tailored communication. Option A is wrong because text-heavy slides overload both audiences and obscure key messages; effective presentations use concise bullets and visuals.

Option C is wrong because data visualizations (charts, dashboards) aid comprehension rather than cause confusion when designed well. Option D is wrong because unexplained complex statistical terms alienate the non-technical executives and undermine the presentation's purpose.

Exam trap

The trap here is that candidates often select 'Use only text-heavy slides' (A) thinking it ensures completeness, but the exam tests the ability to tailor communication to mixed audiences, where conciseness and visual aids are prioritized over exhaustive detail.

Practice this question →

63

Multi-Selecteasy

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

Select 2 answers

A.Use clear and descriptive axis labels.

B.Avoid using technical jargon in titles and annotations.

C.Use only one chart type throughout the report.

D.Include interactive elements like drill-downs for all charts.

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

AnswersA, B

Clear labels help all audiences understand the visualization.

Why this answer

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.

Exam trap

The trap here is that candidates often assume technical sophistication (like interactivity or chart variety) always improves communication, but the DA0-001 exam emphasizes that simplicity and clarity are more important for a diverse audience with varying data literacy.

Practice this question →

64

MCQeasy

A hospital's data governance committee is drafting a policy that defines who may access patient diagnosis records, how long those records must be retained, and the process for requesting exceptions. Which governance artifact is the committee creating?

A.A data quality scorecard

B.A data dictionary

C.A data policy

D.A data lineage diagram

AnswerC

A data policy is a formal statement of rules governing data access, retention, and exception handling. It codifies the committee's decisions about who can view diagnosis records, how long they persist, and how deviations are approved. This artifact provides the authoritative framework that procedures and controls then implement across the organization.

Why this answer

The committee is defining rules about access, retention, and exceptions, which are the substance of a data policy. Policies articulate what is required and who is accountable, while supporting artifacts like dictionaries, lineage diagrams, and scorecards describe data structure, movement, or quality. Only a policy establishes the binding governance framework the committee is drafting.

Exam trap

The trap here is confusing documentation artifacts that describe data with governance artifacts that prescribe rules, leading to choosing a dictionary or lineage diagram.

Practice this question →

65

MCQhard

A financial services firm maintains a data catalog for its analytics platform. The governance team is defining the roles and responsibilities for a new data stewardship program. The chief data officer wants a single accountable person for each critical data domain, such as customer or transaction data, who approves definitions, resolves quality issues, and enforces policy. Which role should be assigned this accountability?

A.Data steward

B.Data owner

C.Data analyst

D.Data custodian

AnswerB

The data owner is the accountable business leader for a data domain, with authority to approve definitions, set policy, and resolve quality disputes. This role matches the chief data officer's requirement for a single accountable person per domain, because ownership carries decision rights rather than only operational or advisory duties. Owners delegate implementation to custodians and documentation to stewards.

Why this answer

Accountability for a data domain belongs to the data owner, a business leader empowered to approve definitions, set policy, and settle quality disputes. Custodians implement controls, stewards perform daily governance tasks, and analysts consume data, but none of those roles carries binding decision rights. The chief data officer needs one accountable owner per domain to make governance enforceable.

Exam trap

The trap here is confusing the steward who does the daily governance work with the owner who is accountable and holds final decision rights.

Practice this question →

66

MCQmedium

A data analyst receives a complaint that a dashboard shows a customer's city as 'New York' while the source CRM shows 'NYC'. The analyst traces the issue to a transformation that maps state abbreviations but does not standardize city names. Which data quality dimension is most directly affected by this inconsistency?

A.Consistency

B.Timeliness

C.Accuracy

D.Completeness

AnswerA

Consistency means the same data is represented uniformly across systems and reports. The CRM showing 'NYC' while the dashboard shows 'New York' is a direct violation of consistency, caused by the transformation not standardizing city values. This dimension best describes the mismatch the analyst is investigating.

Why this answer

Consistency requires that the same entity be represented the same way across systems. Because the transformation standardizes state abbreviations but leaves city names unstandardized, the CRM and dashboard disagree on the same customer's city. That mismatch is a consistency defect, even though both values technically refer to the same place.

Exam trap

The trap here is choosing accuracy because the values look different, but both values are factually correct; the real defect is that they are not represented consistently across systems.

Practice this question →

67

MCQhard

A multinational corporation is implementing a data governance program. The Chief Data Officer wants to ensure that data quality issues are detected and resolved promptly across all business units. Which combination of roles and responsibilities is most appropriate for this goal?

A.Outsource data quality monitoring to a third-party vendor to gain external expertise.

B.Centralize all data quality responsibilities within the IT department to ensure consistent technical standards.

C.Require each business unit to manage data quality independently without central oversight.

D.Assign data stewards in each business unit to monitor quality metrics and escalate issues to a central data governance council.

AnswerD

Data stewards are responsible for day-to-day data quality management within their domains. They monitor metrics, resolve issues, and escalate when necessary. A central council provides oversight and cross-functional coordination. This federated model balances local accountability with enterprise-wide consistency, which is essential for a multinational corporation.

Why this answer

A federated data governance model with data stewards embedded in business units and a central council for oversight is widely recognized as effective. Stewards handle domain-specific quality issues, while the council sets standards and resolves cross-functional conflicts. This structure ensures both local responsiveness and enterprise alignment, which is critical for a multinational corporation with diverse business units.

Exam trap

The trap here is assuming that centralizing all data quality work in IT or fully decentralizing without oversight will be sufficient.

Practice this question →

68

MCQhard

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?

A.Explain that the whiskers show the range of typical scores, like the spread of data.

B.Provide a handout with definitions of box plot elements.

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

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

AnswerA

Plain language and analogies improve comprehension.

Why this answer

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.

Exam trap

The trap here is that candidates may choose Option D because it is technically accurate, but the exam tests the ability to tailor communication to the audience's data literacy, not just technical correctness.

How to eliminate wrong answers

Option B is wrong because providing a handout with definitions assumes the stakeholder can interpret technical jargon, which contradicts the need for immediate, accessible communication to a non-data-savvy audience. Option C is wrong because replacing the box plot with a bar chart of average scores loses the distribution information (e.g., variability, skewness, outliers) that the box plot conveys, which may be critical for the insight. Option D is wrong because stating that whiskers represent minimum and maximum values excluding outliers is technically correct but uses statistical terminology ('outliers') that a non-data-savvy stakeholder may not understand, failing the communication strategy goal.

Practice this question →

69

MCQhard

A data governance committee is reviewing a new analytics project that will combine customer data from a CRM system with clickstream data from a website. The committee must ensure compliance with the organization's data retention policy. Which consideration is most critical when determining the retention period for the combined dataset?

A.The retention period should be set to match the average retention period of the source systems to simplify management.

B.The retention period should be based on the longest retention requirement of any source system to avoid losing data.

C.The retention period should be determined by the business owner of the new project without regard to source system policies.

D.The retention period should comply with the most restrictive policy among all source datasets and any new regulatory requirements.

AnswerD

When combining datasets, the resulting dataset inherits the strictest retention and usage constraints from its sources. This ensures compliance with all applicable regulations and internal policies. For example, if one source has a 30-day retention and another has a 1-year retention, the combined dataset must be deleted after 30 days unless a new lawful basis exists.

Why this answer

When datasets are combined, the resulting data must adhere to the most restrictive retention and usage policies of all sources. This is because the combination may create new privacy risks or fall under multiple regulations. The strictest policy ensures that no source's requirements are violated.

Therefore, the committee should identify the shortest retention period or the most stringent regulatory mandate and apply that to the combined dataset.

Exam trap

The trap here is assuming that you can average or choose the longest retention period, when the correct approach is to apply the most restrictive policy.

Practice this question →

70

MCQhard

A financial services firm is designing access controls for a new analytics platform. Regulators require that analysts see only the customer records relevant to their assigned region, and that every access to personally identifiable information be logged. Which combination of controls should the governance team implement to satisfy both requirements?

A.Role-based access control with quarterly access recertification and encrypted backups

B.Column-level masking of PII fields combined with multi-factor authentication at sign-in

C.Row-level security policies plus immutable audit logging of PII queries

D.Data loss prevention scanning of outbound email plus annual security awareness training

AnswerC

Row-level security enforces predicates so each analyst can only retrieve records matching their assigned region, directly satisfying the scoping requirement. Immutable audit logging captures who accessed which PII and when, satisfying the traceability requirement. Together they deliver both the visibility restriction and the evidentiary trail regulators expect from the platform.

Why this answer

Meeting both mandates requires a preventive control that scopes records by region and a detective control that records each PII touch. Row-level security supplies the regional predicate, while immutable audit logging supplies the tamper-evident access history. Role-based access, masking, MFA, and DLP each address adjacent concerns but cannot jointly deliver row scoping plus per-access PII traceability.

Exam trap

The trap here is treating column masking as equivalent to row filtering, when masking hides fields but leaves every record visible.

Practice this question →

71

Multi-Selectmedium

A hospital analytics team is preparing to share a de-identified patient outcomes dataset with an external research partner. The privacy officer requires that the dataset satisfy governance requirements for lawful secondary use while preserving analytical utility. Which two practices should the team apply? (Choose two.)

Select 2 answers

A.Retain the partner's access indefinitely so future research questions can reuse the dataset.

B.Share the dataset over an unencrypted file transfer so the partner can download it faster.

C.Remove or generalize all direct identifiers such as names, medical record numbers, and full dates of birth.

D.Execute a data-sharing agreement that defines permitted use, retention limits, and breach obligations.

E.Publish the dataset on a public website to streamline distribution to the research community.

AnswersC, D

Removing or generalizing direct identifiers reduces re-identification risk and aligns with de-identification expectations for secondary use. Direct identifiers like names and medical record numbers let anyone link records to a person, so they must be stripped or generalized before sharing. This step preserves analytical value in the remaining clinical variables while satisfying the privacy officer's governance requirement.

Why this answer

Lawful secondary use of health data combines de-identification of direct identifiers with a binding data-sharing agreement that scopes purpose, retention, and breach duties. Together they reduce re-identification risk and create enforceable accountability. Unencrypted transfer, indefinite access, and public release each undermine those controls and fail the privacy officer's governance requirements.

Exam trap

The trap here is treating de-identification as sufficient on its own, when governance also requires contractual controls that limit purpose, retention, and onward sharing.

Practice this question →

72

MCQeasy

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?

A.Grouped bar chart

B.Pie chart

C.Stacked bar chart

D.Line chart

AnswerA

A grouped bar chart plots a second categorical dimension—region—as clustered bars within each monthly group, so both month and region remain visible. A simple bar chart cannot encode the added region breakdown, and a stacked chart obscures per-region comparison.

Why this answer

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.

Exam trap

CompTIA often tests the distinction between grouped and stacked bar charts, trapping candidates who think any multi-category bar chart is equivalent, when in fact grouped bars are for comparing individual category values and stacked bars are for comparing totals and proportions.

How to eliminate wrong answers

Option B (Pie chart) is wrong because pie charts are designed to show parts of a whole for a single categorical variable at a single point in time, not to compare multiple categories (regions) across a time series (months). Option C (Stacked bar chart) is wrong because while it can show regions within months, it emphasizes the total sales per month and the proportion each region contributes, rather than allowing direct comparison of individual region sales across months. Option D (Line chart) is wrong because line charts are best for showing continuous trends over time for one or more series, but they do not effectively compare discrete categories like regions within each month; a grouped bar chart provides clearer categorical comparison.

Practice this question →

73

Multi-Selecteasy

A data analyst is preparing a presentation to share findings with non-technical stakeholders. Which TWO practices should the analyst follow to effectively communicate data insights? (Choose two.)

Select 2 answers

A.Tailor the message to the audience

B.Provide raw data tables

C.Use technical jargon to demonstrate expertise

D.Include all data anomalies and outliers

E.Focus on actionable insights

AnswersA, E

Tailoring the message to the audience satisfies the stem's non-technical stakeholder constraint by translating statistical findings into business-relevant language, avoiding jargon and technical notation. This ensures comprehension and drives decision-making, since the audience lacks the analytical background assumed in specialist reporting.

Why this answer

Option A, 'Tailor the message to the audience,' is correct because effective data communication requires framing findings in terms and context that non-technical stakeholders can readily understand, such as using plain language, relevant business metrics, and analogies instead of assuming technical background. Option E, 'Focus on actionable insights,' is correct because the primary purpose of presenting to stakeholders is to drive decisions, so the analyst should emphasize what the data means and what actions should follow rather than merely describing the data. Option B, 'Provide raw data tables,' is not appropriate because dumping unprocessed tables overwhelms non-technical audiences and obscures the key takeaways.

Option C, 'Use technical jargon to demonstrate expertise,' is wrong because jargon creates barriers and alienates the audience rather than clarifying insights. Option D, 'Include all data anomalies and outliers,' is not suitable because exhaustive detail distracts from the main message; anomalies should only be mentioned if they materially affect the conclusions.

Exam trap

The trap is selecting options that seem thorough (raw data, all outliers) or impressive (technical jargon) when they actually hinder communication; the exam tests understanding that audience-centric, action-oriented communication is key.

Practice this question →

74

MCQeasy

A data analyst wants to compare the sales performance of four different stores over the same time period. Which chart type is most suitable?

A.Line chart with multiple lines

B.Grouped bar chart

C.Stacked bar chart

D.Pie chart with multiple pies

AnswerB

A grouped bar chart places the four stores side by side within each time period on a shared categorical axis, enabling direct comparison of their sales values. This satisfies the requirement to compare multiple discrete entities across the same period, which a single-series chart or pie chart cannot do.

Why this answer

A grouped bar chart is the most suitable choice because it allows direct comparison of discrete categories (four stores) across a common time period, with each group representing a time interval and individual bars representing each store's sales. This chart type excels at side-by-side comparisons of multiple entities over the same categorical axis, making it ideal for the analyst's goal.

Exam trap

The trap here is that candidates often choose a line chart (Option A) because they associate 'time period' with trend analysis, but the question explicitly asks to compare sales performance over the same time period, not to show changes over time, making the grouped bar chart the correct choice for direct comparison of discrete entities.

How to eliminate wrong answers

Option A is wrong because a line chart with multiple lines is designed to show trends over continuous time, but here the time period is fixed and the focus is on comparing discrete stores, not tracking changes over time. Option C is wrong because a stacked bar chart shows part-to-whole relationships within each time period, which obscures individual store performance and makes direct comparisons between stores difficult. Option D is wrong because a pie chart with multiple pies is meant to show proportions of a whole for each store separately, but comparing sales across stores requires a common baseline, which pie charts do not provide.

Practice this question →

75

MCQhard

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?

A.The policy allows all users to download data.

B.The policy denies data downloads to all users.

C.The policy restricts data downloads to a specific IP range.

D.The policy allows data uploads from a specific IP range.

AnswerC

The policy's stated effect is exactly that downloads are limited to a defined IP range, so the description matches the access control as written. This satisfies the analyst's need to communicate the restriction accurately, confirming downloads outside that range are blocked.

Why this answer

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.

Exam trap

The trap here is that candidates may confuse the policy's effect with a blanket denial (Option B) or misinterpret the restriction as applying to uploads (Option D), when the policy specifically targets downloads and allows them only from a defined IP range.

How to eliminate wrong answers

Option A is wrong because it describes an allow-all effect, which contradicts the explicit IP-based restriction in the policy; a policy that restricts to a specific IP range does not allow all users. Option B is wrong because it states the policy denies downloads to all users, but the policy actually allows downloads from the specified IP range while implicitly or explicitly denying others—it does not universally deny. Option D is wrong because it refers to data uploads (e.g., `s3:PutObject`), but the question specifically addresses downloads (`s3:GetObject`), and the policy effect is about restricting downloads, not uploads.

Practice this question →

Page 1 of 2 · 119 questions totalNext →

Ready to test yourself?

Try a timed practice session using only Data Governance questions.

Start 20-question session