Courseiva

CompTIA Data+ (DA0-002) (DA0-002) — Questions 76–150

1004 questions total · 14pages · All types, answers revealed

Take a mock examExam hub
Page 1

Page 2 of 14

Page 3
76
Multi-Selecthard

A senior data analyst is advising a team on dashboard design principles. Which THREE of the following are recommended best practices? (Choose three.)

Select 3 answers
A.Apply consistent color coding across all charts for similar metrics.
B.Include every data point to provide complete context.
C.Use clear labels and titles for all charts.
D.Use a variety of colors to make the dashboard visually exciting.
E.Maximize the data-ink ratio by minimizing chartjunk.
AnswersA, C, E

Consistent colour coding lets a viewer map the same hue to the same metric across every chart, so comparisons hold without relearning the palette. This satisfies the dashboard-design constraint by reducing cognitive load and preventing misreading when panels sit side by side.

Why this answer

Option A is correct because consistent color coding across all charts for similar metrics lets viewers instantly associate a color with a given measure, reducing cognitive load and preventing misinterpretation when moving between visualizations. Option C is correct because clear labels and titles give each chart an explicit metric, dimension, and unit context, so users do not have to guess what the axes or values represent. Option E is correct because maximizing the data-ink ratio by minimizing chartjunk (Tufte's principle) removes non-data elements such as redundant gridlines, 3D effects, and decorative backgrounds, keeping attention on the actual data.

Option B is not recommended because plotting every data point creates clutter and obscures trends; aggregation or filtering is usually preferable. Option D is not recommended because using a variety of colors merely for visual excitement is decorative rather than informative and can confuse meaning or harm accessibility.

Exam trap

The trap is mistaking 'visually exciting' (option D) for good design — candidates who equate engagement with color variety pick D, but professional dashboards prioritize clarity and consistency over decoration.

Full explanation →
77
MCQmedium

An analyst needs to count the number of orders per customer but only for customers who have placed more than 5 orders. Which SQL construct allows filtering after aggregation?

A.WHERE COUNT(*) > 5
B.LIMIT 5
C.HAVING COUNT(*) > 5
D.ORDER BY COUNT(*) > 5
AnswerC

HAVING filters grouped rows after aggregation, unlike WHERE, which filters individual rows before grouping. Because the requirement is to count orders per customer and then retain only those exceeding five, HAVING COUNT(*) > 5 applies the condition to the aggregated count, satisfying the post-aggregation filtering constraint in the stem.

Why this answer

HAVING is the SQL clause specifically designed to filter groups after aggregation has been performed by GROUP BY. Because COUNT(*) is an aggregate function, it cannot be evaluated in the WHERE clause, which runs before grouping. HAVING executes after GROUP BY and aggregation, so it can reference aggregate results like COUNT(*) > 5.

Exam trap

DA0-002 often tests the WHERE vs. HAVING distinction by presenting an aggregate filter and tempting candidates to pick WHERE because it is the more familiar filtering clause.

How to eliminate wrong answers

Option A is wrong because WHERE is evaluated before GROUP BY and aggregation, so aggregate functions like COUNT(*) are not yet available and the query will error out. Option B is wrong because LIMIT restricts the number of rows returned, not the number of orders per customer, and it cannot filter based on an aggregate value. Option D is wrong because ORDER BY only sorts result rows and cannot be used as a filter predicate; COUNT(*) > 5 in an ORDER BY clause is a boolean expression that does not restrict rows.

Full explanation →
78
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.

Full explanation →
79
Multi-Selecteasy

Which TWO visualization types are suitable for showing the distribution of a single continuous variable?

Select 2 answers
A.Box plot
B.Line chart
C.Histogram
D.Scatter plot
E.Pie chart
AnswersA, C

A box plot summarises a continuous variable through quartiles, median, and whiskers, exposing spread, skew, and outliers. It satisfies the distribution requirement by displaying the shape of a single continuous variable's values across its range.

Why this answer

A box plot (option A) is correct because it summarizes the distribution of a single continuous variable through its median, quartiles, and potential outliers, directly revealing spread and skewness. A histogram (option C) is also correct because it bins a single continuous variable into intervals and displays the frequency of values in each bin, clearly showing the distribution's shape. A line chart (option B) is not appropriate here since it is designed to show trends or changes over an ordered sequence, typically time.

A scatter plot (option D) is used to visualize the relationship between two continuous variables, not the distribution of one. A pie chart (option E) shows proportions of a whole for categorical data, not the distribution of a continuous variable.

Exam trap

CompTIA often tests the distinction between visualization types by presenting a line chart as a distractor, tempting candidates to confuse trend visualization with distribution analysis, especially when the continuous variable is time-based.

Full explanation →
80
MCQhard

A data analyst needs to design a report for two audiences: executives want a high-level trend, and operational managers need current inventory levels. Which approach best satisfies both?

A.Include all details in one report so everyone sees the same information.
B.Send only the operational dashboard and let executives derive trends.
C.Ask the stakeholders to agree on a single view.
D.Create two separate reports: an executive summary with trends and an operational dashboard with real-time inventory.
AnswerD

Separate reports let each audience receive only relevant data: executives get aggregated trends, while operational managers see current inventory levels. This satisfies the stem's dual-audience constraint, since a single shared report would either overwhelm executives with detail or hide the real-time granularity managers require.

Why this answer

Providing a summary view for executives and a detailed view for operational managers addresses different needs.

Full explanation →
81
MCQmedium

A data analyst needs to determine whether the mean sales of two different regions are significantly different. The samples are independent and the data is normally distributed. Which statistical test should be used?

A.Chi-square test for independence
B.ANOVA
C.Independent samples t-test
D.Paired t-test
AnswerC

Two independent, normally distributed samples compared on a continuous mean call for the independent samples t-test, which assesses whether the difference between group means exceeds sampling variability. A paired test would require matched observations, which the stem excludes.

Why this answer

The independent samples t-test is the correct choice because the scenario involves comparing the means of two independent groups (two different regions) with normally distributed data. This test specifically assesses whether the difference between the two sample means is statistically significant, assuming equal or unequal variances as determined by Levene's test.

Exam trap

CompTIA often tests the distinction between independent and paired t-tests, trapping candidates who overlook the 'independent samples' condition and mistakenly choose the paired t-test for any two-group comparison.

How to eliminate wrong answers

Option A is wrong because the Chi-square test for independence is used for categorical data to assess associations between two variables, not for comparing means of continuous data. Option B is wrong because ANOVA is used to compare means among three or more groups, not exactly two independent groups. Option D is wrong because the paired t-test is used for dependent samples (e.g., before-and-after measurements on the same subjects), not for independent samples from different regions.

Full explanation →
82
MCQmedium

A data analyst needs to visualize the relationship between two continuous variables, such as sales revenue and advertising spend, to identify potential correlation. Which chart type is most appropriate?

A.Pie chart
B.Line chart
C.Bar chart
D.Scatter plot
AnswerD

A scatter plot places one continuous variable on each axis, so each point represents a paired observation. This reveals correlation strength, direction, and outliers between sales revenue and advertising spend, which categorical or part-to-whole charts cannot show.

Why this answer

A scatter plot is the most appropriate chart to visualize the relationship between two continuous variables, such as sales revenue and advertising spend. It plots each data point on a two-dimensional plane, allowing the analyst to observe patterns, trends, and potential correlation.

Exam trap

DA0-002 often tests the confusion between line charts and scatter plots, where candidates may incorrectly choose line chart for correlation because it also shows relationships, but line charts are for time series.

How to eliminate wrong answers

Option A (Pie chart) is wrong because it shows parts of a whole for categorical data, not relationships between continuous variables. Option B (Line chart) is wrong because it is used to show trends over time, typically with time on the x-axis, not correlation between two variables. Option C (Bar chart) is wrong because it compares categorical data or discrete values, not continuous relationships.

Full explanation →
83
Multi-Selecthard

A data scientist is conducting an A/B test with a significance level of 0.05. Which three factors should be considered when calculating the required sample size? (Choose THREE)

Select 3 answers
A.Seasonality of the data
B.Statistical power (e.g., 0.80)
C.Minimum detectable effect size
D.Number of clusters in k-means
E.Significance level (α)
AnswersB, C, E

Statistical power, typically 0.80, fixes the tolerated Type II error rate and determines how large a sample is needed to detect a real effect. It is a required input alongside significance level and effect size.

Why this answer

Option B is correct because statistical power (typically 0.80 or 80%) directly determines sample size: higher power requires a larger sample to reliably detect a true effect if one exists. Option C is correct because the minimum detectable effect size is a core input to sample-size formulas (e.g., n ≈ 16σ²/Δ² for a two-sample t-test at α=0.05, power=0.80); smaller effects demand much larger samples. Option E is correct because the significance level α (here 0.05) sets the Type I error threshold and appears in every sample-size calculation, with smaller α requiring larger samples.

Option A is not a direct input to the standard sample-size formula, though seasonality may inform variance estimates or test design. Option D is unrelated: the number of clusters in k-means is an unsupervised clustering parameter and has no bearing on A/B test sample-size determination.

Exam trap

The trap is including operational or data-context factors (seasonality, clustering hyperparameters) that feel relevant to experiment design but are not inputs to the statistical power calculation — only power, effect size, and α are.

Full explanation →
84
MCQhard

A logistic regression model is used to predict the probability of customer churn. The model's coefficient for the feature 'customer support calls' is 0.8 with a p-value of 0.001. Which interpretation is correct?

A.For each additional support call, the log-odds of churn increase by 0.8, and this effect is statistically significant.
B.The odds of churn are multiplied by 0.8 for each additional call.
C.Support calls have no significant effect on churn.
D.For each additional support call, the probability of churn increases by 80%.
AnswerA

In logistic regression, coefficients are expressed in log-odds, so a coefficient of 0.8 means each additional support call raises the log-odds of churn by 0.8. The p-value of 0.001, below the 0.05 threshold, confirms this effect is statistically significant rather than due to chance.

Why this answer

In logistic regression, coefficients are expressed in log-odds units. A coefficient of 0.8 for 'customer support calls' means each additional call increases the log-odds of churn by 0.8, holding other predictors constant. The p-value of 0.001 is below the conventional 0.05 threshold, so the effect is statistically significant.

Exam trap

DA0-002 often tests the confusion between log-odds coefficients and odds ratios — candidates must remember that the raw coefficient is in log-odds, and only e^β gives the multiplicative odds change.

How to eliminate wrong answers

Option B is wrong because it confuses the log-odds coefficient with an odds ratio — the odds ratio would be e^0.8 ≈ 2.23, meaning odds multiply by about 2.23, not 0.8. Option C is wrong because a p-value of 0.001 is highly significant, directly contradicting the claim of no effect. Option D is wrong because a coefficient of 0.8 does not translate to an 80% probability increase; probability changes depend on the baseline probability and the logistic curve, not a linear 80% shift.

Full explanation →
85
MCQhard

In time series decomposition, a data analyst separates a retail sales series into trend, seasonal, and residual components. After decomposition, the residual component shows no pattern and is random. Which of the following best describes the seasonal component?

A.Cyclical variations lasting more than a year.
B.Irregular fluctuations that cannot be predicted.
C.Regular patterns that repeat at fixed intervals.
D.A long-term increase or decrease in sales.
AnswerC

The seasonal component captures periodic fluctuations that recur at fixed intervals, such as weekly or yearly cycles, distinct from the trend's long-term direction and the residual's random noise. The stem's random residual confirms seasonality is the regular, repeating pattern.

Why this answer

The seasonal component captures regular, repeating patterns at fixed intervals — for example, higher retail sales every December or every weekend. Because the residual shows no pattern (random noise), the decomposition has successfully isolated the systematic periodic structure into the seasonal component. This is the defining characteristic of seasonality in time series decomposition.

Exam trap

The trap is conflating the four decomposition components — candidates must distinguish seasonal (fixed repeating period) from cyclical (longer, irregular), trend (long-term direction), and residual (random noise).

How to eliminate wrong answers

Option A is wrong because cyclical variations lasting more than a year are a distinct component (the 'cyclical' component), not the seasonal component — seasonality has a fixed, known period (e.g., weekly, monthly, quarterly). Option B is wrong because irregular, unpredictable fluctuations describe the residual (noise) component, which the question states is random. Option D is wrong because a long-term increase or decrease describes the trend component, not the seasonal component.

Full explanation →
86
MCQeasy

A data analyst calculates the mean, median, and mode of a dataset. Which measure of central tendency is most affected by extreme outliers?

A.Mean
B.Range
C.Median
D.Mode
AnswerA

Every value contributes arithmetically to the mean, so a single extreme outlier shifts it substantially. The median depends only on positional rank, and the mode only on frequency, leaving both largely resistant to extreme values.

Why this answer

The mean is sensitive to extreme values because it includes all data points in its calculation, whereas median and mode are more robust.

Full explanation →
87
MCQeasy

A retail analyst needs to determine the most popular product category. The dataset includes columns: ProductID, Category, SalesDate, QuantitySold, UnitPrice. Which column contains qualitative data?

A.SalesDate
B.QuantitySold
C.UnitPrice
D.Category
AnswerD

Category holds qualitative data because it labels products into named groups rather than measuring amounts. ProductID, SalesDate, QuantitySold and UnitPrice are all quantitative or temporal, so they cannot satisfy the stem's requirement for a qualitative column. Category's non-numeric, descriptive values are precisely what the analyst needs to group and rank popularity.

Why this answer

Qualitative data (also called categorical data) represents non-numeric categories or labels. The 'Category' column contains text values such as 'Electronics' or 'Clothing', which are descriptive and cannot be used in arithmetic operations. This makes it the only qualitative column in the dataset.

Exam trap

The trap here is that candidates often mistake dates (SalesDate) for qualitative data because they are not numeric, but dates are actually quantitative interval data with a meaningful order and equal intervals.

How to eliminate wrong answers

Option A is wrong because SalesDate represents a point in time, which is quantitative (interval) data, not qualitative. Option B is wrong because QuantitySold is a numeric count, making it quantitative (discrete) data. Option C is wrong because UnitPrice is a numeric monetary value, making it quantitative (continuous) data.

Full explanation →
88
MCQmedium

A data analyst is presenting a story about why customer churn increased last quarter. They start by showing the current churn rate, then identify a key event (a pricing change), and finally show the impact of a proposed retention campaign. This structure follows which narrative arc?

A.Introduction → Methods → Results
B.Hook → Context → Call to action
C.Problem → Solution → Evidence
D.Situation → Complication → Resolution
AnswerD

The analyst establishes the current churn baseline (situation), introduces the pricing change as the causal disruption (complication), then presents the retention campaign as the remedy (resolution). This maps directly onto the Situation → Complication → Resolution arc, structuring the narrative around cause and response.

Why this answer

The Situation → Complication → Resolution arc (also called SCR) starts by establishing the current state (churn rate), introduces the disrupting event (pricing change) as the complication, and closes with the proposed action (retention campaign) as the resolution. This is the standard narrative structure for business data storytelling because it mirrors how decisions are made: context, problem, recommendation.

Exam trap

The trap is confusing SCR with generic problem-solution structures — candidates who see 'problem' and 'solution' pick option C, but SCR specifically requires the complication (the disrupting event) between situation and resolution.

How to eliminate wrong answers

Option A is wrong because Introduction → Methods → Results is an academic/research paper structure, not a business narrative — it front-loads methodology rather than building tension toward a recommendation. Option B is wrong because Hook → Context → Call to action is a marketing/presentation structure that lacks the explicit 'complication' element that explains why the situation changed. Option C is wrong because Problem → Solution → Evidence puts the solution before the evidence, which is backwards for data storytelling — evidence should support the diagnosis before the solution is proposed.

Full explanation →
89
Multi-Selecteasy

Which TWO are common mistakes when creating data visualizations?

Select 2 answers
A.Using excessive 3D effects that obscure data
B.Sorting categories alphabetically in a bar chart
C.Choosing a color-blind friendly palette
D.Including a legend to identify chart elements
E.Starting the y-axis at a value other than zero
AnswersA, E

Excessive 3D effects distort perception: depth, perspective and occlusion make bar heights and areas impossible to compare accurately, so viewers misread magnitudes. This directly satisfies the stem's "common mistakes" criterion, since decorative dimensionality sacrifices the precise encoding that two-dimensional position and length provide.

Why this answer

Option A is correct because excessive 3D effects distort proportions and depth cues, making values harder to compare accurately and often obscuring data points behind other elements. Option E is correct because starting the y-axis at a non-zero value on a bar chart exaggerates differences between bars, misleading viewers about the true magnitude of change. Option B is not a common mistake since alphabetical sorting is a legitimate, neutral ordering choice when no natural or quantitative order exists.

Option C is not a mistake because color-blind friendly palettes improve accessibility and readability. Option D is not a mistake because a legend is a standard, helpful element for identifying chart elements.

Exam trap

DA0-002 often tests whether candidates can distinguish genuine visualisation mistakes (3D distortion, truncated axes) from stylistic choices (alphabetical sorting, legends) that are perfectly valid.

Full explanation →
90
MCQmedium

A retail company wants to identify customer segments based on purchase history and demographics. Which technique is most appropriate for this task?

A.Linear regression
B.K-means clustering
C.Chi-square test
D.Logistic regression
AnswerB

K-means clustering partitions unlabelled data into k groups by minimising within-cluster variance, directly satisfying the requirement to identify customer segments from purchase history and demographics without predefined labels. Unlike classification, it discovers natural groupings, making it appropriate for exploratory segmentation of retail customers.

Why this answer

K-means clustering is an unsupervised learning algorithm that partitions observations into k groups based on similarity across multiple features, making it ideal for segmenting customers by purchase history and demographics. It doesn't require labeled outcomes, which matches the exploratory nature of customer segmentation. The algorithm iteratively assigns points to the nearest centroid and recalculates centroids until convergence.

Exam trap

The trap is confusing supervised classification (logistic regression) with unsupervised clustering (K-means) — candidates who see 'segments' and think 'categories' pick logistic regression, but segmentation discovers groups rather than predicting predefined labels.

How to eliminate wrong answers

Option A is wrong because linear regression predicts a continuous outcome from input features — it's supervised and requires a target variable, which segmentation doesn't have. Option C is wrong because a chi-square test assesses association between categorical variables; it tests hypotheses rather than grouping observations. Option D is wrong because logistic regression predicts a binary outcome (e.g., churn yes/no) and is supervised — it classifies into predefined categories rather than discovering natural groupings.

Full explanation →
91
MCQhard

In Tableau, an analyst wants to create a parameter that allows users to select a threshold for highlighting products with sales above that value. The parameter is used in a calculated field that returns TRUE if sales exceed the parameter value. Which type of calculated field is this?

A.Table calculation
B.Aggregate calculation
C.Level of Detail expression
D.Boolean calculation
AnswerD

The calculated field returns TRUE or FALSE depending on whether sales exceed the parameter threshold, so its output is a Boolean data type. Tableau classifies such TRUE/FALSE expressions as Boolean calculations, matching the highlighting logic described.

Why this answer

A calculated field that returns TRUE or FALSE based on a condition is a Boolean calculation. In Tableau, Boolean calculated fields produce logical values (True/False) and are often used for filtering, highlighting, or conditional formatting. Here, the field compares Sales to a parameter value and returns TRUE when Sales exceeds the threshold, which is a classic Boolean expression.

The parameter allows dynamic threshold selection, but the output type of the calculation is Boolean.

Exam trap

The trap here is confusing the output type (Boolean) with the computation method (table calc, aggregate, LOD). Candidates might see 'parameter' and think it's a table calculation because parameters are often used in table calculations, or they might think it's an aggregate because it involves sales, but the key is that the calculated field returns TRUE/FALSE, which is Boolean.

How to eliminate wrong answers

Option A is wrong because a table calculation operates on the data in the view (e.g., running total, percent of total) and is computed after aggregation, not a simple row-level Boolean comparison. Option B is wrong because an aggregate calculation returns a single aggregated value (e.g., SUM(Sales), AVG(Profit)) rather than a row-level TRUE/FALSE result. Option C is wrong because a Level of Detail expression controls the granularity of aggregation (e.g., {FIXED [Category] : SUM(Sales)}) and does not inherently return a Boolean; it returns a value at a specified level of detail.

Full explanation →
92
MCQmedium

A data scientist is using K-means clustering with k=3. After the first iteration, the centroids are recalculated. Which step occurs next in the algorithm?

A.Calculate the sum of squared errors
B.Stop the algorithm because k is fixed
C.Compute the elbow curve
D.Assign each point to the nearest centroid
AnswerD

Reassigning every point to its nearest centroid follows each recalculation, since K-means alternates between these two phases until convergence. After the first iteration's centroid update, the algorithm must reassign points before recalculating again, satisfying the stem's "which step occurs next" constraint.

Why this answer

After centroids are recalculated, K-means returns to the assignment step, reassigning each data point to the nearest (typically Euclidean distance) centroid. This assignment-then-update loop repeats until convergence — either centroids stop moving, assignments stabilize, or a maximum iteration count is reached. So the next step after recalculation is reassignment.

Exam trap

The trap is thinking the algorithm stops after centroid recalculation — candidates who confuse 'k is fixed' with 'algorithm is done' pick option B, but K-means iterates assignment and update until convergence.

How to eliminate wrong answers

Option A is wrong because sum of squared errors (inertia) is computed to monitor convergence or select k via the elbow method, but it's not the immediate next algorithmic step after centroid recalculation. Option B is wrong because fixing k does not terminate the algorithm — k is a hyperparameter set before training; the algorithm stops only on convergence criteria. Option C is wrong because the elbow curve is a diagnostic plot generated across multiple k values before or after training, not a step inside a single K-means run.

Full explanation →
93
MCQmedium

In a multiple regression model, one predictor has a high p-value (0.45). What should the analyst consider doing?

A.Transform the predictor
B.Keep the predictor regardless
C.Remove the predictor from the model
D.Increase the sample size
AnswerC

A p-value of 0.45 exceeds typical significance thresholds, indicating the predictor's coefficient is not statistically distinguishable from zero given the other variables. Removing it simplifies the model and reduces multicollinearity, though the analyst should first check theoretical relevance.

Why this answer

A p-value of 0.45 is far above the conventional significance threshold (typically 0.05), meaning there is no statistically significant evidence that this predictor is associated with the outcome variable after accounting for the other predictors. Removing non-significant predictors simplifies the model, reduces multicollinearity risk, and improves interpretability without meaningful loss of predictive power. This is the standard first step in backward elimination-style model refinement.

Exam trap

The trap here is confusing statistical insignificance with a need for data transformation or more data — candidates often assume any problematic predictor requires a technical fix rather than simple removal from the model.

How to eliminate wrong answers

Option A is wrong because transforming a predictor is used to fix non-linearity or heteroscedasticity issues, not to address statistical insignificance — a transformation won't make an irrelevant variable relevant. Option B is wrong because keeping a high-p-value predictor inflates model complexity, can introduce noise, and may destabilize coefficient estimates through multicollinearity. Option D is wrong because increasing sample size addresses statistical power for detecting small effects, but a p-value of 0.45 indicates the effect is essentially absent, not merely underpowered.

Full explanation →
94
MCQmedium

A data engineer is designing a system to store raw sensor data from thousands of IoT devices. The data is expected to be used for exploratory analytics and machine learning. Which storage solution is most appropriate?

A.Data lake
B.Relational database
C.Data mart
D.Key-value store
AnswerA

A data lake stores raw, schema-on-read data at scale without upfront transformation, suiting thousands of IoT devices and varied formats. Exploratory analytics and machine learning need that flexible, unmodelled raw data, which a data warehouse's structured schema would constrain.

Why this answer

A data lake is the most appropriate choice because it can store raw, unprocessed sensor data in its native format (e.g., JSON, Parquet, or binary) without requiring a predefined schema. This flexibility supports exploratory analytics and machine learning workflows where data schemas may evolve or be unknown at ingestion time. Data lakes also scale horizontally to handle the high volume and velocity of data from thousands of IoT devices, unlike traditional storage systems that impose rigid structures or size limits.

Exam trap

The trap here is that candidates often confuse a data lake with a data warehouse or relational database, assuming raw data must be structured immediately, when in fact a data lake's schema-on-read approach is specifically designed for exploratory and machine learning use cases.

How to eliminate wrong answers

Option B is wrong because a relational database enforces a fixed schema and ACID transactions, which are unnecessary for raw sensor data and would introduce significant overhead for high-velocity, schema-on-read workloads. Option C is wrong because a data mart is a subset of data optimized for a specific business function or department, not designed to store raw, exploratory data from thousands of IoT devices. Option D is wrong because a key-value store is optimized for simple lookups by a single key and lacks the query flexibility and analytical capabilities needed for exploratory analytics and machine learning on complex sensor data.

Full explanation →
95
MCQeasy

A data architect is designing a schema for a product catalog where each product has a variable number of attributes. Which NoSQL database type is most appropriate?

A.Graph database
B.Document store
C.Key-value store
D.Relational database
AnswerB

Document stores hold each product as a self-describing JSON-like document, so attributes can vary per item without a fixed schema. This directly satisfies the stem's variable-attribute constraint, unlike columnar or key-value models that require predefined structures. Nested attributes and arrays are queried natively, matching heterogeneous catalog entries.

Why this answer

A document store (e.g., MongoDB, Couchbase) is the most appropriate choice because it stores data in flexible, self-describing documents (typically JSON or BSON), allowing each product to have a variable number of attributes without requiring a predefined schema. This directly matches the requirement of a product catalog where attributes can differ per product, unlike rigid relational tables that would require complex EAV (Entity-Attribute-Value) patterns or frequent schema migrations.

Exam trap

The trap here is that candidates often confuse 'variable attributes' with 'relationships' and incorrectly choose a graph database, or they assume key-value stores are flexible enough, overlooking the need for queryability on individual attributes.

How to eliminate wrong answers

Option A is wrong because graph databases (e.g., Neo4j) are optimized for highly connected data and relationship traversal, not for storing documents with variable attributes; they would force you to model each attribute as a node or relationship, adding unnecessary complexity. Option C is wrong because key-value stores (e.g., Redis, DynamoDB) treat the entire product as an opaque value, making it impossible to query or index individual attributes without application-level parsing, which defeats the purpose of a catalog. Option D is wrong because relational databases require a fixed schema per table; handling variable attributes would necessitate either many nullable columns, frequent ALTER TABLE statements, or a cumbersome EAV pattern, all of which degrade performance and maintainability.

Full explanation →
96
MCQmedium

A data analyst is examining a dataset of customer transactions. The analyst notices that the 'TransactionAmount' column contains values like 100.50, 200.75, and 50.00. The analyst wants to determine the average transaction amount. Which type of data is 'TransactionAmount'?

A.Interval
B.Ratio
C.Nominal
D.Ordinal
AnswerB

Ratio data has all the properties of interval data plus a true zero, allowing for meaningful ratios and arithmetic operations. TransactionAmount has a true zero (no transaction) and equal intervals, so it is ratio data. Averages, sums, and ratios are valid for ratio data.

Why this answer

TransactionAmount is ratio data because it has a true zero point and equal intervals between values. This allows for meaningful arithmetic operations such as calculating an average. Nominal data is categorical, ordinal data has unequal intervals, and interval data lacks a true zero, so none of those fit.

Exam trap

The trap here is confusing interval and ratio data by overlooking the presence of a true zero in monetary values.

Full explanation →
97
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.

Full explanation →
98
MCQeasy

A data analyst needs to join two tables in a SQL database: Orders and Customers. The analyst wants to include all orders, even if there is no matching customer record. Which type of join should be used?

A.RIGHT JOIN
B.FULL OUTER JOIN
C.LEFT JOIN
D.INNER JOIN
AnswerC

A LEFT JOIN returns every row from the left table (Orders) and matches rows from Customers where they exist, filling NULLs otherwise. Because the stem requires all orders to appear even without a matching customer, this outer join preserves the unmatched left-side rows.

Why this answer

A LEFT JOIN returns all rows from the left table (Orders) and the matching rows from the right table (Customers). If there is no match, NULL values are returned for the right table's columns. This satisfies the requirement to include all orders, even those without a matching customer record.

Exam trap

The trap here is that candidates often confuse LEFT JOIN with RIGHT JOIN, mistakenly thinking they need to 'keep all customers' instead of 'keep all orders,' or they overcomplicate the requirement by choosing FULL OUTER JOIN when only one side needs to be preserved.

How to eliminate wrong answers

Option A (RIGHT JOIN) is wrong because it returns all rows from the right table (Customers) and matching rows from the left table (Orders), which would include all customers, not all orders. Option B (FULL OUTER JOIN) is wrong because it returns all rows from both tables, including unmatched rows from both sides, which is unnecessary when the requirement is specifically to keep all orders. Option D (INNER JOIN) is wrong because it returns only rows where there is a match in both tables, which would exclude orders without a matching customer record.

Full explanation →
99
MCQmedium

A data analyst wants to show the correlation between advertising spend and website traffic. Which chart type should they use?

A.Area chart
B.Scatter plot
C.Bar chart
D.Line chart
AnswerB

A scatter plot maps advertising spend on one axis against website traffic on the other, exposing the relationship between two continuous variables. This directly satisfies the stem's correlation requirement, since each point represents a paired observation and the resulting pattern reveals direction and strength of association.

Why this answer

A scatter plot displays each observation as a point with one variable on the x-axis (advertising spend) and another on the y-axis (website traffic), making the relationship, direction, and strength of correlation immediately visible. It's the standard chart for bivariate correlation analysis because it preserves individual data points rather than aggregating them.

Exam trap

The trap is choosing a line chart because both variables are numeric and time-ordered — candidates assume 'trend' means line chart, but correlation between two variables requires a scatter plot to show the joint distribution.

How to eliminate wrong answers

Option A is wrong because an area chart shows cumulative magnitude over a continuous dimension (usually time) and is used for part-to-whole or trend visualization, not correlation between two variables. Option C is wrong because a bar chart compares categorical values or aggregated magnitudes — it doesn't plot two continuous variables against each other. Option D is wrong because a line chart shows trends over a continuous dimension (typically time) and implies sequential connection between points, which is inappropriate for correlation analysis of two independent variables.

Full explanation →
100
MCQmedium

A business analyst wants to compare the proportion of total sales contributed by each product category in the current year. Which visualization is most suitable?

A.Pie chart
B.Scatter plot
C.Line chart
D.Histogram
AnswerA

A pie chart maps each category to a slice whose angle is proportional to its share of the whole, directly encoding the part-to-whole relationship the analyst needs. It satisfies the constraint of comparing each product category's contribution to total sales in a single, immediately readable view.

Why this answer

A pie chart is designed to show how a whole is divided into proportional parts, making it the natural fit for comparing each product category's share of total sales. Each slice's angle directly encodes the category's percentage contribution, which is exactly what the analyst needs. For a single-period composition question, pie charts communicate proportions intuitively.

Exam trap

DA0-002 often tests whether candidates over-apply pie charts to any categorical data; the trap is recognizing that 'proportion of total' specifically justifies a pie chart, while 'compare values' would not.

How to eliminate wrong answers

Option B is wrong because a scatter plot shows the relationship between two numeric variables and cannot represent parts of a whole. Option C is wrong because a line chart is for trends over a continuous axis like time, not for static proportional composition. Option D is wrong because a histogram displays the frequency distribution of a single continuous variable across bins, not category shares of a total.

Full explanation →
101
MCQeasy

A data analyst wants to show the sales trend for a product over the past 12 months. Which chart type is most appropriate?

A.Line chart
B.Bar chart
C.Pie chart
D.Histogram
AnswerA

A line chart plots a continuous metric against a time axis, so twelve monthly sales values appear as a trend line showing direction and seasonality. Other chart types, such as pie or bar, compare categories rather than continuous change over time.

Why this answer

A line chart is the most appropriate choice because it explicitly shows data points over a continuous time interval, making it ideal for visualizing the sales trend over 12 months. The x-axis represents time (months), and the y-axis represents sales values, allowing the audience to easily see upward, downward, or cyclical patterns. This aligns with the core principle of time-series visualization, where line charts excel at highlighting trends and changes over sequential periods.

Exam trap

The trap here is that candidates often confuse a histogram with a line chart because both use bars or lines to represent data, but a histogram is strictly for frequency distributions of continuous data, not for time-series trends.

How to eliminate wrong answers

Option B (Bar chart) is wrong because bar charts are better suited for comparing discrete categories or individual values, not for showing a continuous trend over time; they can obscure the sequential flow and make it harder to detect gradual changes. Option C (Pie chart) is wrong because pie charts display parts of a whole (proportions) at a single point in time, and they cannot represent a trend or time series across 12 months. Option D (Histogram) is wrong because histograms show the distribution of a continuous variable by binning data into intervals, not the progression of a single metric over time; using a histogram for a time series would misrepresent the data's temporal order.

Full explanation →
102
Multi-Selecthard

A data scientist is merging retail transaction data from online and in-store sources. Which THREE steps are required to ensure data consistency?

Select 3 answers
A.Ensure product IDs are standardized across sources
B.Convert all monetary amounts to a common currency
C.Remove all transactions with missing customer ID
D.Synchronize timestamps to a single time zone
E.Merge data using only store location
AnswersA, B, D

Standardising product IDs gives both sources a shared join key, satisfying the consistency requirement for merging online and in-store transactions. Without identical identifiers, the same product appears as distinct records, producing duplicate or unmatched rows during the merge.

Why this answer

Option A is correct because standardizing product IDs across online and in-store sources is essential for matching the same item across systems, preventing duplicate or mismatched records during the merge. Option B is correct because converting all monetary amounts to a common currency ensures that transaction values are comparable and can be aggregated without unit inconsistencies. Option D is correct because synchronizing timestamps to a single time zone aligns event times across sources, which is necessary for accurate chronological ordering and time-based joins.

Option C is not required because removing transactions with missing customer IDs would discard valid sales data and is a data-quality choice, not a consistency requirement. Option E is not required because merging on store location alone would ignore online transactions and other key fields, producing an incomplete and inconsistent dataset.

Exam trap

The trap is selecting data-cleaning actions (dropping null customer IDs) or weak join keys (store location) instead of the true consistency steps of standardizing IDs, currency, and time zones.

Full explanation →
103
Multi-Selecteasy

A company is implementing a centralized reporting layer to replace departmental spreadsheets. Which TWO benefits are most directly achieved?

Select 2 answers
A.Improved data lineage
B.Elimination of all data errors
C.Single version of truth
D.Reduced need for data governance
E.Faster report generation
AnswersA, C

A centralized reporting layer applies consistent transformations and documented source-to-target mappings, so every figure can be traced from report back to originating system. This satisfies the requirement to replace departmental spreadsheets, whose manual extracts break the chain of lineage.

Why this answer

Option A (Improved data lineage) is correct because a centralized reporting layer consolidates data from multiple sources into a governed pipeline, making it possible to trace data from its origin through transformations to the final report, which departmental spreadsheets cannot provide. Option C (Single version of truth) is correct because centralizing reporting ensures all departments consume the same curated, consistent data set rather than maintaining divergent spreadsheet copies, eliminating conflicting figures across the organization. Option B is incorrect because centralization reduces but cannot eliminate all data errors, which can still arise from source entry mistakes or transformation logic.

Option D is incorrect because centralization typically increases, not reduces, the need for data governance to define ownership, quality rules, and access controls. Option E is incorrect because faster report generation is not a guaranteed direct benefit; performance depends on architecture, query design, and infrastructure, and centralization can even add latency through ETL processes.

Exam trap

The trap is selecting benefits that sound plausible but are either impossible (elimination of all errors) or not direct outcomes (faster report generation).

Full explanation →
104
MCQhard

A data engineer needs to acquire data from a legacy mainframe system that does not support modern APIs or direct database connectivity. Which approach is most feasible?

A.Re-platform the mainframe to a modern system
B.Use a database gateway
C.Use FTP to transfer flat files
D.Manual data entry
AnswerC

FTP moves flat-file extracts from the mainframe, requiring only basic network file transfer rather than APIs or database drivers. The legacy system's lack of modern interfaces and direct connectivity makes this the feasible extraction route, with files parsed downstream.

Why this answer

FTP (File Transfer Protocol, RFC 959) is a widely supported, low-overhead method for transferring flat files (e.g., CSV, EBCDIC-encoded text) from legacy mainframe systems that lack modern APIs or direct database connectivity. Mainframes like IBM z/OS natively support FTP, allowing the data engineer to schedule periodic file exports without requiring system modernization or complex middleware.

Exam trap

The trap here is that candidates may assume a database gateway (Option B) is always the best integration approach, but the question explicitly denies direct database connectivity, making FTP the only practical option that leverages existing mainframe capabilities without major infrastructure changes.

How to eliminate wrong answers

Option A is wrong because re-platforming the mainframe to a modern system is a costly, high-risk, and time-consuming project that far exceeds the scope of a simple data acquisition task; it introduces unnecessary complexity and potential downtime. Option B is wrong because a database gateway typically requires the mainframe to support ODBC/JDBC or similar database connectivity protocols, which the question explicitly states is not available. Option D is wrong because manual data entry is error-prone, unscalable, and impractical for any reasonable volume of data, violating basic data integrity and efficiency requirements.

Full explanation →
105
MCQhard

In a multiple regression model with three predictors, the coefficient for one predictor is 5.2 with a p-value of 0.001. Which of the following is the best interpretation?

A.The predictor explains 5.2% of the variance in the dependent variable.
B.A one-unit increase in the predictor decreases the dependent variable by 5.2 units, on average.
C.The model is not a good fit because one predictor is significant.
D.The predictor has a statistically significant effect on the dependent variable, controlling for other variables.
AnswerD

A p-value of 0.001 falls below the 0.05 threshold, so the null hypothesis is rejected. The coefficient of 5.2 indicates the predictor's effect on the dependent variable while the other two predictors are held constant.

Why this answer

A coefficient of 5.2 with a p-value of 0.001 means that, holding the other predictors constant, a one-unit increase in this predictor is associated with a 5.2-unit increase in the dependent variable, and the effect is statistically significant at conventional thresholds (p < 0.05). The phrase 'controlling for other variables' is key in multiple regression — the coefficient represents the partial effect of this predictor given the others in the model.

Exam trap

The trap is misreading the coefficient as a proportion of variance explained (R²) or ignoring the sign — candidates must remember that a regression coefficient is a per-unit effect, not a percentage, and that its sign indicates direction.

How to eliminate wrong answers

Option A is wrong because the coefficient value (5.2) is not a percentage of variance explained — variance explained is measured by R², and the coefficient's magnitude depends on the units of the variables. Option B is wrong because the sign is positive (5.2), indicating an increase, not a decrease, in the dependent variable. Option C is wrong because a significant predictor is generally a sign of a useful model term, not evidence that the model is a poor fit — model fit is assessed via R², adjusted R², or F-statistics.

Full explanation →
106
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.

Full explanation →
107
MCQmedium

A marketing manager wants to visualize the conversion rate at each stage of a sales funnel, from leads to closed deals. The data shows the number of prospects at each stage. Which chart type is most appropriate for this pipeline analysis?

A.Treemap
B.Waterfall chart
C.Funnel chart
D.Stacked bar chart
AnswerC

A funnel chart plots sequential stages as progressively narrowing bars, so the declining prospect count from leads to closed deals is shown directly. This satisfies the pipeline analysis requirement to visualise conversion rate at each sales-funnel stage.

Why this answer

A funnel chart is specifically designed to show the progressive reduction of data as it moves through stages, making it ideal for visualizing conversion rates in a sales pipeline. It displays the number of prospects at each stage, with the width of each section representing the quantity, clearly illustrating drop-offs.

Exam trap

The trap is confusing funnel charts with waterfall charts, as both show progression, but waterfall is for cumulative financial effects, while funnel is for stage-wise reduction in a process.

How to eliminate wrong answers

Option A is wrong because a treemap displays hierarchical data as nested rectangles, which is not suitable for sequential stages. Option B is wrong because a waterfall chart shows cumulative effect of sequentially introduced positive or negative values, often for financial data, not for stage-by-stage conversion. Option D is wrong because a stacked bar chart compares parts of a whole across categories, but does not inherently show the sequential flow and drop-off of a funnel.

Full explanation →
108
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.

Full explanation →
109
MCQmedium

A company wants to determine if there is a significant difference in the average sales revenue between two different store layouts. They collect sales data from 30 stores with Layout A and 30 stores with Layout B. Which statistical test is most appropriate for comparing the means of these two independent groups?

A.ANOVA
B.Chi-square test
C.Paired t-test
D.Two-sample t-test
AnswerD

A two-sample t-test compares the means of two independent groups when the population standard deviation is unknown, which fits the 30 Layout A and 30 Layout B stores. It determines whether the observed revenue difference is statistically significant.

Why this answer

The scenario compares the means of two independent groups (Layout A vs. Layout B) on a continuous outcome (sales revenue), which is precisely what the two-sample t-test is designed for. With 30 stores per group, the sample size is adequate for the t-test's assumptions, and the groups are independent (different stores).

This is the standard test for a two-group mean comparison.

Exam trap

The trap is confusing the two-sample t-test with the paired t-test or ANOVA — candidates must check whether the groups are independent (two-sample), matched (paired), or more than two (ANOVA).

How to eliminate wrong answers

Option A is wrong because ANOVA is used to compare means across three or more groups; with only two groups, the two-sample t-test is the appropriate and more specific choice. Option B is wrong because the chi-square test is for categorical data (comparing observed vs. expected frequencies), not for comparing continuous means like sales revenue. Option C is wrong because the paired t-test requires matched or repeated measurements on the same subjects — here the stores in Layout A and Layout B are different, independent groups.

Full explanation →
110
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.

Full explanation →
111
MCQmedium

A sales manager wants to display the contribution of each product category to total revenue, with a maximum of six categories. Which chart type is most suitable?

A.Histogram
B.Pie chart
C.Box plot
D.Scatter plot
AnswerB

A pie chart directly encodes each category's share of the whole, satisfying the requirement to show contribution to total revenue. With a maximum of six slices, readability remains intact, since pie charts degrade beyond roughly seven segments. Each slice's angle maps proportionally to its revenue percentage, making part-to-whole comparison immediate.

Why this answer

A pie chart is ideal for showing the contribution of each part to a whole, especially when the number of categories is small (six or fewer). It visually represents each category's proportion of total revenue, making it easy to compare relative sizes.

Exam trap

The trap here is confusing charts that show composition (pie) with those that show distribution (histogram, box plot) or relationship (scatter). Candidates might pick histogram because it also deals with frequencies, but it does not show parts of a whole.

How to eliminate wrong answers

Option A is wrong because a histogram is used to show the distribution of a single continuous variable, not parts of a whole. Option C is wrong because a box plot displays the distribution of a dataset through quartiles, not contributions to a total. Option D is wrong because a scatter plot shows the relationship between two continuous variables, not compositional breakdowns.

Full explanation →
112
MCQhard

A database has a table 'Orders' with columns OrderID (PK), CustomerID, OrderDate, and a table 'OrderDetails' with OrderID (FK), ProductID, Quantity. To ensure that every OrderID in OrderDetails exists in Orders, which integrity constraint is enforced?

A.Entity integrity
B.Domain integrity
C.User-defined integrity
D.Referential integrity
AnswerD

Referential integrity guarantees that every foreign key value in OrderDetails matches an existing primary key in Orders, preventing orphaned detail rows. This directly enforces the stem's requirement that each OrderID in OrderDetails exists in the parent Orders table.

Why this answer

Referential integrity ensures that a foreign key value in a child table (OrderDetails.OrderID) must match an existing primary key value in the parent table (Orders.OrderID) or be NULL. This constraint prevents orphaned records and maintains consistent relationships between tables. Since OrderDetails.OrderID is defined as a foreign key referencing Orders, the database enforces referential integrity to guarantee every OrderID in OrderDetails exists in Orders.

Exam trap

The trap here is confusing the four integrity types—candidates often pick 'entity integrity' because it sounds like it relates to keys, but entity integrity is specifically about primary keys, not foreign keys.

How to eliminate wrong answers

Option A is wrong because entity integrity concerns primary keys—ensuring they are unique and not NULL—not foreign key relationships. Option B is wrong because domain integrity restricts column values to a defined domain (data type, range, format), not cross-table references. Option C is wrong because user-defined integrity covers business rules implemented via triggers or stored procedures, not the standard foreign key constraint described.

Full explanation →
113
Multi-Selecthard

A data analyst is troubleshooting a map visualization that shows null values for some regions. Which TWO actions should the analyst take to resolve the issue?

Select 2 answers
A.Check that latitude and longitude fields are properly geocoded.
B.Verify that the data source includes all region names.
C.Add a filter to exclude null values.
D.Change the mark type from Map to Pie.
E.Remove the color encoding from profit.
AnswersA, B

Map visualisations plot coordinates, so null regions arise when latitude and longitude values are missing or ungeocoded. Verifying geocoding ensures each region resolves to a valid point, satisfying the requirement to eliminate nulls caused by absent spatial data rather than missing region labels.

Why this answer

Option A is correct because a map visualization plots marks using geographic coordinates, so if latitude and longitude fields are missing, malformed, or not properly geocoded, the tool cannot place those regions and renders null or blank locations. Option B is correct because if the underlying data source lacks the region names (or uses names that don't match the geocoding dictionary), the map cannot resolve those regions to coordinates, again producing null values. Option C is wrong because filtering out nulls merely hides the affected regions rather than fixing the missing geographic data, so the visualization would still be incomplete.

Option D is wrong because changing the mark type to Pie abandons the map entirely and does not address the geocoding or data completeness problem. Option E is wrong because removing the color encoding from profit only affects color, not the missing geographic positions that cause the null regions.

Full explanation →
114
MCQmedium

While profiling a customer dataset, an analyst finds that the 'country' column contains values including 'USA', 'United States', 'U.S.A.', and 'US' for the same nation, plus 'usa ' with trailing whitespace. Reports grouped by country show fragmented counts. Which preparation step resolves this issue?

A.Impute the mode of the column for every row to make all values identical.
B.Apply standardization by trimming whitespace and mapping all variants to a single canonical country code.
C.Remove all rows containing any country value that is not 'USA' to enforce consistency.
D.Increase the column length to accommodate the longest variant string.
AnswerB

Standardization collapses the synonymous spellings and whitespace variants into one canonical representation, which is exactly what eliminates the fragmented grouping. Mapping to a controlled code such as ISO 3166 also makes future joins and comparisons reliable. Trimming handles the formatting defect while the mapping handles the semantic equivalence, so both parts of the problem are addressed together.

Why this answer

The column is not missing data; it holds the same nation under several spellings and spacing. Standardizing with trimming plus a canonical mapping such as an ISO code unifies those variants so grouped counts consolidate correctly. Deleting rows, widening the column, or imputing a single value either destroys data or leaves the fragmentation untouched.

Exam trap

The trap here is mistaking a representation inconsistency for missing or invalid data, which leads to deletion or imputation instead of standardization.

Full explanation →
115
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.

Full explanation →
116
MCQmedium

An analyst creates a bar chart showing average sales by region. They want to ensure that the y-axis starts at zero to avoid misleading interpretation. This practice aligns with which dashboard design principle?

A.Appropriate precision
B.Visual hierarchy
C.Clear labels and titles
D.Data-ink ratio
AnswerA

Starting axes at zero avoids misleading precision in bar lengths.

Why this answer

Starting the y-axis at zero is a fundamental practice to ensure that the visual representation of data (bar heights) accurately reflects the actual values, preventing exaggeration or minimization of differences. This principle directly supports 'Appropriate Precision' by maintaining the integrity of the data visualization and avoiding misleading interpretations, which is a key consideration in dashboard design.

Exam trap

The trap here is confusing 'Appropriate Precision' (a data integrity principle) with 'Visual Hierarchy' (a layout principle) or 'Data-Ink Ratio' (a minimalist design principle).

How to eliminate wrong answers

Option B (Visual hierarchy) is wrong because visual hierarchy refers to the arrangement of elements to guide the viewer's eye by importance (e.g., size, color, position), not to the technical scaling of axes. Option C (Clear labels and titles) is wrong because while labels and titles are crucial for context, they do not address the specific mathematical requirement of axis scaling to prevent distortion. Option D (Data-ink ratio) is wrong because data-ink ratio focuses on minimizing non-data ink (e.g., gridlines, borders) to maximize clarity, not on the starting point of the y-axis.

Full explanation →
117
MCQmedium

A data analyst is examining a dataset of customer orders and notices that the 'order_total' column contains values ranging from $5 to $50,000, with most orders under $200. The analyst wants to reduce the influence of extreme values on a linear regression model predicting customer lifetime value. Which technique should the analyst apply?

A.Convert order_total to a categorical variable by binning into deciles.
B.Standardize the order_total variable to have a mean of 0 and standard deviation of 1.
C.Remove all orders with a total greater than $1,000 from the dataset.
D.Apply a logarithmic transformation to the order_total variable.
AnswerD

A logarithmic transformation compresses the scale of large values, reducing the leverage of extreme high order totals on the regression model. This makes the relationship between order_total and the target more linear and stabilizes variance, which is appropriate when data is positively skewed with outliers.

Why this answer

The logarithmic transformation is effective because it compresses the range of large values, making the distribution more symmetric and reducing the influence of outliers on the regression model. Standardization, removal, or binning either do not address the skewness or introduce other issues such as information loss or bias.

Exam trap

The trap here is assuming that standardization alone will handle outliers, when it actually preserves their relative extremity.

Full explanation →
118
MCQmedium

A data analyst is working with a dataset that contains a 'salary' column with extreme outliers. Before performing a linear regression analysis, the analyst wants to reduce the impact of these outliers. Which technique should be applied?

A.One-hot encoding
B.Standardization
C.Binning
D.Winsorizing
AnswerD

Winsorizing replaces extreme values with the nearest non-extreme value, typically at a specified percentile (e.g., 5th and 95th). This reduces the influence of outliers without removing them, preserving the sample size. It is suitable for linear regression as it limits the leverage of extreme points while maintaining the data distribution's shape.

Why this answer

Winsorizing is the correct technique because it caps extreme values at a specified percentile, reducing their influence while retaining all data points. For linear regression, outliers can disproportionately affect the slope and intercept, so limiting their impact is crucial. Winsorizing is preferable to deletion when sample size is limited, and it preserves the order of values, making it a robust choice for this scenario.

Exam trap

The trap here is thinking that standardization or normalization reduces outlier impact, when in fact they only change the scale and do not address the extreme values themselves.

Full explanation →
119
MCQmedium

A logistics company receives GPS tracking data from fleet vehicles at 1-second intervals via a cellular network. The data is used to optimize routes and monitor driver behavior. Recently, the data acquisition system has been missing updates for some vehicles when they pass through tunnels or remote areas. The data team notices gaps during these periods. The company needs a solution to ensure near-real-time data continuity. What should they do?

A.Use a hybrid approach that combines cellular and Wi-Fi networks
B.Implement a store-and-forward mechanism that buffers data on the vehicle's onboard unit and uploads when connectivity resumes
C.Increase the frequency of data transmission to every 0.5 seconds
D.Switch to a satellite-based GPS system
AnswerB

Store-and-forward buffers readings on the onboard unit during tunnel or remote-area outages, then uploads the backlog once cellular connectivity returns. This preserves near-real-time continuity by preventing permanent data gaps, unlike simply retrying requests that fail while the vehicle remains disconnected.

Why this answer

A store-and-forward mechanism buffers GPS data locally on the vehicle's onboard unit during connectivity loss (e.g., in tunnels) and automatically uploads the backlog when cellular connectivity resumes. This ensures data continuity without requiring real-time transmission, directly addressing the intermittent connectivity issue while maintaining near-real-time updates.

Exam trap

The trap here is that candidates confuse the data source (GPS) with the transmission method, thinking satellite GPS solves connectivity issues, when the real problem is the cellular network's coverage gaps, not the positioning technology.

How to eliminate wrong answers

Option A is wrong because Wi-Fi networks are not suitable for fleet vehicles in motion; they have limited range and are not available in tunnels or remote areas, so combining them with cellular does not solve the core problem of coverage gaps. Option C is wrong because increasing transmission frequency to 0.5 seconds would exacerbate data loss during connectivity gaps and increase bandwidth/cost without addressing the root cause of missing updates. Option D is wrong because switching to satellite-based GPS only changes the positioning source, not the data transmission method; the vehicle still needs a network to send data, and satellite communication (e.g., Iridium) is expensive, high-latency, and not typically used for high-frequency GPS telemetry in logistics.

Full explanation →
120
MCQhard

A time series dataset has several missing months of data. Which chart type will present the most honest picture of the trend?

A.Area chart with interpolation
B.Line chart with gaps for missing months
C.Bar chart with zero values for missing months
D.Scatter plot with connected lines
AnswerB

Omitting missing months entirely would fabricate continuity, implying data that was never collected. Leaving visible gaps preserves the true temporal axis, so viewers see exactly where records are absent rather than reading an interpolated or misleading trend across those months.

Why this answer

A line chart with gaps for missing months is the most honest representation because it visually signals that data is absent rather than fabricating continuity. Leaving gaps preserves the integrity of the trend and prevents viewers from drawing false conclusions about the missing periods.

Exam trap

DA0-002 often tests the distinction between missing data and zero, and whether candidates understand that interpolation can be a form of data fabrication rather than a fix.

How to eliminate wrong answers

Option A is wrong because area-chart interpolation invents values for missing months, creating a smooth trend that never actually occurred and misleading decision-makers. Option C is wrong because plotting zero for missing months conflates 'no data' with 'value of zero', which can dramatically distort averages and trend lines. Option D is wrong because a scatter plot with connected lines still draws a continuous line across the missing period, implying data exists where it does not.

Full explanation →
121
MCQhard

A data analyst is building a report that will be distributed as a PDF to stakeholders who will view it on various devices, including smartphones. The report includes several charts with small text labels and thin lines. Which action should the analyst take to ensure the charts remain legible on smaller screens?

A.Increase the font size of all text labels and use thicker lines.
B.Embed the charts as high-resolution images and rely on zooming.
C.Use a 3D effect on the charts to make them stand out.
D.Convert all charts to tables with detailed numbers.
AnswerA

Increasing font size and line thickness improves legibility on small screens by making text and graphical elements easier to see without zooming. Small text and thin lines can become illegible when scaled down on a smartphone. This adjustment ensures that the charts remain readable across devices, which is essential for effective communication.

Why this answer

For PDFs viewed on smartphones, small text and thin lines can become illegible. Increasing font size and line thickness ensures that charts are readable without zooming. This proactive design choice accommodates smaller screens and diverse viewing conditions, maintaining the report's effectiveness across devices.

Exam trap

The trap here is assuming that high-resolution images or 3D effects will solve legibility issues, but these either require user action or degrade readability.

Full explanation →
122
MCQmedium

A retail company wants to test whether a new website layout increases the conversion rate compared to the current layout. They randomly assign visitors to either the control or treatment group. Which statistical test is most appropriate to compare the conversion rates?

A.Two-sample t-test
B.Chi-square test
C.ANOVA
D.Logistic regression
AnswerB

Conversion rate is a binary outcome (converted or not) across two independent groups, so the chi-square test compares observed versus expected frequencies in a contingency table. It satisfies the stem's requirement to test whether the new layout's conversion rate differs from the control.

Why this answer

The outcome variable is conversion (yes/no), a categorical binary variable, and the predictor is group (control vs treatment), also categorical. The chi-square test of independence is designed to compare observed versus expected frequencies across categories, making it the correct choice for comparing two conversion rates.

Exam trap

DA0-002 often tests the distinction between tests for means (t-test, ANOVA) and tests for proportions/frequencies (chi-square) — candidates pick t-test because they see 'two groups' and forget the outcome is binary, not continuous.

How to eliminate wrong answers

Option A is wrong because a two-sample t-test compares means of a continuous variable, not proportions of a binary outcome. Option C is wrong because ANOVA compares means across three or more groups and still assumes a continuous dependent variable. Option D is wrong because logistic regression models the probability of a binary outcome as a function of predictors — it can be used, but it is not the most appropriate simple test for comparing two proportions; chi-square is the standard hypothesis test for this design.

Full explanation →
123
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.

Full explanation →
124
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.

Full explanation →
125
MCQhard

A data scientist builds a logistic regression model to predict customer churn (yes/no). The model outputs a probability of 0.75 for a particular customer. Which of the following best describes this output?

A.The customer will definitely churn.
B.There is a 75% chance the customer will churn.
C.The odds of churning are 0.75 to 1.
D.The model is 75% accurate.
AnswerB

Logistic regression outputs a probability between 0 and 1 for the positive class. A value of 0.75 means the model estimates a 75% probability that this customer will churn, expressed as a likelihood rather than a certainty.

Why this answer

The output of a logistic regression model is a probability between 0 and 1. A value of 0.75 means the model estimates a 75% probability that the customer will churn (the positive class). This is a probabilistic prediction, not a certainty.

Exam trap

DA0-002 often tests the interpretation of logistic regression output, confusing probability with odds or accuracy. Candidates might think 0.75 means 75% accuracy or odds of 0.75 to 1.

How to eliminate wrong answers

Option A is wrong because the model outputs a probability, not a definitive prediction; 0.75 does not mean the customer will definitely churn. Option C is wrong because the output is a probability, not odds; odds would be p/(1-p), which here is 0.75/0.25 = 3 to 1. Option D is wrong because the output is not a measure of model accuracy; accuracy is a performance metric computed over many predictions, not a single output.

Full explanation →
126
MCQmedium

A company's database has a table 'orders' with columns: order_id, customer_id, order_date, and total_amount. A data analyst needs to identify customers who have placed more than 5 orders in the past year. Which data concept should be used to group orders by customer and count them?

A.Joining with other tables
B.Filtering with WHERE clause
C.Sorting with ORDER BY
D.Aggregation with GROUP BY
AnswerD

Aggregation with GROUP BY satisfies the requirement to group orders by customer_id and count them. GROUP BY collapses rows sharing a customer_id into single groups, then COUNT() tallies each customer's orders. Filtering with HAVING COUNT(*) > 5 after grouping identifies those exceeding five orders in the past year, which WHERE cannot do on aggregates.

Why this answer

The requirement to count orders per customer requires grouping rows by customer_id and then applying a count function. The GROUP BY clause in SQL aggregates rows that share a common value (customer_id) into summary rows, and the COUNT function tallies the number of orders per group. This is the standard approach for such 'per-customer' aggregations.

Exam trap

The trap here is that candidates confuse filtering (WHERE) with aggregation (GROUP BY), thinking that a WHERE clause alone can count orders per customer, when in fact WHERE only filters rows and cannot produce grouped counts.

How to eliminate wrong answers

Option A is wrong because joining with other tables merges columns from multiple tables but does not group or count rows; it would not produce a count of orders per customer. Option B is wrong because filtering with a WHERE clause restricts rows before any grouping but does not aggregate or count; it cannot produce a count of orders per customer. Option C is wrong because sorting with ORDER BY only arranges the result set order and has no effect on grouping or counting rows.

Full explanation →
127
MCQmedium

A data analyst at a regional bank is examining monthly account balances for 5,000 customers. The distribution is strongly right-skewed because a small number of high-net-worth clients hold very large balances. The analyst must report a measure of central tendency that best represents the typical customer without being pulled upward by those few extreme accounts. Which measure should the analyst report?

A.The arithmetic mean of the monthly balances.
B.The standard deviation of the monthly balances.
C.The median of the monthly balances.
D.The range between the minimum and maximum monthly balances.
AnswerC

The median is the middle value when balances are ordered, so it depends only on position and is unaffected by how large the extreme accounts become. For a right-skewed distribution it sits closer to the bulk of customers and therefore better represents a typical balance. This is exactly the robust measure of central tendency the analyst needs when outliers would distort the mean.

Why this answer

With a strong right skew driven by a few very large balances, the mean is pulled upward while the median stays anchored near the middle of the ordered data. Because the request is for a representative central value that resists outliers, the median is the appropriate choice. Standard deviation and the range describe dispersion, not central tendency, so they cannot answer the question.

Exam trap

The trap here is defaulting to the mean because it is familiar, without recognizing that extreme values in a skewed distribution drag it away from the typical observation.

Full explanation →
128
MCQmedium

A retail company is migrating its on-premises data warehouse to a cloud data warehouse. The current ETL process extracts data from a transactional database (SQL Server) and a web analytics system (JSON logs). The ETL runs nightly and takes 6 hours. The business requires that the new cloud warehouse support real-time reporting with data latency of less than 15 minutes. The data engineer proposes using change data capture (CDC) from the SQL Server database and streaming the JSON logs via a message queue. However, management is concerned about cost and complexity. The engineer must design a solution that meets the latency requirement while minimizing operational overhead. Which approach should the engineer recommend?

A.Export the SQL Server data to flat files every 15 minutes and use a cloud storage trigger to load
B.Continue with nightly batch loads but increase the frequency to every hour
C.Implement CDC for the SQL Server database and stream the JSON logs via a message queue to the cloud warehouse
D.Use a data virtualization tool to query the source systems directly without moving data
AnswerC

CDC captures only changed rows from SQL Server, and a message queue streams JSON logs continuously, cutting latency from six hours to under fifteen minutes. This satisfies the sub-15-minute requirement while avoiding full nightly batch reloads, keeping operational overhead lower than custom polling scripts.

Why this answer

CDC captures only changed rows from SQL Server, minimizing data volume and enabling near-real-time ingestion, while streaming JSON logs via a message queue (e.g., Apache Kafka or Amazon Kinesis) provides sub-15-minute latency. This combination meets the latency requirement without the overhead of full batch exports or complex virtualization, addressing management's cost and complexity concerns.

Exam trap

The trap here is that candidates may choose Option A or D because they seem simpler, but they fail to meet the strict latency requirement or introduce hidden operational complexity, while Option C's CDC and streaming approach is the only one that balances low latency with minimal overhead.

How to eliminate wrong answers

Option A is wrong because exporting SQL Server data to flat files every 15 minutes introduces latency from file generation, cloud storage upload, and trigger-based loading, which can easily exceed the 15-minute requirement and adds operational overhead for file management. Option B is wrong because increasing nightly batch loads to hourly still results in up to 60-minute latency, failing the 15-minute requirement, and does not address the need for real-time streaming of JSON logs. Option D is wrong because data virtualization queries source systems directly, which can cause performance degradation on the transactional SQL Server and web analytics system, and does not provide a persistent, low-latency data pipeline to the cloud warehouse.

Full explanation →
129
MCQmedium

A data analyst at a marketing firm is tasked with segmenting customers based on their purchasing behavior. The dataset contains 10,000 customers with features such as annual spend, frequency of purchases, recency of last purchase, and average order value. The analyst decides to use k-means clustering. After standardizing the features, the analyst runs k-means with k=3, k=4, and k=5, and computes the silhouette score for each: k=3: 0.45, k=4: 0.52, k=5: 0.48. The analyst also plots the elbow curve and observes that the within-cluster sum of squares (WCSS) decreases sharply from k=2 to k=4, then levels off. Based on these results, what is the most appropriate number of clusters?

A.k=4
B.k=2
C.k=3
D.k=5
AnswerA

k=4 yields the highest silhouette score (0.52), indicating the tightest, best-separated clusters, and the elbow curve's WCSS levelling off after k=4 corroborates this. Both diagnostics converge, satisfying the stem's requirement to select the most appropriate cluster count.

Why this answer

The silhouette score is highest at k=4 (0.52), indicating that clusters are well-separated and cohesive. The elbow curve shows WCSS decreasing sharply up to k=4 and then leveling off, suggesting that k=4 captures the optimal trade-off between model complexity and variance explained. Together, these metrics point to k=4 as the most appropriate number of clusters.

Exam trap

The trap here is that candidates might rely solely on the elbow curve and pick k=3 or k=5, ignoring the silhouette score which directly measures cluster quality and clearly favors k=4.

How to eliminate wrong answers

Option B (k=2) is wrong because the elbow curve shows a sharp decrease in WCSS from k=2 to k=4, meaning k=2 would underfit the data and miss meaningful segmentation. Option C (k=3) is wrong because its silhouette score (0.45) is lower than k=4 (0.52), indicating poorer cluster separation and cohesion. Option D (k=5) is wrong because its silhouette score (0.48) is lower than k=4, and the elbow curve shows WCSS leveling off after k=4, so adding a fifth cluster introduces unnecessary complexity without significant improvement.

Full explanation →
130
Multi-Selectmedium

Which TWO of the following chart types are appropriate for showing the distribution of a continuous variable? (Choose 2.)

Select 2 answers
A.Box plot
B.Bar chart
C.Pie chart
D.Line chart
E.Histogram
AnswersA, E

A box plot displays a continuous variable's distribution through its median, quartiles, and whiskers, showing spread, central tendency, and outliers. This makes it appropriate for visualising distribution, unlike charts designed for categorical comparison or part-to-whole relationships.

Why this answer

A box plot (option A) is correct because it summarizes the distribution of a continuous variable using the median, quartiles, and potential outliers, directly revealing spread and skewness. A histogram (option E) is also correct because it bins a continuous variable into intervals and displays the frequency distribution, showing shape, center, and spread. Bar charts (option B) are for comparing categorical frequencies, not continuous distributions.

Pie charts (option C) show proportions of a whole for categorical data. Line charts (option D) are used to display trends over time or ordered sequences, not the distribution of a single continuous variable.

Exam trap

The trap here is that candidates often confuse bar charts with histograms, mistakenly thinking bar charts can show continuous distributions, but bar charts require categorical x-axis values and have gaps between bars, while histograms use continuous intervals with no gaps.

Full explanation →
131
MCQmedium

A data analyst is building a dashboard that includes a filter for 'Region'. The dashboard also contains a table showing sales by product category. The analyst wants to ensure that when a user selects a region from the filter, the table updates to show only sales for that region. Which feature should the analyst configure?

A.Action filter
B.Calculated field
C.Data blending
D.Parameter
AnswerA

An action filter allows one visual to filter another when a user interacts with it. In this case, selecting a region in the filter should filter the table. Action filters are designed for this kind of interactivity, enabling dynamic updates based on user selections. Configuring an action filter ensures the table reflects the chosen region.

Why this answer

An action filter is the correct feature to enable cross-visual filtering. It allows a selection in one visual (the region filter) to dynamically filter another visual (the table). This creates an interactive dashboard where users can explore data by region without manually adjusting multiple filters.

Exam trap

The trap here is confusing action filters with parameters or calculated fields, which are used for different purposes in dashboard interactivity.

Full explanation →
132
MCQmedium

A data analyst is creating a report that shows the percentage of total sales contributed by each product category. The categories are: Electronics (45%), Clothing (30%), Home Goods (15%), and Toys (10%). Which chart type is most effective for displaying this information?

A.Histogram
B.Line chart
C.Pie chart
D.Scatter plot
AnswerC

A pie chart is ideal for showing parts of a whole when there are a small number of categories. With four categories, each slice clearly represents the proportion of total sales, and the percentages sum to 100%, making it easy to compare the relative contributions at a glance.

Why this answer

A pie chart is the most effective for showing the percentage contribution of each product category to total sales because it visually represents parts of a whole. With only four categories, the slices are easy to compare, and the chart immediately conveys the relative proportions, making it suitable for this composition analysis.

Exam trap

The trap here is assuming that a bar chart is always better, but for part-to-whole relationships with few categories, a pie chart is more intuitive and directly shows proportions.

Full explanation →
133
MCQhard

A data analyst is building a time series forecasting model for monthly sales data. The analyst observes that the data has a clear upward trend and a seasonal pattern that repeats every 12 months. After differencing the data once to remove the trend, the analyst notices that the seasonal pattern remains. Which of the following should the analyst do next to properly model the data?

A.Include a moving average term of order 12.
B.Fit a non-seasonal ARIMA model with only autoregressive terms.
C.Apply a seasonal difference with lag 12.
D.Apply a second round of non-seasonal differencing.
AnswerC

A seasonal difference with lag 12 subtracts the value from the same month in the previous year, effectively removing the seasonal pattern. This is the standard approach when seasonality persists after non-seasonal differencing. It aligns the data for modeling with seasonal ARIMA (SARIMA) components, allowing the analyst to capture both trend and seasonality.

Why this answer

After removing the trend with non-seasonal differencing, the persistent seasonal pattern indicates the need for seasonal differencing. Taking a difference at lag 12 removes the yearly seasonal effect, making the series stationary in both trend and seasonality. This step is crucial before fitting a SARIMA model, which can then include seasonal autoregressive and moving average terms to capture the remaining structure.

Exam trap

The trap here is applying another non-seasonal difference or adding a moving average term instead of using seasonal differencing to address the recurring pattern.

Full explanation →
134
MCQmedium

A data analyst is tasked with extracting data from a legacy system that outputs fixed-width text files. The analyst needs to parse these files into a structured format. Which tool or method is most appropriate for this task?

A.A spreadsheet application
B.An ETL tool with a graphical interface
C.A scripting language such as Python
D.SQL
AnswerC

A scripting language such as Python parses fixed-width files by slicing each line at defined column positions, handling the absence of delimiters. This directly addresses the fixed-width constraint, unlike delimiter-based tools that cannot infer field boundaries.

Why this answer

Python is the most appropriate choice because fixed-width text files require precise column slicing based on character positions, which Python's string slicing and libraries like `struct` or `pandas.read_fwf` handle natively. Unlike graphical ETL tools or spreadsheets, Python provides programmatic control to define exact field widths, handle edge cases like missing delimiters, and process large files efficiently without manual intervention.

Exam trap

The trap here is that candidates assume a graphical ETL tool is always the best for data extraction, but the question specifically tests the ability to handle unstructured or semi-structured legacy formats where scripting provides the necessary precision and automation.

How to eliminate wrong answers

Option A is wrong because spreadsheet applications like Excel are designed for delimited data (e.g., CSV) and lack built-in functionality to parse fixed-width columns without manual column splitting, which is error-prone and impractical for large datasets. Option B is wrong because while ETL tools can parse fixed-width files, they typically require defining column widths in a graphical interface, which is less flexible and harder to automate than a scripting language for legacy systems with inconsistent formatting. Option D is wrong because SQL operates on structured data within a database and cannot directly parse raw fixed-width text files; it would require the data to be pre-processed into a table format first.

Full explanation →
135
MCQhard

A data analyst is building a predictive model to forecast customer churn. The dataset includes a categorical feature 'payment_method' with categories: credit card, debit card, PayPal, and bank transfer. The analyst decides to use one-hot encoding. After encoding, the analyst notices that the model's performance on the training set is excellent but poor on the test set. Which issue is most likely contributing to this problem?

A.The one-hot encoding caused data leakage from the test set into the training set.
B.The one-hot encoding failed to capture the ordinal relationship among payment methods.
C.The one-hot encoding introduced multicollinearity among the payment method dummy variables.
D.The model is overfitting due to high dimensionality from one-hot encoding combined with a small dataset.
AnswerD

One-hot encoding increases dimensionality, especially if the categorical feature has many categories. With a small dataset, this can lead to overfitting because the model may learn noise specific to the training set. The symptom of excellent training performance but poor test performance is classic overfitting. High dimensionality from encoding can exacerbate this, particularly if the model is complex. Thus, this is the most likely issue.

Why this answer

Overfitting is indicated by strong training performance and weak test performance. One-hot encoding expands the feature space, and with a small dataset, this can lead to a model that memorizes training noise. The other options do not directly explain overfitting: multicollinearity affects interpretation, data leakage would inflate both training and test scores, and payment methods are nominal so ordinality is irrelevant.

Thus, high dimensionality from encoding is the most plausible cause.

Exam trap

The trap here is assuming that any encoding issue causes overfitting, when in fact the primary driver is often the increased dimensionality relative to sample size.

Full explanation →
136
MCQeasy

A marketing analyst is building a dashboard that groups customers by the state listed in their billing address so the sales team can compare performance across regions. The analyst retrieves the raw address data stored in a single text column. Which data type classification best describes the state field as the analyst intends to use it?

A.Ordinal
B.Ratio
C.Interval
D.Nominal
AnswerD

Nominal data labels categories with no inherent order, and U.S. states function purely as distinct group labels for comparing regional sales. Nothing about the state field implies a ranking, distance, or mathematical relationship between one state and another, so treating it as nominal is appropriate for grouping and counting customers in each region.

Why this answer

State names are categorical labels used to segment customers into groups, and there is no ranking or numeric distance between them. That makes the field nominal for this dashboard. Ordinal, interval, and ratio all require either an inherent order or numeric measurement properties that state labels do not have, so they cannot apply to this grouping task.

Exam trap

The trap here is assuming that because states are often sorted alphabetically or by sales totals, the field itself is ordinal rather than nominal.

Full explanation →
137
Multi-Selectmedium

A data analyst is creating a weekly KPI email for executives. Which TWO attributes are most important for this type of report?

Select 2 answers
A.Allowing interactive drill-down
B.Providing an executive summary with key metrics
C.Including raw data tables
D.Including real-time data
E.Automating delivery on a fixed schedule
AnswersB, E

Executives need the headline numbers and their meaning immediately, without wading through raw data. An executive summary with key metrics satisfies this by front-loading the KPI results and context, matching the weekly cadence and senior audience's need for rapid, decision-ready insight.

Why this answer

Scheduled reports for executives should be concise and automated, with clear headline metrics and context.

Full explanation →
138
MCQmedium

A data analyst has built a dashboard that tracks monthly website traffic. The dashboard currently uses a line chart to show the trend of total visits over time. The marketing team now wants to see how each of four traffic sources (organic, paid, social, referral) contributes to the total each month, while still being able to see the overall trend. Which chart type best meets this requirement?

A.Scatter plot
B.Stacked area chart
C.Pie chart
D.Bar chart
AnswerB

A stacked area chart plots each traffic source as a layer stacked on top of the others, so the total height represents overall visits. This shows both the overall trend and each source's contribution over time. It is ideal for showing how parts contribute to a whole across a continuous time axis, exactly matching the marketing team's requirement.

Why this answer

A stacked area chart is designed to show how multiple components contribute to a total over a continuous time period. It allows the viewer to see both the overall trend and the relative contribution of each traffic source. Other chart types either cannot show time trends or cannot show composition effectively.

Exam trap

The trap here is assuming that a pie chart can show trends over time because it displays proportions.

Full explanation →
139
Multi-Selectmedium

A data analyst is creating a dashboard for a retail company. Which TWO of the following are considered Key Performance Indicators (KPIs) tied to strategic objectives?

Select 2 answers
A.Average handle time per call
B.Number of products in inventory
C.Daily number of customer service calls
D.Year-over-year revenue growth
E.Customer retention rate
AnswersD, E

Year-over-year revenue growth compares revenue across matching periods, directly measuring progress against a strategic financial objective such as sustained expansion. That alignment with long-term goals distinguishes a genuine KPI from operational metrics like page views or support ticket counts.

Why this answer

Year-over-year revenue growth (D) is a strategic KPI because it directly measures the company's financial performance against prior periods, showing whether long-term growth objectives are being met. Customer retention rate (E) is also a strategic KPI since retaining existing customers reflects loyalty, satisfaction, and sustainable revenue, which are core strategic goals for a retail business. In contrast, average handle time per call (A) is an operational efficiency metric for support teams, not a strategic objective.

Number of products in inventory (B) is an inventory management measure, and daily number of customer service calls (C) is a volume/activity metric; neither directly indicates progress toward strategic business goals.

Exam trap

DA0-002 often tests the confusion between operational metrics and strategic KPIs, causing candidates to select tactical measures like call volume instead of strategic indicators like revenue growth.

Full explanation →
140
MCQhard

A data analyst is presenting a time-series chart of monthly sales to executives. The sales dropped sharply in March due to a one-time supply chain disruption. Which storytelling technique would best help the audience understand this anomaly?

A.Add an annotation explaining the supply chain disruption
B.Remove the March data point to avoid confusion
C.Use a different chart type to hide the drop
D.Use a moving average to smooth the drop
AnswerA

An annotation places explanatory text directly on the chart at March, tying the sharp drop to the one-time supply chain disruption. This contextualises the anomaly in place, so executives see cause and effect without a separate verbal explanation.

Why this answer

Adding an annotation directly on the chart provides immediate context for the March sales drop, allowing executives to understand the anomaly without leaving the visualization. This technique follows the principle of 'contextual annotation' in data storytelling, where key events are marked to prevent misinterpretation of trends. It preserves data integrity while clarifying the cause, which is essential for accurate decision-making.

Exam trap

The trap here is that candidates may choose to smooth or remove the anomaly (options B or D) to make the chart look cleaner, failing to recognize that ethical data storytelling requires explaining, not hiding, significant events.

How to eliminate wrong answers

Option B is wrong because removing the March data point distorts the dataset, hiding a legitimate event and potentially leading to incorrect trend analysis or forecasting. Option C is wrong because using a different chart type to hide the drop is deceptive and violates ethical data presentation standards, as it obscures a significant anomaly rather than explaining it. Option D is wrong because a moving average smooths out short-term fluctuations, which would mask the sharp drop and prevent the audience from recognizing the one-time disruption, defeating the purpose of anomaly explanation.

Full explanation →
141
MCQmedium

A data analyst is profiling a dataset of customer orders. The 'order_date' column contains dates in various formats, including 'YYYY-MM-DD', 'DD/MM/YYYY', and 'MM-DD-YYYY'. The analyst needs to standardize these dates into a single format for time-series analysis. Which approach should the analyst take?

A.Sort the dates lexicographically and then apply a standard format.
B.Apply a single date parsing function with a fixed format string.
C.Convert the dates to Unix timestamps using a generic conversion function.
D.Use a regular expression to extract year, month, and day, then reconstruct the date in a standard format.
AnswerD

Regular expressions can parse the different date patterns by identifying the position and separators of year, month, and day. Once extracted, the components can be reassembled into a consistent format like ISO 8601. This approach handles variability without relying on locale-specific parsing.

Why this answer

The dates are stored in multiple formats, so a one-size-fits-all parsing function will fail. Using regular expressions to extract the year, month, and day components allows the analyst to handle each pattern systematically and then reconstruct a standardized date. This method is robust and does not depend on locale settings.

Exam trap

The trap here is assuming that a single date format string can handle all variations, which leads to parsing errors.

Full explanation →
142
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.

Full explanation →
143
MCQmedium

A data analyst needs to sample 1000 customers from a database of 100,000 customers for a survey, ensuring every customer has an equal chance of selection. Which sampling method is most appropriate?

A.Cluster sampling
B.Stratified sampling
C.Systematic sampling
D.Simple random sampling
AnswerD

Simple random sampling assigns every customer an identical selection probability, directly satisfying the equal-chance constraint. By drawing 1000 individuals from the full 100,000-customer frame without stratification or systematic intervals, it avoids selection bias. Stratified, cluster, or convenience methods would alter probabilities across subgroups or rely on non-random access.

Why this answer

Simple random sampling is the method where every individual in the population has an equal chance of being selected. This directly matches the requirement that every customer has an equal chance of selection. It is the most straightforward probability sampling technique.

Exam trap

DA0-002 often tests the distinction between simple random sampling and stratified or systematic sampling, causing candidates to choose stratified when the requirement is equal chance for all, not representation of subgroups.

How to eliminate wrong answers

Option A is wrong because cluster sampling involves dividing the population into clusters and randomly selecting entire clusters, which does not give every individual an equal chance (only clusters have equal chance). Option B is wrong because stratified sampling divides the population into strata and samples from each, ensuring representation but not equal chance for every individual across the whole population. Option C is wrong because systematic sampling selects every nth individual, which can introduce bias if the population has a periodic pattern, and it does not guarantee equal chance for all.

Full explanation →
144
MCQmedium

A data analyst is tasked with visualizing the distribution of customer ages across different regions. The dataset contains outliers. Which chart type best displays the distribution and highlights outliers?

A.Box plot
B.Violin plot
C.Histogram
D.Bar chart
AnswerA

A box plot encodes the median, quartiles and whiskers, so the interquartile range shows the distribution's spread while points beyond the whiskers are plotted individually as outliers. This satisfies the stem's dual requirement to display age distribution across regions and highlight outliers.

Why this answer

A box plot is purpose-built to display distribution summary statistics—median, quartiles, and whiskers—and explicitly marks outliers as individual points beyond the whiskers. This makes it the best choice when the requirement is to show distribution across regions while highlighting outliers. Grouping box plots by region allows direct comparison of age distributions.

Exam trap

DA0-002 often tests the distinction between charts that show distribution shape (histogram, violin) and charts that explicitly flag outliers (box plot), tempting candidates to choose violin plot for its visual richness.

How to eliminate wrong answers

Option B is wrong because a violin plot shows the probability density shape of the distribution but does not explicitly mark outliers as distinct points, making outlier identification less direct. Option C is wrong because a histogram shows frequency distribution but does not highlight outliers; extreme values are simply binned at the tails. Option D is wrong because a bar chart compares categorical aggregates (e.g., counts or averages) and cannot represent a continuous distribution or outliers.

Full explanation →
145
MCQmedium

A data analyst needs to retrieve current weather data from a third-party service. The service provides an endpoint that returns data in JSON format over HTTP. Which data source type is being used?

A.Streaming data
B.Flat file
C.Web scraping
D.API
AnswerD

An HTTP endpoint returning JSON is a REST API, which the analyst queries programmatically to retrieve current weather data. Unlike a flat file or database extract, the API delivers structured, on-demand responses, satisfying the requirement for live third-party weather retrieval.

Why this answer

The data analyst is retrieving data from a third-party service via an HTTP endpoint that returns JSON. This is the classic definition of an API (Application Programming Interface) — specifically a RESTful web API — which allows programmatic access to structured data over HTTP using standard methods like GET. The JSON format confirms it is an API response, not a file or stream.

Exam trap

The trap here is that candidates confuse 'web scraping' (Option C) with API consumption because both involve HTTP, but scraping parses unstructured HTML while an API returns structured JSON, and CompTIA often tests this distinction by describing a direct JSON endpoint to lure test-takers into selecting web scraping.

How to eliminate wrong answers

Option A is wrong because streaming data implies a continuous, real-time flow of data (e.g., from Kafka, WebSockets, or sensor feeds), whereas the question describes a single request-response retrieval over HTTP. Option B is wrong because a flat file (e.g., CSV, TSV, or fixed-width) is a static file stored locally or on a file server, not an HTTP endpoint that returns JSON dynamically. Option C is wrong because web scraping involves parsing raw HTML from a web page to extract data, not consuming a structured JSON response from a dedicated API endpoint.

Full explanation →
146
MCQeasy

A data analyst is reviewing a dataset of customer transactions and notices that the 'transaction_amount' column contains several negative values. The analyst suspects these are refunds rather than errors. Which data validation technique should the analyst apply to confirm this?

A.Calculate the mean and standard deviation of transaction_amount
B.Remove rows with negative transaction amounts
C.Replace all negative values with zero
D.Cross-reference negative amounts with a separate refunds table
AnswerD

Cross-referencing with a refunds table directly verifies whether negative transaction amounts correspond to legitimate refunds. This validation technique compares data across sources to confirm accuracy and meaning. It is the most reliable way to distinguish refunds from data entry errors. By matching transaction IDs or timestamps, the analyst can confirm the negative values are intentional and correctly recorded.

Why this answer

Cross-referencing negative transaction amounts with a separate refunds table is a validation technique that confirms whether the negative values are legitimate refunds. It compares the dataset against an authoritative source to verify accuracy. This approach preserves data integrity and ensures that any subsequent analysis correctly accounts for refunds.

Other options either summarize, alter, or delete data without confirming the values' meaning.

Exam trap

The trap here is confusing data cleaning with data validation; removing or replacing negative values might seem like a quick fix, but validation requires confirming the values' legitimacy first.

Full explanation →
147
MCQeasy

A data analyst is preparing a dataset for analysis and discovers that the 'customer_id' column has missing values. The analyst decides to remove all rows with missing 'customer_id' because it is a primary key. Which data preparation technique is being applied?

A.Discretization
B.Listwise deletion
C.Normalization
D.Imputation
AnswerB

Listwise deletion removes entire records that have missing values in any column. Here, the analyst removes rows where customer_id is missing, which is exactly listwise deletion applied to a specific column. Since customer_id is a primary key, missing values cannot be imputed, so removal is a valid approach.

Why this answer

Listwise deletion is the correct technique because it involves removing records with missing values. Since customer_id is a primary key, missing values cannot be reliably filled, so deleting those rows is a standard data cleaning step. This ensures that each record has a valid unique identifier, which is essential for relational integrity and accurate analysis.

Exam trap

The trap here is confusing missing value handling with data transformation techniques like normalization or discretization, which do not address missing data.

Full explanation →
148
MCQeasy

A data analyst is working with a dataset containing customer ages. The ages range from 18 to 90, but the analyst notices that the distribution is heavily skewed to the right. To better understand the central tendency, the analyst decides to calculate a measure that is resistant to outliers. Which measure of central tendency should the analyst use?

A.Median
B.Mean
C.Mode
D.Range
AnswerA

The median is the middle value when data is ordered, making it resistant to outliers and skewness. In a right-skewed distribution, the median remains a robust measure of central tendency, better representing the typical customer age. It is not influenced by extreme values, so it provides a more accurate reflection of the center for skewed data.

Why this answer

The median is the appropriate measure because it is resistant to outliers and skewness, providing a better representation of the central value in a right-skewed distribution. The mean would be inflated by high ages, while the mode and range do not measure central tendency effectively for continuous skewed data.

Exam trap

The trap here is assuming the mean is always the best measure of center; in skewed distributions, the median is more representative.

Full explanation →
149
MCQmedium

During data acquisition, an analyst notices that the data from an external vendor has inconsistent date formats. What is the first step the analyst should take?

A.Contact the vendor to request corrected data
B.Immediately transform dates to a standard format
C.Perform data profiling
D.Reject the entire dataset
AnswerC

Data profiling examines the vendor dataset to identify the actual date formats, patterns and anomalies present before any transformation. This establishes what standardisation is needed, satisfying the requirement to understand inconsistent formats prior to cleansing or conversion.

Why this answer

Before transforming or rejecting data, the analyst must first understand its shape, quality, and anomalies — that is data profiling. Profiling reveals the extent and pattern of the inconsistent date formats, how many records are affected, and whether other issues exist, which then informs the correct remediation approach. Jumping straight to transformation without profiling risks applying the wrong parsing rules.

Exam trap

DA0-002 often tests the data-quality workflow order — candidates who jump to 'fix it' (transform) or 'escalate it' (contact vendor) miss that profiling must come first to characterize the problem before any remediation decision.

How to eliminate wrong answers

Option A is wrong because contacting the vendor is premature — the analyst has not yet quantified the problem or confirmed it is the vendor's fault rather than a parsing issue on ingestion. Option B is wrong because transforming dates before profiling risks applying incorrect format assumptions and silently corrupting values (e.g., misreading DD/MM vs MM/DD). Option D is wrong because rejecting the entire dataset is a drastic overreaction; profiling may show only a small subset is malformed and the rest is usable.

Full explanation →
150
MCQmedium

A business analyst is creating a dashboard to monitor sales performance. The primary goal is to quickly identify which regions are underperforming compared to the target. Which design principle is most important to apply?

A.Data-ink ratio
B.Appropriate precision
C.Visual hierarchy
D.Consistent color coding
AnswerC

Visual hierarchy directs the viewer's eye to the most critical data first, letting underperforming regions stand out immediately against target. This directly satisfies the stated goal of quick identification, since colour, size and position encode performance gaps faster than dense tables or uniform layouts.

Why this answer

Visual hierarchy ensures that the most important metrics (like underperforming regions) are prominently displayed, drawing the user's attention first.

Full explanation →
Page 1

Page 2 of 14

Page 3

All pages

1234567891011121314

Practice DA0-002 by domain

Target a specific domain to shore up weak areas.

Data Acquisition and PreparationData Concepts and EnvironmentsData AnalysisVisualization and ReportingData Governance
See all domains with question counts →