75 of 230 questions · Page 3/4 · Data Analysis · Answers revealed
A researcher is designing an A/B test to compare two website layouts. Which TWO elements are essential for determining the required sample size?
Power affects the probability of detecting an effect.
Why this answer
Statistical power and desired effect size are key inputs for sample size calculation.
Refer to the exhibit. A data analyst wants to grant read access to an entire cloud storage bucket named 'data-lake'. Which of the following best describes what this policy does?
The policy grants s3:GetObject on the entire bucket, enabling read access to all objects.
Why this answer
This policy grants read access to all objects within the 'data-lake' bucket. In cloud storage, a bucket-level policy that allows the 'GetObject' action without a condition restricting the resource to a specific prefix or folder effectively permits reading every object in the bucket. Option D correctly identifies this behavior.
Exam trap
The trap here is that candidates often confuse a bucket-level policy that grants access to all objects with one that restricts access to a specific folder or user, overlooking the absence of a condition or principal specification in the policy statement.
How to eliminate wrong answers
Option A is wrong because the policy only grants read access (s3:GetObject), not write access (s3:PutObject). Option B is wrong because the policy does not specify any user or principal restriction; it applies broadly (e.g., to all principals if the Principal is '*'). Option C is wrong because the policy does not include a condition limiting access to a specific folder (prefix); it applies to the entire bucket (arn:aws:s3:::data-lake/*).
A data analyst is cleaning a dataset and finds that some records have duplicate entries based on customer ID. Which data quality dimension is most directly affected by these duplicates?
Duplicates directly impact uniqueness.
Why this answer
Duplicates violate the uniqueness dimension, which requires each entity to be represented only once.
A data analyst is building a supervised learning model to predict customer churn. The target variable is binary (churn = yes/no). Which TWO modeling techniques are appropriate for this task? (Select two.)
Logistic regression models binary outcomes and is appropriate for classification.
Why this answer
Logistic regression is appropriate because it models the probability of a binary outcome (churn yes/no) using a logistic function, making it a standard choice for binary classification tasks. It outputs a value between 0 and 1, which can be thresholded to predict the class label.
Exam trap
The trap here is that candidates may confuse unsupervised clustering (K-means) or association rule mining (Apriori) with supervised classification, or mistakenly think linear regression can be adapted for binary outcomes without transformation.
In time series decomposition, a pattern that repeats at regular intervals (e.g., weekly, yearly) is called:
Seasonality has fixed and known periods.
Why this answer
Seasonality refers to regular, periodic patterns in time series data.
A simple linear regression model predicts sales (y) from advertising spend (x). The equation is y = 2.5x + 10, and R² = 0.81. Which interpretation is correct?
R² = 0.81 means 81% explained.
Why this answer
Slope indicates that each unit increase in x increases y by 2.5 units. R² of 0.81 means 81% of variance in y is explained by x.
In a time series analysis, a retail analyst observes consistent peaks in sales every December and troughs every February. This pattern repeats annually. Which component of time series does this represent?
Seasonality is predictable and repeats over fixed intervals.
Why this answer
Seasonality refers to regular patterns that repeat over fixed periods, such as months or quarters.
A dataset contains outliers in a feature that will be used for linear regression. Which two outlier treatment methods are appropriate? (Choose TWO)
Capping limits extreme values.
Why this answer
Capping outliers or transforming the variable can reduce their influence.
A data scientist is tuning a decision tree model to prevent overfitting. The model currently has a high variance. Which hyperparameter adjustment is most effective?
Reducing max depth stops the tree from growing too deep, simplifying the model and reducing variance.
Why this answer
Reducing maximum depth limits the number of splits in the decision tree, which directly reduces model complexity and variance. A high-variance model is overfitting to training data, and capping depth prevents the tree from learning overly specific patterns that do not generalize.
Exam trap
CompTIA often tests the misconception that increasing model complexity (e.g., more leaves) reduces overfitting, when in reality it increases variance; the trap here is that candidates may confuse 'minimum samples split' as the only regularization technique, overlooking that reducing max depth is a more direct and effective hyperparameter for high variance.
How to eliminate wrong answers
Option B is wrong because increasing minimum samples split actually reduces overfitting by requiring more samples per split, which is also effective but not the most direct adjustment for high variance; the question asks for the most effective hyperparameter adjustment, and reducing depth is more aggressive. Option C is wrong because increasing the number of leaves increases model complexity, which would exacerbate overfitting and increase variance, not reduce it. Option D is wrong because using a smaller dataset would increase variance (less data leads to more unstable splits) and is not a hyperparameter adjustment; it is a data-level change that typically worsens overfitting.
A marketing analyst wants to segment customers based on purchasing behavior and demographics. The dataset includes continuous variables (spending amount, frequency) and categorical variables (region, gender). The analyst decides to use k-means clustering. What should the analyst do to prepare the data?
Standardization ensures equal weight; one-hot encoding converts categories to binary vectors.
Why this answer
K-means clustering relies on Euclidean distance, which is sensitive to the scale of features. Standardizing continuous variables (e.g., spending amount, frequency) ensures they contribute equally to distance calculations, while one-hot encoding categorical variables (e.g., region, gender) converts them into numerical form without implying ordinal relationships, allowing k-means to process mixed data types correctly.
Exam trap
The trap here is that candidates assume k-means can natively handle mixed data types because it is a common clustering algorithm, but it strictly requires numerical input and scale normalization to avoid skewed distance calculations.
How to eliminate wrong answers
Option A is wrong because k-means cannot directly handle categorical variables; it requires numerical input and assumes continuous features, so using raw mixed-type data would produce meaningless distance calculations. Option C is wrong because PCA is a dimensionality reduction technique applied after preprocessing, not a substitute for standardizing and encoding; it may be used optionally but is not the required preparation step. Option D is wrong because removing categorical variables discards valuable demographic information that could improve segmentation, and k-means can incorporate them after proper encoding.
A data analyst wants to predict customer churn based on categorical features like region and plan type, and continuous features like usage and tenure. Which regression type should be used?
Logistic regression is used for binary classification, suitable for churn prediction.
Why this answer
Logistic regression is the correct choice because the target variable, customer churn, is binary (churn vs. no churn). Logistic regression models the probability of a binary outcome using a sigmoid function, making it suitable for classification tasks with both categorical and continuous predictors.
Exam trap
CompTIA often tests the misconception that 'regression' in the option name implies it is only for continuous outcomes, leading candidates to overlook logistic regression as a valid classification technique.
How to eliminate wrong answers
Option B (Ridge regression) is wrong because it is a regularized form of linear regression used for continuous outcomes, not binary classification. Option C (Linear regression) is wrong because it predicts a continuous value and is inappropriate for a binary dependent variable; it can produce probabilities outside [0,1] and violates the assumption of normally distributed errors. Option D (Lasso regression) is wrong because, like Ridge, it is a regularized linear regression for continuous targets and performs feature selection via L1 penalty, but it does not handle binary classification.
During data exploration, an analyst notices that the target variable has a heavily right-skewed distribution. Which data transformation would be most appropriate to make the distribution more symmetric?
Log transformation effectively reduces right skewness.
Why this answer
Log transformation is appropriate for heavily right-skewed distributions because it compresses the high values and spreads out the low values, making the distribution more symmetric. Square root transformation is better for moderate skew, and reciprocal transformation is for severe skew. Therefore, option A (Log transformation) is correct.
A company’s marketing team wants to segment customers based on purchase history, demographics, and website behavior. The data includes both numeric and categorical variables. Which clustering algorithm is best suited for handling mixed data types?
Gower distance can handle mixed data types by computing a dissimilarity matrix that combines numeric and categorical attributes.
Why this answer
Hierarchical clustering with Gower distance is best suited for mixed data types because Gower distance computes a dissimilarity measure that handles both numeric and categorical variables by normalizing numeric differences and using a simple matching coefficient for categorical ones. This allows the algorithm to create a distance matrix that equally weights all variable types, making it ideal for segmenting customers with purchase history, demographics, and website behavior data.
Exam trap
The trap here is that candidates often assume K-means or DBSCAN can handle mixed data by simply encoding categorical variables, but they overlook that Euclidean distance on encoded data distorts the geometry and fails to preserve the natural dissimilarity structure of categorical variables.
How to eliminate wrong answers
Option B (K-modes clustering) is wrong because it is designed exclusively for categorical data and cannot handle numeric variables like purchase history or website behavior metrics. Option C (DBSCAN with Euclidean distance) is wrong because Euclidean distance is only meaningful for numeric data and cannot properly measure dissimilarity between categorical variables, leading to distorted clusters. Option D (K-means clustering) is wrong because it relies on Euclidean distance and assumes numeric, continuous data; it cannot directly incorporate categorical variables without encoding, and even with encoding, it is sensitive to scaling and does not naturally handle mixed types.
A data analyst is working with a dataset containing house prices. After building a multiple linear regression model, the analyst observes that the model performs well on training data but poorly on validation data. Which technique is most appropriate to address this issue?
Ridge regularization adds a penalty to large coefficients, reducing variance and combating overfitting.
Why this answer
The model is overfitting the training data, as evidenced by high performance on training data but poor performance on validation data. L2 regularization (Ridge) adds a penalty term proportional to the square of the coefficients, which shrinks them and reduces model complexity, thereby improving generalization to unseen data.
Exam trap
CompTIA often tests the distinction between overfitting and underfitting, and candidates mistakenly choose polynomial transformation or adding features thinking they will improve fit, when in fact they increase model complexity and worsen overfitting.
How to eliminate wrong answers
Option A is wrong because decreasing the training data size would exacerbate overfitting by providing the model with even less information to learn generalizable patterns. Option B is wrong because polynomial transformation increases model complexity and feature interactions, which typically worsens overfitting rather than addressing it. Option C is wrong because increasing the number of features adds more predictors, which increases the risk of overfitting and does not directly penalize large coefficients.
A data analyst is preparing a logistic regression model to predict customer churn. After examining the exhibit, which data quality issue should the analyst address first?
The total_charges for the first customer is equal to monthly_charges, suggesting a calculation error.
Why this answer
Inconsistent data formats, such as mixed numeric representations in a column like 'total_charges', will cause parsing errors when loading data into a logistic regression model. Inconsistent data must be standardized (e.g., to a uniform numeric type) before any other preprocessing steps, as it prevents the model from executing. This issue is more critical to address first than missing values or outliers, which can be handled later through imputation or transformation without blocking model execution.
Exam trap
The trap here is that candidates often focus on statistical concerns like outliers or missing values, but the most pressing issue is data type inconsistency, which prevents the model from executing at all. This question tests the order of operations in data preprocessing: fix structural issues first.
How to eliminate wrong answers
Option A is wrong because duplicate customer IDs are a data integrity issue that can cause data leakage or overfitting, but the exhibit does not show any duplicate IDs, and this is not the most immediate problem for model training. Option B is wrong because missing values in 'total_charges' are not indicated in the exhibit; the issue is inconsistent formatting, not absence of data. Option D is wrong because outliers in 'monthly_charges' are not visible in the exhibit, and while outliers can affect logistic regression, they are a secondary concern compared to the fundamental data type inconsistency that prevents the model from even reading the data correctly.
A dataset contains a feature 'Age' with values ranging from 18 to 95. To prepare data for a k-nearest neighbors algorithm, which transformation should be applied to 'Age'?
Min-max normalization ensures all features contribute equally to distance calculations.
Why this answer
Min-max normalization scales features to a fixed range (e.g., 0-1), which is appropriate for distance-based algorithms like k-NN.
A data analyst wants to compare the average revenue per customer between two marketing campaigns (A and B). The analyst is unsure if the data follows a normal distribution. Which statistical test is most appropriate for comparing the means of the two groups?
The two-sample t-test compares means of two independent groups.
Why this answer
For comparing means of two independent groups, the t-test is the standard parametric test. If normality is violated, a non-parametric alternative like Mann-Whitney U could be used, but the t-test is robust for moderate sample sizes.
A data analyst has a time series of monthly sales data. They observe that sales are consistently higher every December and lower every January. Which component of time series does this pattern represent?
Seasonality refers to fixed periodic patterns within a year.
Why this answer
Regular patterns that repeat within one year are seasonality.
Given the linear regression output, which independent variable has the strongest effect on price, based on standardized coefficients?
sqft_living has the highest absolute t-value (10.0) indicating strong effect.
Why this answer
Standardized coefficients (beta weights) allow comparison of the relative strength of independent variables by measuring the number of standard deviations the dependent variable changes per one standard deviation change in the predictor. In the regression output, sqft_living has the highest absolute standardized coefficient, indicating it has the strongest effect on price. The intercept is not an independent variable and its coefficient is not standardized for comparison.
Exam trap
The trap here is that candidates mistakenly compare unstandardized coefficients or p-values instead of standardized coefficients, leading them to choose a variable like bathrooms or bedrooms that appears significant but has a weaker standardized effect.
How to eliminate wrong answers
Option A is wrong because bathrooms may have a statistically significant coefficient, but its standardized coefficient is smaller than that of sqft_living, meaning it has a weaker relative effect on price. Option C is wrong because the intercept is a constant term representing the predicted price when all independent variables are zero; it is not an independent variable and its coefficient is not standardized for effect comparison. Option D is wrong because bedrooms, while possibly significant, has a lower absolute standardized coefficient than sqft_living, indicating a weaker influence on price per standard deviation change.
An analyst is conducting an A/B test to compare two website designs. The null hypothesis is that there is no difference in conversion rates. The p-value obtained is 0.03, and the significance threshold is 0.05. What should the analyst conclude?
Correct: p < α, reject null.
Why this answer
Since p-value (0.03) < α (0.05), we reject the null hypothesis, indicating a statistically significant difference.
A data analyst calculates the mean, median, and mode of a dataset. Which of the following best describes how these measures are used in descriptive statistics?
Mean, median, and mode are measures of central tendency.
Why this answer
Descriptive statistics summarize data using measures like mean, median, and mode to describe central tendency.
A stock analyst is analyzing monthly sales data for a retail company and observes a consistent pattern of high sales every December. This pattern is most likely an example of which time series component?
Correct: regular pattern within a fixed period.
Why this answer
Seasonality refers to regular, predictable patterns that repeat at fixed intervals (e.g., yearly, monthly). The consistent December peak indicates a seasonal pattern.
In simple linear regression, the coefficient of determination R² measures:
Correct interpretation of R².
Why this answer
R² indicates the proportion of variance in the dependent variable explained by the independent variable.
In a regression analysis, the coefficient of determination (R²) is 0.85. How should this value be interpreted?
Correct interpretation of R².
Why this answer
R² represents the proportion of variance in the dependent variable that is explained by the independent variable(s). An R² of 0.85 means the model explains 85% of the variability.
A data analyst is building a binary classification model to predict customer churn. The dataset is imbalanced, with only 10% churners. The analyst wants to evaluate model performance with a focus on correctly identifying churners. Which metric is most appropriate?
Recall measures how many actual churners were correctly found, directly addressing the focus.
Why this answer
Recall (sensitivity) is the most appropriate metric because it measures the proportion of actual churners correctly identified by the model. Since the dataset is imbalanced (only 10% churners) and the analyst's focus is on correctly identifying churners, recall directly addresses the cost of missing positive cases (false negatives). Accuracy would be misleading due to class imbalance, while precision and F1-score prioritize different trade-offs.
Exam trap
The trap here is that candidates often default to accuracy as the default metric, failing to recognize that class imbalance renders accuracy misleading, and that the question's explicit focus on 'correctly identifying churners' points directly to recall, not precision or F1-score.
How to eliminate wrong answers
Option B (F1-score) is wrong because it balances precision and recall, but the analyst's primary goal is to maximize identification of churners, not to balance false positives and false negatives; F1-score would penalize a model that achieves high recall at the expense of precision, which may be acceptable in this scenario. Option C (Precision) is wrong because it measures the proportion of predicted churners that are actual churners, focusing on false positives rather than false negatives; the analyst wants to minimize missed churners, not necessarily avoid false alarms. Option D (Accuracy) is wrong because with only 10% churners, a naive model predicting all non-churners would achieve 90% accuracy, masking poor performance on the minority class; accuracy is inappropriate for imbalanced classification problems.
A retail company wants to predict future sales based on historical data. Which modeling approach is most appropriate if the data shows a clear seasonal pattern?
Time series analysis explicitly models seasonal patterns.
Why this answer
Time series analysis is specifically designed to model data points indexed in time order, making it ideal for capturing and forecasting seasonal patterns. Unlike regression models, it accounts for autocorrelation, trends, and seasonality components, which are critical for accurate sales prediction from historical data.
Exam trap
The trap here is that candidates see 'predict future sales' and mistakenly choose linear regression, overlooking that time series methods are required when data has temporal dependencies and seasonality.
How to eliminate wrong answers
Option A is wrong because linear regression assumes independence of observations and cannot model time-dependent structures like seasonality or autocorrelation. Option C is wrong because K-means clustering is an unsupervised learning method used for grouping similar data points, not for forecasting future values. Option D is wrong because logistic regression is used for binary classification problems, not for predicting continuous numeric sales figures.
A retail company wants to segment its customers based on purchase history. Which THREE methods are appropriate for customer segmentation?
Segments based on recency, frequency, monetary value.
Why this answer
K-means clustering, hierarchical clustering, and RFM analysis are common segmentation techniques. Linear regression and t-test are not segmentation methods.
The exhibit shows an SQL query executed on an 'orders' table that contains 'order_id', 'customer_id', and 'order_date'. What is the purpose of this query?
The query filters by 2023 date and having count > 5.
Why this answer
The query groups orders by customer_id and filters using a HAVING clause with COUNT(*) > 5, which counts the number of orders per customer. The WHERE clause restricts orders to those placed in 2023, so the result identifies customers who placed more than 5 orders in that year. This matches option D exactly.
Exam trap
CompTIA often tests the distinction between WHERE and HAVING, and the trap here is confusing a count of orders per customer with a count of products or an average, leading candidates to pick option B or C.
How to eliminate wrong answers
Option A is wrong because the WHERE clause filters for order_date in 2023, so the count is not regardless of date. Option B is wrong because the query counts orders per customer, not the average order count per customer. Option C is wrong because the query operates on an 'orders' table with no product-related column; it counts orders per customer, not products.
An analyst is preparing data for an A/B test and wants to ensure valid results. Which TWO of the following should be considered when calculating the required sample size?
Correct: effect size is a key input.
Why this answer
Sample size calculation depends on desired effect size and statistical power, among other factors like significance level.
A data analyst wants to compare the means of three different training methods on employee productivity. Which statistical test is most appropriate?
ANOVA compares means across multiple groups.
Why this answer
ANOVA (Analysis of Variance) is used to compare means of three or more groups.
An analyst is planning an A/B test to compare two website designs. Which TWO factors should be considered when calculating the required sample size?
Correct.
Why this answer
Statistical power and desired effect size are key inputs for sample size calculations.
A data analyst is cleaning a dataset with missing values in a time series of daily temperatures. The missing values occur sporadically. Which imputation method is most appropriate to maintain the temporal trend?
Correct: uses neighboring values to estimate missing points, preserving trend.
Why this answer
Interpolation estimates missing values by using surrounding data points and is suitable for time series with a trend. Forward-fill carries the last observation forward, which may not capture trend well. Mean imputation ignores order.
A data analyst is reviewing a dataset containing house prices. The mean price is $350,000 and the median is $280,000. Which of the following best describes the distribution of house prices?
Correct: Mean > median indicates right skew.
Why this answer
When the mean is greater than the median, the distribution is right-skewed (positively skewed) because higher values pull the mean upward.
A retail company wants to forecast monthly sales for the next 12 months. Sales data shows a clear upward trend and seasonal patterns that repeat yearly. Which time series model is most appropriate?
Holt-Winters includes trend and seasonality components, making it suitable for this data.
Why this answer
The Holt-Winters exponential smoothing model (option C) is the most appropriate because it explicitly captures both trend and seasonality components, which are present in the sales data (upward trend and yearly seasonal patterns). Unlike simple exponential smoothing, Holt-Winters includes additive or multiplicative seasonal terms, making it ideal for data with clear, repeating seasonal cycles over a 12-month horizon.
Exam trap
The trap here is that candidates often choose ARIMA or SARIMA because they are more 'advanced,' but the question specifically describes clear trend and seasonality without requiring stationarity or differencing, making Holt-Winters the most direct and appropriate choice.
How to eliminate wrong answers
Option A (SARIMA) is wrong because while SARIMA can model trend and seasonality, it requires the data to be stationary (differencing) and involves more complex parameter selection (p, d, q, P, D, Q, s); for a straightforward forecasting task with clear trend and seasonality, Holt-Winters is simpler and often more robust. Option B (Simple exponential smoothing) is wrong because it only handles level (no trend or seasonality), so it would fail to capture the upward trend and yearly seasonal patterns in the sales data. Option D (ARIMA) is wrong because it models trend but not seasonality; without seasonal differencing or seasonal AR terms, it cannot account for the repeating yearly patterns in the data.
In multiple linear regression, which TWO assumptions are critical for unbiased coefficient estimates? (Choose two.)
Correct. Linearity is required for unbiasedness because if the relationship is misspecified, OLS estimates will be biased.
Why this answer
For unbiased coefficient estimates in multiple linear regression, the linearity assumption (A) ensures that the model correctly specifies the functional form, and the independence of errors assumption (E) ensures that errors are uncorrelated, both of which are required for ordinary least squares (OLS) estimates to be unbiased. Homoscedasticity (D) is not required for unbiasedness but for efficiency (Gauss-Markov theorem).
Exam trap
The exam often tests the distinction between assumptions for unbiasedness (linearity and independence) versus those for efficiency (homoscedasticity) or inference (normality). Candidates may incorrectly select homoscedasticity as critical for unbiased coefficient estimates.
Which TWO of the following are appropriate uses of min-max normalisation?
Correct: Min-max normalisation scales to [0,1].
Why this answer
Min-max normalisation scales data to a fixed range (often 0-1), useful for distance-based algorithms like k-NN and neural networks. Standardisation (Z-score) is better for algorithms assuming Gaussian distribution.
Which data quality dimension ensures that data represents the real-world scenario correctly and without errors?
Accuracy is about correctness and error-free data.
Why this answer
Accuracy means the data correctly reflects reality.
A data analyst is analyzing survey responses where respondents rated satisfaction on a scale of 1-5. The analyst wants to visualize the distribution of responses. Which chart type is most appropriate?
Histograms display the frequency distribution of a single numeric variable across bins.
Why this answer
A histogram is the most appropriate chart for visualizing the distribution of a single discrete variable, such as satisfaction ratings on a 1-5 scale. It groups the responses into bins (each rating value) and displays the frequency of each bin using bars, clearly showing the shape, central tendency, and spread of the data.
Exam trap
The trap here is that candidates often confuse a histogram with a bar chart, but the key distinction is that a histogram is used for quantitative (ordinal or continuous) data where bin order matters, while a bar chart is for categorical (nominal) data with no inherent order.
How to eliminate wrong answers
Option A is wrong because a box plot summarizes data using five-number statistics (min, Q1, median, Q3, max) and is better for comparing distributions across groups, not for showing the detailed frequency distribution of a single ordinal variable. Option B is wrong because a scatter plot is used to visualize the relationship between two continuous variables, not the distribution of a single categorical or ordinal variable. Option C is wrong because a line chart is typically used to display trends over time or sequential data, not the frequency distribution of discrete survey responses.
In A/B testing, which factor is increased by having a larger sample size?
Power increases with sample size.
Why this answer
Larger sample size increases statistical power (ability to detect a true effect).
Which THREE of the following are common steps in data cleaning?
Missing values are often imputed to maintain dataset completeness.
Why this answer
Imputing missing values is a common data cleaning step because real-world datasets often have gaps due to data collection errors or system failures. Techniques like mean/median imputation, regression imputation, or using algorithms like k-NN help preserve sample size and avoid bias that would result from simply dropping rows. This ensures the dataset remains usable for analysis without introducing significant distortion.
Exam trap
CompTIA often tests the distinction between data cleaning steps and data collection or preprocessing steps, so the trap here is confusing 'increasing sample size' (a data augmentation or collection activity) with actual cleaning tasks like imputation, standardization, and deduplication.
Which data quality dimension is violated if a customer record has a missing phone number?
Completeness measures missing values.
Why this answer
Completeness refers to the extent to which data is not missing.
A data scientist is building a classification model to predict customer churn. The dataset has 10,000 records with 500 churners. The scientist uses logistic regression and achieves 98% accuracy, but the precision for churn class is only 15%. Which of the following is the most likely cause?
With only 500 churners out of 10,000, the model predicts most as non-churners, achieving high accuracy but low precision for the minority class.
Why this answer
The dataset has only 500 churners out of 10,000 records (5% churn rate), which is a classic class imbalance. Logistic regression can achieve high accuracy by simply predicting the majority class (non-churn) for all records, yielding 95% accuracy even without learning anything about churn. The very low precision (15%) for the churn class indicates that most of the positive predictions are false positives, a direct consequence of the model being biased toward the majority class due to imbalance.
Exam trap
CompTIA often tests the misconception that high accuracy always means a good model, hiding the fact that with imbalanced data, accuracy is misleading and metrics like precision, recall, or F1-score for the minority class are critical.
How to eliminate wrong answers
Option B is wrong because logistic regression inherently models a linear decision boundary; while non-linear boundaries can be approximated with feature engineering (e.g., polynomial terms), the core issue here is class imbalance, not boundary shape. Option C is wrong because multicollinearity inflates coefficient standard errors but does not cause the extreme precision drop seen here; it affects interpretability, not the fundamental accuracy-imbalance trade-off. Option D is wrong because overfitting would typically yield high training accuracy but poor generalization, not a specific low precision for the minority class while maintaining high overall accuracy; the model is actually underfitting the minority class.
An analyst wants to compare the average sales revenue across three different store locations. Which TWO statistical methods are appropriate for this comparison?
Correct: ANOVA compares means across three or more groups.
Why this answer
ANOVA compares means of three or more groups. A t-test compares only two groups. Chi-square tests categorical independence.
Correlation measures linear relationship. Descriptive stats summarise but don't compare multiple groups inferentially.
A marketing team wants to segment customers into groups based on purchasing behavior without prior labels. Which algorithm should the data analyst use?
K-means is an unsupervised clustering algorithm suitable for segmentation.
Why this answer
K-means clustering is the correct choice because it is an unsupervised learning algorithm that groups unlabeled data into clusters based on feature similarity. Since the marketing team has no prior labels for customer segments, K-means can partition customers by purchasing behavior patterns, such as frequency and monetary value, without needing predefined categories.
Exam trap
The trap here is that candidates often confuse unsupervised clustering (K-means) with supervised classification (K-nearest neighbors) because both involve 'K' and grouping, but KNN requires labeled data and predicts labels, while K-means discovers inherent structures without labels.
How to eliminate wrong answers
Option B is wrong because K-nearest neighbors is a supervised learning algorithm that requires labeled training data to classify or predict outcomes, making it unsuitable for unlabeled segmentation. Option C is wrong because linear regression is a supervised regression algorithm used to predict a continuous target variable, not to discover hidden groupings in unlabeled data. Option D is wrong because decision trees are typically used for supervised classification or regression tasks, relying on labeled data to split on features, and cannot perform unsupervised clustering without prior labels.
A data scientist is working with a dataset containing 1000 features and 500 samples. The goal is to build a predictive model. Which technique should be used to reduce the number of features while retaining most of the variance?
PCA reduces dimensionality by creating new features that capture maximum variance.
Why this answer
Principal Component Analysis (PCA) is an unsupervised dimensionality reduction technique that transforms the original features into a set of orthogonal components, ordered by the variance they capture. Given 1000 features and only 500 samples, PCA is ideal because it reduces the feature space while retaining the maximum variance, helping to avoid overfitting and the curse of dimensionality.
Exam trap
CompTIA often tests the distinction between supervised feature selection (Lasso, Forward selection) and unsupervised dimensionality reduction (PCA), trapping candidates who confuse regularization with variance-based reduction.
How to eliminate wrong answers
Option A is wrong because Ridge regression is a regularization technique that shrinks coefficients but does not reduce the number of features; it retains all features with penalized weights. Option B is wrong because Forward selection is a supervised feature selection method that selects features based on their predictive power, not on variance retention, and it can be computationally expensive with 1000 features. Option D is wrong because Lasso regression performs feature selection by shrinking some coefficients to zero, but it is a supervised method that selects features based on target correlation, not on maximizing variance retention, and may not be optimal for unsupervised dimensionality reduction.
A data analyst needs to combine two datasets that have the same columns but different rows. Which operation should they use?
Append adds rows from one dataset to another with same columns.
Why this answer
(Append) is correct because appending is the standard operation for combining two datasets with identical columns but different rows, stacking the rows from one dataset onto the other. In tools like SQL, this is achieved with the UNION or UNION ALL operator, and in Python pandas, it is done via the `append()` method or `pd.concat()` with axis=0. This operation preserves the column structure while extending the row count.
Exam trap
The trap here is that candidates confuse 'concatenate' (which can mean row-wise or column-wise) with 'append' (which specifically means row-wise stacking), leading them to choose Option A when the question explicitly requires combining rows.
How to eliminate wrong answers
Option A (Concatenate) is wrong because concatenation is a general term that can refer to combining along any axis (rows or columns), and in many contexts (e.g., SQL string functions, pandas with axis=1), it implies joining side-by-side rather than stacking rows; the question specifically requires row-wise stacking, which is append. Option C (Merge) is wrong because merge is used to combine datasets based on a common key column (like a SQL JOIN), not to simply stack rows when columns are identical. Option D (Aggregate) is wrong because aggregation involves summarizing data (e.g., SUM, AVG, COUNT) across groups, not combining separate datasets.
In a simple linear regression model y = 2.5 + 1.2x, what is the predicted value of y when x = 10?
Correct calculation.
Why this answer
Plug x=10: y = 2.5 + 1.2*10 = 2.5 + 12 = 14.5.
A data analyst wants to segment customers based on purchasing behavior such as frequency, monetary value, and recency. Which TWO clustering evaluation methods can help determine the optimal number of clusters? (Select two.)
Measures how similar an object is to its own cluster vs others.
Why this answer
The elbow method uses within-cluster sum of squares, and the silhouette score measures cohesion and separation. Both help choose k. Correlation coefficient is for association, not clustering.
ANOVA and t-test are for hypothesis testing.
A data analyst is asked to compare the average sales across three different store locations. The data is normally distributed and variances are approximately equal. Which statistical test is most appropriate?
ANOVA is designed for comparing means of 3+ groups.
Why this answer
ANOVA is used to compare means of three or more groups when assumptions of normality and equal variance are met.
An analyst is performing a logistic regression to predict customer churn (yes/no). The model outputs a probability of 0.75 for a particular customer. Which of the following best describes the interpretation?
Correct interpretation of logistic regression output.
Why this answer
Logistic regression outputs the probability that the event (churn) occurs, given the input features.
An analyst is conducting an A/B test on a new checkout process. To calculate sample size, which THREE factors must be considered?
Effect size is the minimum practical difference to detect.
Why this answer
Statistical power, significance level (alpha), and desired effect size (minimum detectable effect) are essential for sample size calculation.
A data analyst needs to visualize the distribution of a continuous variable across different categories. Which chart type is most suitable?
Box plot displays distribution across groups.
Why this answer
A box plot (option D) is the most suitable chart for visualizing the distribution of a continuous variable across different categories because it displays the median, quartiles, and potential outliers for each group, enabling direct comparison of spread and central tendency. Unlike a histogram, which shows the distribution of a single continuous variable without categorical grouping, the box plot inherently supports categorical axes. This makes it ideal for exploratory data analysis when assessing how a metric like revenue varies by region or product category.
Exam trap
CompTIA often tests the distinction between histograms and box plots by presenting a scenario where a candidate mistakenly chooses a histogram for grouped categorical data, overlooking that histograms require a continuous x-axis and cannot inherently separate categories without additional faceting.
How to eliminate wrong answers
Option A is wrong because a bar chart is designed for comparing categorical data using discrete counts or sums, not for showing the distribution of a continuous variable across categories. Option B is wrong because a histogram visualizes the distribution of a single continuous variable using bins, but it does not natively separate data into distinct categories; you would need faceting or multiple histograms, which is less efficient than a box plot. Option C is wrong because a scatter plot is used to examine the relationship between two continuous variables, not to compare distributions of one continuous variable across categories.
A data analyst is performing data cleaning. Which THREE steps are part of this process? (Choose three.)
Standardizing formats and fixing typos are cleaning tasks.
Why this answer
Correcting inconsistent data (Option A) is a core data cleaning step because it ensures that values follow a consistent format, such as standardizing date formats (e.g., 'MM/DD/YYYY' vs 'DD-MM-YYYY') or fixing capitalization (e.g., 'USA' vs 'usa'). This process directly addresses data quality issues that arise from human entry errors or system differences, making the dataset reliable for analysis.
Exam trap
The trap here is that candidates confuse data cleaning with data transformation or feature engineering, leading them to select normalization or feature engineering as cleaning steps, when in fact cleaning strictly addresses data quality issues like consistency, completeness, and uniqueness.
Which statistical test should be used to determine if there is a significant association between two categorical variables, such as gender and product preference?
Correct test for categorical variables.
Why this answer
The chi-square test of independence is used to test association between two categorical variables.
A data scientist runs a linear regression model to predict customer spending based on income. The R-squared value is 0.45 and the p-value for the slope coefficient is 0.03. At a significance level of α=0.05, which of the following conclusions is correct?
Correct: p<0.05 indicates significance; R²=0.45 indicates explained variance.
Why this answer
The p-value (0.03) is less than α (0.05), so the slope is statistically significant. R²=0.45 means the model explains 45% of the variance.
A data analyst is building a linear regression model to predict sales based on advertising spend. The analyst notices that the residuals are not normally distributed and have a non‑constant variance. Which of the following transformations is most appropriate to apply to the dependent variable?
Log transformation is commonly used to stabilize variance and make residuals more normally distributed.
Why this answer
The logarithmic transformation is the most appropriate choice because it stabilizes non‑constant variance (heteroscedasticity) and helps make the residuals more normally distributed, which are key assumptions for linear regression. By compressing the scale of the dependent variable (sales), it reduces the impact of large values and often linearizes multiplicative relationships, such as diminishing returns from advertising spend.
Exam trap
CompTIA often tests the misconception that any scaling technique (standardization or normalization) can fix heteroscedasticity or non‑normality, but these methods only change the range or center of the data, not the shape of the residual distribution or the variance structure.
How to eliminate wrong answers
Option A is wrong because standardization (z-score) centers and scales the data to mean 0 and standard deviation 1, but it does not address heteroscedasticity or non‑normal residuals; it merely changes the units of the dependent variable without altering the shape of the distribution. Option B is wrong because normalization (min-max scaling) rescales the data to a fixed range (e.g., 0 to 1), which also fails to correct non‑constant variance or non‑normality; it is primarily used for feature scaling in algorithms like neural networks, not for satisfying regression assumptions. Option D is wrong because the square root transformation is typically used for count data (e.g., Poisson-distributed outcomes) to stabilize variance, but it is less effective than the log transformation when the variance increases proportionally with the mean, which is common in sales data; the log transformation is the standard choice for multiplicative relationships and heteroscedasticity.
Which data quality dimension is most concerned with whether data values fall within a defined domain or acceptable range?
Validity checks if data follows format and range rules.
Why this answer
Validity refers to whether data values conform to defined rules or constraints.
A data scientist applies K-means clustering to a customer dataset. The elbow method suggests using 4 clusters. After running K-means with k=4, the within-cluster sum of squares (WCSS) is plotted against k, and the elbow is at k=4. What does this indicate?
The elbow point is where the rate of decrease sharply changes.
Why this answer
The elbow method suggests that increasing k beyond 4 yields diminishing returns in reducing WCSS; k=4 is a good trade-off.
A data analyst is examining the relationship between advertising spend (in thousands) and sales (in thousands). The Pearson correlation coefficient is computed as r = -0.85. Which of the following interpretations is correct?
Correct: r close to -1 indicates strong negative.
Why this answer
Pearson r measures linear correlation: -0.85 indicates a strong negative linear relationship (as one increases, the other decreases). The magnitude |0.85| is close to 1, so strong.
A data analyst trains a complex model that achieves 99% accuracy on training data but only 65% on new data. What is the most likely issue?
The model performs well on training but poorly on test data, a classic sign of overfitting.
Why this answer
The model performs exceptionally well on training data (99% accuracy) but poorly on new data (65% accuracy), which is the classic symptom of overfitting. Overfitting occurs when the model learns noise and specific patterns in the training data rather than generalizing to unseen data, often due to excessive complexity (e.g., too many parameters or deep layers). This results in high variance and poor performance on validation or test sets.
Exam trap
CompTIA often tests the distinction between overfitting and underfitting by presenting a large gap between training and test accuracy, tempting candidates to choose high bias or multicollinearity due to confusion about bias-variance tradeoff or correlation issues.
How to eliminate wrong answers
Option A is wrong because underfitting would show poor performance on both training and new data (e.g., low accuracy on both), not high training accuracy with low test accuracy. Option C is wrong because multicollinearity refers to high correlation among predictor variables in regression models, which inflates coefficient standard errors but does not directly cause a large gap between training and test accuracy. Option D is wrong because high bias typically leads to underfitting, where the model is too simple and performs poorly on both training and test data, not the specific pattern of high training accuracy and low test accuracy seen here.
A data analyst is cleaning a dataset and finds that the 'age' column has several missing values. Which of the following is a valid method for handling missing numerical data?
Correct: mean imputation is a standard technique.
Why this answer
Mean imputation is a common method for handling missing numerical data, though median or mode can also be used.
A data analyst is summarizing the central tendency of a dataset with extreme outliers. Which measure is most robust to outliers?
Median is robust to outliers.
Why this answer
The median is not affected by extreme values, unlike the mean.
A data analyst is cleaning a dataset and finds that a numeric field has several missing values. The variable is normally distributed. Which imputation method is most appropriate?
Mean is appropriate for symmetric distributions.
Why this answer
For normally distributed data, mean imputation is common and preserves the mean.
A data analyst calculates the mean, median, and mode of a dataset. Which of the following measures of central tendency is least affected by extreme outliers?
The median is not affected by extreme values.
Why this answer
The median is resistant to outliers because it is the middle value, whereas the mean is pulled by extreme values and the mode may not be affected but is less robust for continuous data.
A data analyst uses the elbow method to determine the number of clusters for k-means. The plot shows a sharp bend at k=3 and a small bend at k=5. What is the recommended number of clusters?
The sharp bend suggests 3 clusters.
Why this answer
The elbow method suggests choosing k where the decrease in inertia becomes marginal; the sharp bend at 3 indicates the optimal k.
A data analyst is performing hypothesis testing to compare the mean sales of two store locations. Which TWO conditions must be satisfied to use a two‑sample t‑test? (Select TWO.)
Normality is assumed for the t-test, though it is robust for large samples.
Why this answer
The two-sample t-test assumes that the data in each group are approximately normally distributed. This is a key parametric assumption; if the sample sizes are large (typically n > 30), the Central Limit Theorem can relax this requirement, but for smaller samples, normality must hold to ensure valid test statistics and p-values.
Exam trap
CompTIA often tests the misconception that equal sample sizes or equal variances are required for a two-sample t-test, but the actual core assumptions are independence and normality (or large sample sizes via CLT).
An analyst is performing a linear regression and obtains an R-squared value of 0.85. Which of the following is the best interpretation?
This is the correct interpretation of R-squared.
Why this answer
R-squared indicates the proportion of variance in the dependent variable explained by the independent variable(s). 0.85 means 85% explained.
A data scientist is building a model to predict customer churn (yes/no). After training a logistic regression model, the coefficient for 'monthly charges' is 0.05 with a p-value of 0.03. Which interpretation is correct at α=0.05?
The coefficient 0.05 in logistic regression represents log-odds; exp(0.05)≈1.05, a 5% increase in odds.
Why this answer
The p-value < 0.05 indicates a statistically significant relationship; the positive coefficient means higher charges increase the log-odds of churn.
Drag and drop the steps to normalize a database table from 1NF to 3NF in the correct order.
Drag steps to the numbered slots on the right, or tap a step then tap a slot.
Why this order
Normalization proceeds from 1NF to 2NF to 3NF, then table creation and foreign keys.
A data analyst is performing K-means clustering on customer data. Which THREE of the following are steps in the K-means algorithm?
Correct: initial step.
Why this answer
K-means involves initializing centroids, assigning points to nearest centroid, and updating centroids as the mean of assigned points.
A dataset contains a column 'Age' with values: [22, 25, 25, 30, 35, 40, 45]. What is the interquartile range (IQR)?
Correct IQR = Q3 - Q1 = 40 - 25 = 15.
Why this answer
Q1 is median of lower half (22,25,25) = 25; Q3 is median of upper half (35,40,45) = 40; IQR = 40-25 = 15.
A data analyst is conducting an A/B test on a website's landing page. The null hypothesis is that there is no difference in conversion rates between the control and treatment groups. After collecting data, the analyst calculates a p-value of 0.03. Using a significance level of α = 0.05, what is the correct conclusion?
The p-value indicates statistical significance, but direction must be checked from data.
Why this answer
Since p < α, the null hypothesis is rejected, indicating a statistically significant difference in conversion rates.
Which TWO of the following are true about correlation and causation? (Select TWO).
This is a fundamental concept.
Why this answer
Correlation measures the strength and direction of a linear relationship between two variables, but it does not imply that one variable causes the other. Causation requires controlled experiments with randomization to rule out confounding variables and establish a cause-effect relationship.
Exam trap
CompTIA often tests the classic 'correlation does not imply causation' fallacy, where candidates mistakenly think that a statistically significant correlation automatically proves a causal relationship, ignoring the role of chance and confounding variables.
A data scientist is preparing data for a K-means clustering algorithm. The dataset contains features measured in different units (e.g., income in dollars and age in years). Which preprocessing step is most critical before running K-means?
Scaling ensures equal weighting; both min-max and Z-score are common.
Why this answer
K-means is sensitive to the scale of features because it uses Euclidean distance. Min-max normalization or standardization ensures all features contribute equally.
An analyst is fitting a polynomial regression model and wants to choose the degree that minimizes overfitting. Which technique should the analyst use?
Ridge regression penalizes large coefficients, which is effective for reducing overfitting in polynomial models without removing features.
Why this answer
Ridge regression (L2) adds a penalty proportional to the square of the magnitude of coefficients, which shrinks them toward zero but does not eliminate them. This regularization reduces variance and helps prevent overfitting in polynomial regression by controlling the influence of higher-degree terms, making it the correct technique for minimizing overfitting while retaining all features.
Exam trap
The trap here is that candidates often confuse Lasso (L1) with Ridge (L2), mistakenly thinking Lasso's coefficient elimination is always better for overfitting, when in fact Ridge's smooth shrinkage is more appropriate for polynomial models where all degrees should be retained but controlled.
How to eliminate wrong answers
Option A is wrong because Lasso regression (L1) performs feature selection by shrinking some coefficients exactly to zero, which is more suited for sparse models rather than simply minimizing overfitting in a polynomial context where all degrees may be needed. Option B is wrong because Principal Component Analysis (PCA) is a dimensionality reduction technique that transforms features into uncorrelated components, but it does not directly address overfitting in polynomial regression and can lose interpretability of the polynomial terms. Option C is wrong because stepwise selection is a variable selection method that adds or removes predictors based on statistical criteria (e.g., AIC, p-values), but it can be unstable and does not inherently regularize coefficients to combat overfitting as effectively as ridge regression.
Ready to test yourself?
Try a timed practice session using only Data Analysis questions.