Knowledge + Practice

CompTIA Data+ (DA0-002) (DA0-002) — Questions 301–375

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

Take a mock exam Exam hub

Page 5 of 14

301

Multi-Selecthard

A data analyst is building a logistic regression model to predict whether a customer will churn (yes/no). Which TWO statements about logistic regression are correct?

Select 2 answers

A.It is used only for time series forecasting.

B.The dependent variable is continuous.

C.The output is a probability between 0 and 1.

D.It requires normally distributed errors.

E.It assumes a linear relationship between predictors and the log-odds of the outcome.

AnswersC, E

Logistic regression predicts probabilities.

Why this answer

Logistic regression outputs probabilities between 0 and 1, and can use a sigmoid function. It is a classification algorithm, and coefficients represent log-odds changes.

Full explanation →

302

MCQeasy

A table 'orders' contains columns 'order_id', 'customer_id', 'order_date', and 'total'. An analyst needs to find orders placed between January 1, 2023 and December 31, 2023. Which WHERE clause is correct?

A.WHERE order_date > '2023-01-01' AND order_date < '2023-12-31'

B.WHERE order_date IN ('2023-01-01', '2023-12-31')

C.WHERE order_date >= '2023-01-01' OR order_date <= '2023-12-31'

D.WHERE order_date BETWEEN '2023-01-01' AND '2023-12-31'

AnswerD

BETWEEN is inclusive and concise.

Why this answer

The BETWEEN operator is inclusive and is the standard way to filter date ranges.

Full explanation →

303

MCQmedium

In Tableau, an analyst wants to create a calculated field that returns the average sales per customer only for customers who have made more than five purchases. Which Tableau function or approach would be most efficient?

A.Use a table calculation for running sum

B.Use a context filter on the number of records

C.Use a Level of Detail expression to count purchases per customer, then filter

D.Create a parameter to filter customers

AnswerC

Correct. LOD expressions can compute per-customer counts and then be used in a filter.

Why this answer

Level of Detail (LOD) expressions like { FIXED [Customer ID] : SUM(…) } allow computations at a granular level. Then using an IF condition on the LOD result filters to customers with >5 purchases.

Full explanation →

304

Multi-Selecthard

Which TWO of the following are valid techniques for validating the performance of a predictive model?

Select 2 answers

A.Bootstrapping

B.Feature scaling

C.Train-test split

D.K-fold cross-validation

E.Increasing training data

AnswersC, D

Splitting data into training and testing sets is a basic validation approach.

Why this answer

The train-test split (Option C) is a fundamental technique for validating predictive model performance by partitioning the dataset into separate training and testing subsets, ensuring the model is evaluated on unseen data to gauge generalization. This method directly addresses overfitting and provides an unbiased estimate of model accuracy, making it a standard practice in supervised learning workflows.

Exam trap

CompTIA often tests the distinction between data preprocessing techniques (like feature scaling) and actual model validation methods, leading candidates to mistakenly select feature scaling as a validation technique because it is a common step in the modeling pipeline.

Full explanation →

305

MCQmedium

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

A.Show a trend line of the last 12 months.

B.Provide a table of all monthly targets and actuals.

C.Display the actual revenue only.

D.Use a bullet chart showing actual vs. target.

AnswerD

A bullet chart provides a concise visual comparison of actual value to a target, highlighting the shortfall.

Why this answer

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

Exam trap

CompTIA often tests the misconception that a trend line or table provides sufficient context for a single variance, when in fact the bullet chart is the optimal choice for directly comparing actual vs. target in a single, focused visual.

How to eliminate wrong answers

Option A is wrong because a trend line of the last 12 months shows historical patterns but does not explicitly highlight the current month's shortfall against the target; it buries the key insight in a broader time series. Option B is wrong because a table of all monthly targets and actuals requires the viewer to manually scan and compare numbers, which is less efficient and less visually immediate for highlighting a single variance than a bullet chart. Option C is wrong because displaying only the actual revenue ($1.2M) omits the target entirely, making it impossible to identify the shortfall without external context.

Full explanation →

306

MCQmedium

An analyst runs a simple linear regression with an R² value of 0.85. Which interpretation is correct?

A.85% of the variance in the dependent variable is explained by the independent variable.

B.The slope of the regression line is 0.85.

C.The independent variable is 85% correlated with the dependent variable.

D.85% of the data points lie on the regression line.

AnswerA

R² is the coefficient of determination, indicating explained variance.

Why this answer

R² represents the proportion of variance in the dependent variable explained by the independent variable. 0.85 means 85% is explained.

Full explanation →

307

MCQhard

A data governance team is drafting a policy for handling personally identifiable information (PII). According to data governance best practices, which document should define the classification levels and handling procedures?

A.Data dictionary

B.Data classification policy

C.Data quality report

D.Data flow diagram

AnswerB

A data classification policy categorizes data by sensitivity and outlines handling rules.

Why this answer

The data classification policy is the authoritative document that defines classification levels (e.g., public, internal, confidential, restricted) and specifies handling procedures for each category, including PII. This aligns with data governance best practices, as it establishes the rules for labeling, storing, transmitting, and disposing of sensitive data. A data dictionary describes metadata and schema, not classification rules.

Exam trap

The trap here is that candidates confuse the data dictionary (which describes data structure) with the data classification policy (which governs data sensitivity and handling), leading them to select the dictionary as the document that defines classification levels.

How to eliminate wrong answers

Option A is wrong because a data dictionary documents metadata such as field names, data types, and definitions, but it does not define classification levels or handling procedures for PII. Option C is wrong because a data quality report measures data accuracy, completeness, and consistency, not security or classification policies. Option D is wrong because a data flow diagram visually maps how data moves between systems, but it does not prescribe classification levels or handling rules.

Full explanation →

308

MCQmedium

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

A.Apply progressive disclosure

B.Increase white space

C.Use a single chart type

D.Add more filters

AnswerA

Progressive disclosure shows a summary first and allows drilling into details.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

Full explanation →

309

MCQeasy

A data analyst wants to identify customers whose last name starts with 'Mc' from the 'customers' table. Which WHERE clause condition should be used?

A.last_name LIKE 'Mc_'

B.last_name LIKE 'Mc%'

C.last_name IN ('Mc%')

D.last_name = 'Mc%'

AnswerB

Correct: % matches any sequence of characters after 'Mc'.

Why this answer

The LIKE operator with '%' wildcard matches any sequence of characters after 'Mc'.

Full explanation →

310

MCQmedium

An analyst builds a dashboard with a gauge showing 'Current Inventory Level' as a percentage. Stakeholders find the gauge misleading because it always shows near 100% even when inventory is low. What is the most likely issue?

A.The maximum value of the gauge is set too low

B.The gauge updates too slowly

C.The gauge uses green for all values

D.The gauge needle is too small

AnswerA

This is incorrect. If the maximum is set too high, low inventory would show a low percentage, not near 100%. The actual problem is that the maximum is set too low.

Why this answer

When a gauge always shows near 100% despite low inventory, the most likely cause is that the maximum value of the gauge is configured too low. This scaling mismatch makes even small inventory values appear as a high percentage, making the gauge misleading. Therefore, option A is correct: the maximum value is set too low, causing the percentage to be artificially high.

Exam trap

The trap here is that candidates may focus on visual or performance issues (like update speed or color) instead of recognizing that the gauge's scale configuration is the root cause of the misleading percentage display. Additionally, the wording of option A is a common distractor—it states 'too high' when the actual issue is 'too low', testing attention to detail.

How to eliminate wrong answers

Option B is wrong because a slow update rate would cause stale data, not a consistently high reading; the gauge would eventually show the correct low value after refreshing. Option C is wrong because using green for all values is a color-coding issue that affects interpretation of thresholds, not the gauge's percentage calculation or scale. Option D is wrong because the needle size is a visual design choice that does not impact the underlying data representation or the percentage value displayed.

Full explanation →

311

MCQeasy

A data analyst needs to communicate the findings of a marketing campaign analysis to the Vice President of Marketing. The VP typically only reads the first paragraph and wants the key takeaway immediately. Which format should the analyst use?

A.A raw data extract

B.A detailed technical report

C.An executive summary

D.A data dictionary

AnswerC

Executive summaries condense findings for quick consumption.

Why this answer

An executive summary provides a concise overview with headline numbers and key insights, suitable for busy executives.

Full explanation →

312

Multi-Selecthard

An analyst is performing K-means clustering on customer data. The elbow method shows a clear bend at k=4. Which THREE of the following are true about K-means clustering with k=4?

Select 3 answers

A.The number of clusters is determined to be 4.

B.The algorithm will always produce the same clusters regardless of initial centroids.

C.The centroids are recomputed iteratively until convergence.

D.Categorical variables should be standardised before clustering.

E.The algorithm minimises the sum of squared distances between points and their assigned centroid.

AnswersA, C, E

Correct: Elbow method indicates k=4.

Why this answer

K-means initialises centroids randomly, so results can vary. The elbow method suggests 4 clusters. The algorithm minimises within-cluster sum of squares.

K-means works best with numeric data and assumes spherical clusters.

Full explanation →

313

MCQmedium

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

A.Scatter plot

B.Line chart

C.Bar chart

D.Heatmap

AnswerC

Bar charts are ideal for comparing quantities across categories like regions.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

Full explanation →

314

MCQhard

A large financial institution is implementing a data governance framework to comply with new regulations requiring strict control over sensitive customer data. The data governance committee has identified several domains, including customer master data, transaction data, and risk assessment data. They need to decide on a master data management (MDM) approach that ensures a single, authoritative source of customer information across all systems. However, the current environment has multiple legacy systems with conflicting customer records. The committee is concerned about downtime and business disruption during the transition. Which MDM approach best balances data consistency with minimal operational impact?

A.Registry MDM, which creates a virtual view by linking records without moving data.

B.Centralized MDM, which replaces all systems with one central master system.

C.Consolidation MDM, which merges all customer data into a single physical hub.

D.Coexistence MDM, which maintains multiple masters with synchronization.

AnswerA

Correct: Registry avoids disruption by leaving data in place and creating a unified index.

Why this answer

Registry MDM is correct because it creates a virtual, unified view of customer data by linking records from multiple legacy systems via a registry index, without physically moving or consolidating data. This approach ensures a single authoritative source of customer information while avoiding downtime and business disruption, as the underlying systems remain unchanged and operational during the transition.

Exam trap

The trap here is that candidates often confuse Registry MDM with Consolidation MDM, assuming that a single authoritative source requires physical data movement, when in fact a virtual registry can achieve the same goal with minimal operational impact.

How to eliminate wrong answers

Option B is wrong because Centralized MDM requires replacing all existing systems with a single central master system, which would cause significant downtime and business disruption due to the need for data migration and system decommissioning. Option C is wrong because Consolidation MDM merges all customer data into a single physical hub, which still requires moving data from legacy systems and can lead to operational interruptions during the consolidation process. Option D is wrong because Coexistence MDM maintains multiple masters with synchronization, which does not ensure a single authoritative source of customer information and can lead to data conflicts and inconsistency across systems.

Full explanation →

315

MCQmedium

A marketing analyst wants to predict whether a customer will churn (yes/no) based on account age and monthly charges. Which regression technique is most appropriate?

A.Logistic regression

B.Simple linear regression

C.Multiple linear regression

D.K-means clustering

AnswerA

Logistic regression handles binary outcomes.

Why this answer

Logistic regression is used for binary classification problems, outputting probabilities.

Full explanation →

316

Multi-Selecthard

A data analyst is investigating a correlation between two continuous variables. Which THREE of the following are appropriate steps in this exploratory data analysis? (Select THREE.)

Select 3 answers

A.Calculate the Pearson correlation coefficient

B.Create a scatter plot

C.Perform a t-test

D.Check for outliers using box plots

E.Create a contingency table

AnswersA, B, D

Quantifies linear correlation.

Why this answer

Scatter plot visualizes relationship, correlation coefficient quantifies strength, and removing outliers may be needed to avoid misleading results.

Full explanation →

317

MCQhard

An organization wants to ensure that all reports use the same definitions for metrics like 'Active Customer' to avoid confusion. Which data governance element should be implemented?

A.Row-level security

B.Data dictionary

C.Single version of truth

D.Data lineage

AnswerB

A data dictionary standardizes metric definitions across the organization.

Why this answer

A data dictionary provides consistent definitions, calculation methods, sources, and update frequencies for metrics.

Full explanation →

318

MCQhard

A data scientist is analyzing a dataset with multiple features and wants to apply k-means clustering to segment customers. She chooses k = 4 based on the elbow method. During the iteration process, which of the following correctly describes a step in the k-means algorithm?

A.Compute the covariance matrix and use principal components to initialize centroids.

B.Use hierarchical clustering to determine initial centroids.

C.Randomly assign centroids and then compute distances to the cluster medians.

D.Assign each point to the nearest centroid based on Euclidean distance, then update centroids as the mean of points in each cluster.

AnswerD

This is the standard k-means iteration.

Why this answer

K-means iteratively assigns each point to the nearest centroid, then recalculates centroids as the mean of points in the cluster.

Full explanation →

319

MCQmedium

Refer to the exhibit. Which type of ensemble method is being used?

A.Boosting

B.Stacking

C.Voting

D.Bagging

AnswerD

Random forest uses bagging (bootstrap aggregating) to create multiple decision trees.

Why this answer

The exhibit shows multiple base models (Model 1, Model 2, Model 3) trained in parallel on bootstrap samples of the data, and their predictions are combined via averaging (regression) or majority voting (classification). This parallel training with resampled data and equal-weight aggregation is the defining characteristic of bagging (Bootstrap Aggregating).

Exam trap

CompTIA often tests the distinction between bagging and boosting by showing parallel vs. sequential training diagrams, and the trap here is confusing the parallel bootstrap resampling with the sequential error-correction approach of boosting.

How to eliminate wrong answers

Option A is wrong because boosting trains models sequentially, where each subsequent model focuses on correcting the errors of the previous one, not in parallel on bootstrap samples. Option B is wrong because stacking uses a meta-learner to combine predictions from diverse base models, not simple averaging or majority voting. Option C is wrong because voting typically combines predictions from different model types (e.g., logistic regression, SVM) trained on the same dataset, not from the same model type trained on bootstrap samples.

Full explanation →

320

MCQmedium

A healthcare analyst is creating a report on patient outcomes. To comply with privacy regulations, which action should be taken before publishing?

A.Anonymize personally identifiable information

B.Include patient names for context

C.Provide raw data to all stakeholders

D.Aggregate data without anonymization

AnswerA

Correct. Anonymization protects privacy.

Why this answer

Anonymizing PII protects patient identities and ensures compliance with privacy laws like HIPAA.

Full explanation →

321

MCQmedium

A data analyst is reviewing a SQL query that joins three large tables. The query takes over an hour to run. The analyst notices that the WHERE clause filters on indexed columns in only two tables. Which of the following should the analyst do first to improve performance?

A.Use subqueries instead of joins

B.Check the query execution plan and optimize join order

C.Add indexes to all columns used in joins

D.Increase server memory

AnswerB

Analyzing the execution plan reveals performance bottlenecks and suggests whether indexes, join order, or other optimizations are needed.

Why this answer

The query execution plan reveals how the database engine processes joins and filters. By checking the plan, the analyst can identify the most selective filter and rearrange the join order to reduce the number of rows processed early, which is the most impactful first step. Optimizing join order leverages existing indexes without requiring schema changes or hardware upgrades.

Exam trap

CompTIA often tests the misconception that adding indexes or hardware is the immediate fix, when in fact analyzing the execution plan and adjusting join order is the cheapest and most effective first step.

How to eliminate wrong answers

Option A is wrong because subqueries often perform worse than joins in large-table scenarios, as they can lead to correlated subquery execution and repeated scans. Option C is wrong because adding indexes to all join columns is unnecessary and may degrade write performance; the analyst should first verify if existing indexes are being used efficiently via the execution plan. Option D is wrong because increasing server memory is a reactive, costly measure that does not address the root cause of inefficient query processing, such as poor join order or missing index usage.

Full explanation →

322

MCQmedium

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

A.Provide downloadable raw data

B.Use auto-refresh and clear alert thresholds

C.Include all historical data

D.Minimize use of color

AnswerB

Auto-refresh ensures data is current, and alerts draw attention to anomalies.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

Full explanation →

323

MCQmedium

A data analyst is working in Looker Studio and wants to add a metric that counts the number of unique customers per month. In the context of Looker Studio, which type of field is this metric?

A.Dimension

B.Parameter

C.Metric

D.Blend

AnswerC

Correct. COUNT_DISTINCT is a metric.

Why this answer

In Looker Studio, a metric is a field that aggregates numeric data, such as counts, sums, or averages. Counting unique customers per month requires an aggregation (COUNT_DISTINCT) applied to a numeric or identifier field, which is the defining characteristic of a metric. Dimensions are used for grouping and categorizing data, not for performing calculations like counting unique values.

Exam trap

The trap here is that candidates often confuse a dimension with a metric because they think 'customer' is a category (dimension), but the question specifically asks for a count of unique customers, which requires an aggregation, making it a metric.

How to eliminate wrong answers

Option A is wrong because a dimension is a field used to categorize, group, or filter data (e.g., customer name or month), not to perform aggregations like counting unique customers. Option B is wrong because a parameter is a user-defined input value that can be used to filter or modify queries dynamically, but it does not itself perform any aggregation or count. Option D is wrong because a blend is a technique to combine data from multiple sources or tables, not a field type that can directly count unique customers per month.

Full explanation →

324

MCQmedium

An analyst compares average sales across three different store locations using a statistical test. Which test is most appropriate?

A.ANOVA

B.t-test

C.Correlation analysis

D.Chi-square test

AnswerA

ANOVA compares means of three or more groups.

Why this answer

ANOVA compares means across three or more groups.

Full explanation →

325

MCQhard

An analyst finds that a key metric drops significantly after a data pipeline update. How should the analyst proceed?

A.Compare data before and after update to identify discrepancies

B.Assume it's a seasonal effect

C.Revert the pipeline immediately

D.Document the drop and report it

AnswerA

Comparison helps pinpoint the source of the drop.

Why this answer

The first step in diagnosing a sudden metric drop after a pipeline update is to perform a controlled comparison of pre- and post-update data. This involves validating data schemas, row counts, and distribution statistics to pinpoint whether the update introduced a transformation error, a filtering issue, or a data type mismatch. Without this comparison, the analyst cannot determine if the drop is due to a genuine data change or a pipeline defect.

Exam trap

The trap here is that candidates may choose to revert the pipeline immediately (Option C) out of panic, but the DA0-001 exam emphasizes a systematic troubleshooting approach over reactive rollbacks.

How to eliminate wrong answers

Option B is wrong because assuming a seasonal effect without evidence ignores the temporal correlation with the pipeline update; seasonality should be tested via historical trend analysis, not assumed. Option C is wrong because reverting the pipeline immediately risks losing the update's intended improvements and may not address the root cause if the drop is due to a downstream system change or data source issue. Option D is wrong because merely documenting and reporting the drop without investigation fails the core responsibility of a data analyst to diagnose and resolve data quality issues, especially when a known change occurred.

Full explanation →

326

MCQeasy

A data analyst wants to compare the total sales of four different product categories for a single year. Which chart type is most appropriate for this comparison?

A.Pie chart

B.Scatter plot

C.Line chart

D.Bar chart

AnswerD

Correct. Bar charts are best for comparing values across categories.

Why this answer

A bar chart is ideal for comparing discrete categories because the length of each bar represents the total value, making it easy to see which category has the highest sales.

Full explanation →

327

MCQeasy

A retail company stores customer transaction data in a relational database. They want to analyze purchasing patterns over time. Which type of data structure best supports this analysis?

A.Relational table

B.Graph database

C.Document store

D.Key-value store

AnswerA

Relational tables with SQL support are excellent for structured data and time-series analysis.

Why this answer

A relational table is the correct choice because it organizes transaction data into structured rows and columns with defined schemas, enabling efficient SQL-based queries for time-series analysis (e.g., aggregating purchases by date, customer, or product). The relational model supports ACID transactions and joins across related tables (e.g., customers, products, transactions), which is essential for analyzing purchasing patterns over time while maintaining data integrity.

Exam trap

The trap here is that candidates may confuse 'analyzing purchasing patterns over time' with needing a graph database for relationships, but the key requirement is structured time-series aggregation, which is a core strength of relational tables, not graph or NoSQL stores.

How to eliminate wrong answers

Option B (Graph database) is wrong because graph databases excel at modeling relationships between entities (e.g., social networks or recommendation engines) but are not optimized for time-series aggregation or range queries on structured transaction data; they lack native support for SQL-style GROUP BY and window functions. Option C (Document store) is wrong because document stores (e.g., MongoDB) store semi-structured JSON-like documents, which can lead to data duplication and complex aggregation pipelines for time-based analysis, and they typically do not enforce strict schemas or support ACID transactions across multiple collections. Option D (Key-value store) is wrong because key-value stores (e.g., Redis) provide fast lookups by a single key but cannot efficiently query on multiple attributes (e.g., date range, product category) or perform relational joins, making them unsuitable for analytical queries on purchasing patterns.

Full explanation →

328

MCQhard

During a data mining project, an analyst discovers that a significant number of records have a negative value for the age field. What is the most appropriate first step?

A.Impute using regression.

B.Replace negative age with the mean age.

C.Investigate the source system for data entry errors.

D.Remove all records with negative age.

AnswerC

Determining why negative ages occur enables targeted correction and prevents future errors.

Why this answer

The first step in handling anomalous data like negative ages is to investigate the source system for data entry errors. This aligns with the data mining process, where understanding the root cause of data quality issues is critical before applying any imputation or removal techniques. Without investigation, you risk masking systemic problems that could affect all records.

Exam trap

The trap here is that candidates often jump to data cleaning techniques like imputation or removal without first verifying whether the anomaly is a data quality issue or a legitimate value, which the DA0-001 exam tests by emphasizing the investigative step as the most appropriate first action.

How to eliminate wrong answers

Option A is wrong because imputing using regression assumes the negative values are missing at random and that other variables can predict age, which is inappropriate when the negative values likely indicate a data entry error rather than missing data. Option B is wrong because replacing negative age with the mean age introduces bias and does not address the underlying cause; it also assumes the negative values are outliers rather than errors. Option D is wrong because removing all records with negative age could discard valid data if the negative values are due to a correctable entry mistake, and it reduces sample size without solving the root issue.

Full explanation →

329

Multi-Selecthard

A data analyst is evaluating the quality of a customer database. Which THREE of the following are dimensions of data quality?

Select 3 answers

A.Completeness

B.Correlation

C.Timeliness

D.Accuracy

E.Variance

AnswersA, C, D

Whether all required data is present.

Why this answer

Accuracy, completeness, and timeliness are standard data quality dimensions.

Full explanation →

330

MCQeasy

A data analyst at a marketing agency is working with a dataset containing customer demographics, purchase history, and social media engagement metrics. The agency wants to perform sentiment analysis on unstructured social media comments to identify brand perception. The dataset also includes structured fields like age, income, and purchase amounts. The analyst needs to choose a storage and processing platform that can handle both structured and unstructured data efficiently without requiring extensive schema definition upfront. Which platform should the analyst recommend?

A.Relational database (RDBMS)

B.Data lake

C.Data warehouse

D.NoSQL document database

AnswerB

Correct: Data lakes store raw data in native format and support schema-on-read for both structured and unstructured.

Why this answer

A data lake is the correct choice because it can store both structured data (e.g., age, income, purchase amounts) and unstructured data (e.g., social media comments) in its native format without requiring a predefined schema. This flexibility allows the analyst to ingest raw social media text for sentiment analysis and later apply schema-on-read for structured queries, avoiding the upfront schema definition needed by other platforms.

Exam trap

The trap here is that candidates often confuse a data warehouse with a data lake, assuming both can handle unstructured data, but a data warehouse requires structured, transformed data and cannot natively store raw social media comments without prior schema definition.

How to eliminate wrong answers

Option A is wrong because a relational database (RDBMS) requires a rigid, predefined schema and is optimized for structured data, making it inefficient for storing and processing unstructured social media comments without extensive ETL. Option C is wrong because a data warehouse is designed for structured, processed data and typically uses a schema-on-write approach, which cannot natively handle unstructured text like social media comments without significant transformation. Option D is wrong because a NoSQL document database can store semi-structured data (e.g., JSON) but is not optimized for large-scale, raw unstructured text and lacks the integrated processing capabilities (e.g., Apache Spark or Hadoop) that a data lake provides for sentiment analysis.

Full explanation →

331

MCQeasy

Which data quality dimension ensures that data represents the real-world object or event correctly?

A.Accuracy

B.Completeness

C.Consistency

D.Timeliness

AnswerA

Correct definition.

Why this answer

Accuracy refers to how well data reflects reality.

Full explanation →

332

MCQmedium

A data analyst is building a dashboard in Tableau and wants to allow users to select a specific product category and have all charts on the dashboard filter to that category. Which Tableau feature should be used?

A.Calculated field

B.LOD expression

C.Parameter

D.Dashboard action

AnswerD

Dashboard actions enable cross-sheet filtering.

Why this answer

Dashboard actions in Tableau enable interactivity such as filtering across sheets based on user clicks.

Full explanation →

333

MCQeasy

Which of the following is a characteristic of structured data?

A.It conforms to a fixed schema with rows and columns.

B.It has a flexible schema that can vary per record.

C.It cannot be analyzed using SQL.

D.It is stored as blobs in a data lake.

AnswerA

Correct definition of structured data.

Why this answer

Structured data is defined by its adherence to a fixed schema, typically organized into rows and columns within relational databases. This rigid structure enables efficient querying and manipulation using SQL, as each field has a predefined data type and constraints. The correct answer highlights this fundamental characteristic, which distinguishes structured data from semi-structured or unstructured formats.

Exam trap

The trap here is that candidates often confuse semi-structured data (which has some organizational tags but no fixed schema) with structured data, leading them to select Option B, or they mistakenly think SQL cannot analyze structured data, falling for Option C.

How to eliminate wrong answers

Option B is wrong because a flexible schema that can vary per record describes semi-structured data (e.g., JSON, XML), not structured data. Option C is wrong because structured data is specifically designed to be analyzed using SQL, which is the primary query language for relational databases. Option D is wrong because storing data as blobs in a data lake is characteristic of unstructured data (e.g., images, videos), not structured data, which is stored in tables with defined schemas.

Full explanation →

334

MCQmedium

A data analyst is performing time series analysis on monthly sales data and notices a consistent pattern of higher sales every December. Which component of time series does this represent?

A.Trend

B.Irregular component

C.Seasonality

D.Cyclical

AnswerC

Seasonality is regular periodic pattern.

Why this answer

Seasonality refers to regular patterns that repeat at fixed intervals, such as yearly.

Full explanation →

335

Multi-Selectmedium

A data analyst is merging two datasets from different departments. The analyst notices that the 'CustomerID' field in the first dataset is stored as an integer, while in the second dataset it is stored as a string with leading zeros. Which TWO steps should the analyst take to ensure successful data integration?

Select 2 answers

A.Perform the merge directly without transformation since databases handle type conversions automatically.

B.Strip all non-numeric characters from the string CustomerID before joining.

C.Use a left join and treat the CustomerID as a string after conversion.

D.Convert the string CustomerID to an integer by removing leading zeros.

E.Convert the integer CustomerID to a string with leading zeros to match the format in the second dataset.

AnswersC, E

A left join requires matching keys; converting to string ensures compatibility.

Why this answer

Converting the integer CustomerID to a string ensures both datasets have a compatible data type for the join. This approach preserves the leading zeros in the second dataset, which are semantically significant (e.g., '00123' vs. 123). A left join is appropriate to retain all records from the primary dataset while matching on the converted key.

Exam trap

The trap here is that candidates assume implicit type conversion will handle the join correctly, but they overlook that leading zeros are lost during conversion, causing silent data loss or incorrect matches.

Full explanation →

336

MCQhard

In a table 'sales_team' with columns 'salesperson', 'quarter', and 'revenue', an analyst wants to assign a rank to each salesperson within their quarter based on revenue, with the highest revenue getting rank 1. However, if two salespeople have the same revenue, they should receive the same rank, and the next rank should be the next consecutive integer (no gaps). Which window function should be used?

A.RANK()

B.NTILE(4)

C.DENSE_RANK()

D.ROW_NUMBER()

AnswerC

DENSE_RANK() assigns consecutive ranks even with ties.

Why this answer

DENSE_RANK() assigns ranks with no gaps for ties, whereas RANK() leaves gaps.

Full explanation →

337

MCQmedium

Refer to the exhibit. What is the most likely issue causing the unexpectedly low count?

A.The customers table is indexed incorrectly

B.The query is missing a GROUP BY clause

C.The database was not refreshed

D.The signup_date column is in a different date format

AnswerD

Format mismatch causes filter mismatch.

Why this answer

If the signup_date column is stored in a different date format (e.g., MM/DD/YYYY), the comparison with '2023-01-01' (YYYY-MM-DD) may not match many records, leading to an unexpectedly low count. Option A is incorrect because indexing affects performance, not the correctness of the count. Option B is incorrect because COUNT(*) aggregates all rows and does not require a GROUP BY clause.

Option C is incorrect because a database refresh typically updates data but does not directly cause a mismatch in date comparisons.

Full explanation →

338

MCQmedium

A company ingests customer clickstream data from its website. The data arrives continuously in JSON format and must be stored for real-time analytics. Which type of data source is being described?

A.Transactional database

B.Flat file

C.Data warehouse

D.Streaming data

AnswerD

Correct: continuous data from clickstreams.

Why this answer

The description matches a streaming data source because clickstream data arrives continuously in JSON format and must be stored for real-time analytics. Streaming data sources, such as Apache Kafka or Amazon Kinesis, ingest unbounded data in real time, enabling immediate processing and analytics without batch delays.

Exam trap

CompTIA Data+ often tests the distinction between 'streaming data' and 'data warehouse' by describing continuous ingestion, leading candidates to mistakenly choose 'data warehouse' because they associate analytics with warehousing, ignoring the real-time requirement.

How to eliminate wrong answers

Option A is wrong because a transactional database (e.g., OLTP system) is designed for ACID-compliant transaction processing, not for ingesting continuous, high-velocity streaming data. Option B is wrong because a flat file (e.g., CSV or text file) is a static, batch-oriented storage format that cannot handle real-time, continuous ingestion without manual intervention or scheduled loads. Option C is wrong because a data warehouse is optimized for structured, historical analytics and typically relies on batch ETL processes, not real-time streaming ingestion from clickstream sources.

Full explanation →

339

Multi-Selectmedium

A data analyst is exploring a sales dataset and wants to identify columns that are likely to be foreign keys. Which TWO characteristics would indicate a foreign key?

Select 2 answers

A.The column name ends with '_id'

B.The column contains NULL values

C.The column is of integer data type

D.The column values are a subset of a primary key column in another table

E.The column has a UNIQUE constraint

AnswersA, D

Often foreign keys are named with '_id' suffix.

Why this answer

Foreign keys typically match primary keys in another table and have a name suggestive of the relationship.

Full explanation →

340

Multi-Selecthard

A data analyst is cleaning a dataset and identifies several outliers. Which TWO methods are appropriate for handling outliers?

Select 2 answers

A.Capping

B.Mean imputation

C.Removal

D.Min-max normalization

E.Forward-fill

AnswersA, C

Replaces outliers with a threshold value.

Why this answer

Capping (winsorizing) and removal are common outlier treatments. Mean imputation is for missing values, and min-max normalization is scaling.

Full explanation →

341

MCQmedium

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

A.Use a single aggregated metric to simplify.

B.Increase the refresh rate to every hour.

C.Incorporate conditional formatting with color alerts.

D.Add more detailed charts to each KPI.

AnswerC

Color alerts draw immediate attention to deviations from targets, enabling quick identification.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

Full explanation →

342

MCQmedium

A data analyst is examining sales data for a retail chain and notices that the mean monthly sales is $50,000 while the median is $35,000. Which of the following best describes the distribution of the sales data?

A.The distribution is right-skewed.

B.The distribution is bimodal.

C.The distribution is left-skewed.

D.The distribution is symmetrical.

AnswerA

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 the mean is pulled towards the higher values by outliers or a long right tail.

Full explanation →

343

MCQhard

A financial institution needs to acquire credit transaction data from multiple sources while ensuring compliance with data privacy regulations. What is the most critical step?

A.Data replication for redundancy

B.Data enrichment with external sources

C.Data compression for storage

D.Data anonymization during extraction

AnswerD

Ensures sensitive information is protected early.

Why this answer

Data anonymization during extraction is the most critical step because it ensures that personally identifiable information (PII) is irreversibly masked or removed before the data enters the processing pipeline, directly addressing compliance with regulations such as GDPR and PCI DSS. Without this step, even if other measures are applied later, the initial exposure of sensitive data violates privacy mandates and increases breach risk.

Exam trap

The trap here is that candidates confuse operational efficiency measures (replication, compression) or data enhancement (enrichment) with privacy compliance, overlooking that anonymization must be applied at the earliest point of data acquisition to satisfy regulatory requirements.

How to eliminate wrong answers

Option A is wrong because data replication for redundancy focuses on high availability and disaster recovery, not on privacy compliance; it does not prevent exposure of sensitive credit transaction data. Option B is wrong because data enrichment with external sources typically adds more data attributes, which can increase privacy risk and regulatory exposure rather than ensuring compliance. Option C is wrong because data compression for storage reduces storage footprint and may improve I/O performance but has no effect on data privacy or regulatory compliance.

Full explanation →

344

MCQeasy

A company receives daily sales data in CSV format. The data includes a 'Date' column in MM/DD/YYYY format. To load this into a database that expects YYYY-MM-DD, the analyst should:

A.Manually edit the CSV files before loading

B.Change the database schema to accept MM/DD/YYYY

C.Ignore the date column and use a default date

D.Use a data transformation tool to convert the date format during ETL

AnswerD

Transformation tools automate the conversion and ensure consistency.

Why this answer

(use a data transformation tool) is the standard practice during ETL to convert date formats programmatically. Option A (manually edit) is inefficient and error-prone. Option B (change schema) would require altering the database and may cause compatibility issues.

Option C (ignore) loses data integrity.

Full explanation →

345

MCQhard

A retail company is acquiring sales data from 150 stores worldwide. Each store sends daily CSV files via email to a central email address. The data acquisition process is manual: an intern downloads each attachment and copies it into a shared folder. The shared folder is then accessed by an ETL tool that loads data into a data warehouse. Recently, the data warehouse has been missing records for several stores. The intern reports that some emails are not being received or are delayed. The company needs to improve the reliability and timeliness of data acquisition. Which course of action should be taken first?

A.Train the intern to check email more frequently and manually verify all attachments.

B.Replace the email method with a web-based API that stores push data in real-time.

C.Implement an automated email parser that downloads attachments and moves them to the shared folder.

D.Require stores to upload CSV files directly to a cloud-based storage bucket.

AnswerD

Eliminates email dependency and manual steps.

Why this answer

Requiring stores to upload CSV files directly to a cloud-based storage bucket eliminates dependency on email and manual intervention, addressing the root cause of missing records due to email delays or non-receipt. This approach improves reliability and timeliness. Option A is wrong because it still relies on email and increases manual effort.

Option B, while potentially effective, is more complex to implement as a first step compared to switching to cloud uploads. Option C is wrong because automating email parsing still depends on email reliability, which is the underlying problem.

Full explanation →

346

MCQmedium

When presenting data insights to a technical audience, which of the following is most important to include?

A.A call to action for the next steps.

B.Details on data sources, transformations, and methodology.

C.Colorful charts and infographics.

D.High-level summaries and executive recommendations.

AnswerB

Correct. This builds credibility and allows verification.

Why this answer

For a technical audience, the most important element is transparency in data provenance and methodology, as they need to assess the validity and reproducibility of the analysis. Including details on data sources, transformations, and methodology allows them to verify assumptions, identify potential biases, and understand the analytical pipeline. This aligns with the DA0-001 domain of Communicating Data Insights, where technical stakeholders require rigorous documentation over persuasive elements.

Exam trap

The trap here is that candidates confuse the needs of a technical audience with those of a non-technical audience, assuming that all presentations should prioritize high-level summaries or visual appeal, when in fact technical stakeholders demand methodological transparency.

How to eliminate wrong answers

Option A is wrong because a call to action is more relevant for executive or non-technical audiences who need to make decisions, not for technical audiences who prioritize understanding the data's integrity. Option C is wrong because colorful charts and infographics, while visually appealing, can obscure technical details and are less critical than precise methodological documentation for a technical audience. Option D is wrong because high-level summaries and executive recommendations are tailored for business stakeholders, not for technical audiences who require granular details to evaluate the analysis's soundness.

Full explanation →

347

MCQmedium

An executive dashboard needs to display key performance indicators (KPIs) such as sales growth and customer satisfaction. Which design principle is most important?

A.Consistent color encoding for similar metrics

B.Use gauges for each KPI

C.Include all raw data in the dashboard

D.Animate charts to draw attention

AnswerA

Consistent colors reduce cognitive load and improve interpretation.

Why this answer

Consistent color coding helps viewers quickly associate colors with metrics across multiple charts.

Full explanation →

348

MCQhard

A data analyst is building a report in Power BI and needs to create a measure that calculates the total sales for the current year, but only for products that have at least one sale in the previous year. Which DAX function combination is most appropriate?

A.RELATED to pull product data

B.TOTALYTD with a filter on Date table

C.SUMX with a FILTER on Sales table

D.CALCULATE with FILTER and SAMEPERIODLASTYEAR

AnswerD

CALCULATE modifies the filter context, and FILTER combined with SAMEPERIODLASTYEAR identifies products with prior year sales.

Why this answer

Using CALCULATE with a FILTER that checks for sales in the previous year via SAMEPERIODLASTYEAR or a similar time intelligence filter achieves this dynamic filtering.

Full explanation →

349

MCQmedium

Refer to the exhibit. A data analyst notices that direct S3 access to files outside the "incoming/" prefix is blocked. Which data governance principle does this policy enforce?

A.Data colocation

B.Data retention

C.Data access control

D.Data encryption

AnswerC

The policy restricts which objects can be accessed, controlling access based on prefix.

Why this answer

The policy blocks direct S3 access to files outside the 'incoming/' prefix, which restricts which users or roles can read or write objects in specific S3 prefixes. This is a classic implementation of data access control, as it enforces permissions based on the resource path, ensuring only authorized operations are allowed on designated data. In AWS S3, such restrictions are typically applied via bucket policies or IAM policies that use conditions like `s3:prefix` to limit access.

Exam trap

CompTIA often tests the distinction between access control and encryption by presenting a policy that restricts access based on a path or condition, leading candidates to confuse it with data encryption, which is about scrambling data rather than authorizing access.

How to eliminate wrong answers

Option A is wrong because data colocation refers to physically or logically placing related data together for performance or compliance, not to restricting access based on a prefix. Option B is wrong because data retention governs how long data is kept (e.g., lifecycle policies or retention periods), not who can access it. Option D is wrong because data encryption protects data at rest or in transit (e.g., using SSE-S3 or TLS), but the policy described does not mention encryption keys, algorithms, or any cryptographic controls.

Full explanation →

350

Multi-Selectmedium

A data analyst is evaluating data quality issues during acquisition. Which TWO issues are most likely to arise from merging data from different sources? (Select exactly 2)

Select 2 answers

A.User access permissions

B.Duplicate records

C.Slow network speed

D.High storage cost

E.Formatting inconsistencies

AnswersB, E

Common when merging overlapping data.

Why this answer

Options B and E are correct because merging data from different sources often leads to duplicate records (the same entity represented differently across sources) and formatting inconsistencies (such as different date formats, units of measurement, or naming conventions). Option A is wrong: user access permissions are a security concern, not a direct data quality issue arising from merging. Option C is wrong: slow network speed is a performance or infrastructure issue, not a data quality issue.

Option D is wrong: high storage cost is a cost consideration, not a data quality issue.

Full explanation →

351

MCQhard

A data analyst includes a map showing customer locations by zip code. The map reveals exact addresses for a few customers due to data granularity. This violates which principle?

A.Anonymization

B.Informed consent

C.Data minimization

D.Data quality

AnswerA

The map should have been anonymized to avoid revealing individual addresses.

Why this answer

The map reveals exact addresses for a few customers due to the granularity of zip code data. This directly violates the principle of anonymization, which requires that data be processed in such a way that individuals cannot be identified. By exposing precise locations, the data is no longer anonymized, as it allows re-identification of specific individuals.

Exam trap

The trap here is that candidates confuse anonymization with data minimization, thinking the issue is collecting too much data, when the real problem is failing to sufficiently generalize or mask the data to prevent re-identification.

How to eliminate wrong answers

Option B is wrong because informed consent relates to obtaining permission from individuals before collecting or using their data, not to the technical process of preventing re-identification through granularity. Option C is wrong because data minimization focuses on collecting only the data necessary for a specific purpose, but the violation here is not about collecting too much data—it is about failing to anonymize the data that was collected. Option D is wrong because data quality refers to accuracy, completeness, and consistency of data, not to the privacy or anonymization of the data; the map may be perfectly accurate yet still violate anonymization.

Full explanation →

352

MCQhard

A data audit reveals that some numbers in the "Revenue" column were manually entered from PDF invoices. This introduces potential errors. Which data concept is being addressed?

A.Data lineage

B.Data quality

C.Data security

D.Data governance

AnswerB

Data quality assesses the accuracy, completeness, and reliability of data. Manual entry from PDF invoices introduces potential errors, directly impacting data quality. Thus, this is the correct concept being addressed.

Why this answer

The scenario describes a data audit that identifies potential errors from manual data entry from PDF invoices. This directly relates to data quality, which assesses aspects like accuracy, completeness, and consistency. The audit is highlighting a quality concern (potential errors), not lineage tracking.

Data lineage focuses on the origin and transformation of data, but the primary issue here is the risk of inaccuracies, making data quality the correct concept.

Exam trap

Candidates may see the mention of 'audit' and 'origin' and incorrectly choose data lineage. However, the key issue is the potential errors from manual entry, which is a data quality concern. The audit is identifying a quality problem, not tracing the data's path.

How to eliminate wrong answers

Option A is wrong because data lineage tracks the origin, movement, and transformation of data through its lifecycle, not the potential errors from manual entry. Option C is wrong because data security focuses on protecting data from unauthorized access, breaches, or corruption, not on the accuracy of manually entered values. Option D is wrong because data governance defines policies, roles, and procedures for managing data assets, but the specific issue of manual entry errors falls under data quality assessment, not governance frameworks.

Full explanation →

353

MCQhard

A data analyst is using pandas to clean a DataFrame. They need to replace missing values in the 'age' column with the median age. Which method should they use?

A.df['age'].replace(np.nan, df['age'].mean())

B.df['age'].dropna()

C.df['age'].fillna(df['age'].median())

D.df['age'].interpolate()

AnswerC

Correctly fills NaN with median.

Why this answer

fillna() with median() fills NaN values with the median of the column.

Full explanation →

354

MCQeasy

A data analyst is tasked with collecting data from a web API that returns JSON. The API requires an API key in the header. Which method should be used to authenticate?

A.Use a session cookie

B.Add the API key in the HTTP header as 'Authorization: Bearer <key>'

C.Store the API key in the database and reference it

D.Include the API key in the URL query string

AnswerB

Standard bearer token authentication is secure and widely used.

Why this answer

The correct method is to include the API key in the HTTP header using the 'Authorization: Bearer <key>' format. This is the standard approach for token-based authentication in REST APIs, as defined by RFC 6750. It keeps the credential out of URLs and logs, and is the expected mechanism for API key authentication in modern web APIs.

Exam trap

CompTIA often tests the distinction between authentication methods, and the trap here is that candidates may confuse storing credentials (Option C) with transmitting them, or think that query strings (Option D) are acceptable because they work technically, ignoring security and standard practices.

How to eliminate wrong answers

Option A is wrong because session cookies are used for stateful web application sessions, not for stateless API authentication with a fixed API key; cookies are typically managed by the server and browser, not suitable for programmatic API calls. Option C is wrong because storing the API key in a database and referencing it describes a storage mechanism, not an authentication method sent in the request; the key must be transmitted with each API call, not just stored. Option D is wrong because including the API key in the URL query string exposes the key in server logs, browser history, and is less secure; it violates best practices and is not the standard method for API key authentication.

Full explanation →

355

MCQhard

A data analyst is cleaning a dataset and finds that 5% of values in the 'income' column are missing. The analyst decides to impute missing values using the mean of the non-missing values. Which potential issue should the analyst be most concerned about?

A.The imputation may reduce the variance and distort the distribution.

B.The imputation is not valid because the missing rate is too low.

C.The imputation will increase the standard deviation of the variable.

D.The imputation will create outliers.

AnswerA

Mean imputation pulls values toward the mean, reducing variance and potentially biasing results.

Why this answer

Mean imputation reduces variance and can distort relationships, especially if data is skewed. It may also bias estimates if missingness is not random.

Full explanation →

356

MCQeasy

Which chart type is best for showing the sales pipeline from leads to closed deals, illustrating how many prospects drop off at each stage?

A.Treemap

B.Funnel chart

C.Waterfall chart

D.Stacked bar chart

AnswerB

Funnel charts visualize pipeline stages and conversion.

Why this answer

A funnel chart is specifically designed to show conversion or drop-off rates in a pipeline.

Full explanation →

357

MCQmedium

The exhibit shows a JSON schema for a dataset. Which statement correctly describes the data types represented?

A.All fields are qualitative

B.age and income are continuous; customer_id and education are discrete

C.customer_id and age are discrete quantitative; income is continuous quantitative; education is qualitative

D.All fields are quantitative

AnswerA

Correct. All fields are qualitative: customer_id (nominal), education (ordinal), age and income (treated as ordinal categories).

Why this answer

All fields in the dataset are qualitative (categorical or nominal). customer_id is a unique identifier (nominal), education is a categorical variable, age is often grouped into categories (ordinal), and income is typically treated as ordinal when bucketed into ranges. Despite being stored as numbers, age and income are not used for arithmetic in typical data analysis, making them qualitative.

Exam trap

The trap is that candidates assume numeric fields like age and income are quantitative, but in this context they are treated as qualitative categories. Customer_id is a nominal identifier, not a number to be averaged.

How to eliminate wrong answers

Option A is wrong because it claims all fields are qualitative, but age, income, and customer_id are quantitative (numeric) fields, not categorical. Option B is wrong because it states age and income are continuous, but age is discrete (countable integer values) and customer_id is discrete quantitative, not qualitative; it also misclassifies education as discrete instead of qualitative. Option D is wrong because it claims all fields are quantitative, but education is a string field representing categorical data, which is qualitative.

Full explanation →

358

MCQmedium

An organization is integrating data from multiple sources into a data warehouse. They need to handle differences in data granularity (e.g., daily vs. hourly sales data). Which technique is most appropriate?

A.Data aggregation

B.Data normalization

C.Data deduplication

D.Data profiling

AnswerA

Aggregation rolls up data to a consistent level.

Why this answer

Data aggregation is the correct technique because it allows the organization to roll up hourly sales data to a daily granularity, ensuring consistency when integrating sources with different levels of detail. By applying aggregation functions (e.g., SUM, AVG) during the ETL process, the data warehouse can store all data at a common grain, which is essential for accurate reporting and analysis.

Exam trap

The trap here is that candidates may confuse data normalization (a schema design concept) with the need to standardize data granularity, leading them to incorrectly select normalization instead of aggregation.

How to eliminate wrong answers

Option B is wrong because data normalization is a database design technique used to reduce redundancy and dependency by organizing columns and tables, not to reconcile differences in data granularity. Option C is wrong because data deduplication focuses on identifying and removing duplicate records, which does not address the mismatch in time-based granularity between daily and hourly data. Option D is wrong because data profiling is an exploratory process to assess data quality and structure, but it does not transform or harmonize data to a common granularity level.

Full explanation →

359

MCQhard

A data analyst creates a bar chart to compare average customer satisfaction scores across five departments. The chart shows very tall bars for three departments and very short bars for two departments, making differences hard to assess. What is the most likely cause and the best fix?

A.The chart should group departments by region to reduce variance

B.The y-axis does not start at zero; reset it to zero

C.The data should be visualized as a line chart instead

D.The bar chart should be replaced with a 3D version for better depth

AnswerB

Starting the axis at zero prevents misleading comparisons; non-zero start exaggerates differences.

Why this answer

A bar chart's y-axis should start at zero to accurately represent proportions; a truncated y-axis can exaggerate differences between bars. Option A is wrong because grouping by region does not address the axis scaling issue. Option C is wrong because a line chart is not suitable for comparing discrete categories.

Option D is wrong because 3D charts can introduce visual distortion and are not recommended.

Full explanation →

360

Multi-Selecteasy

An organization is implementing a data lake to store raw data from various sources. Which THREE characteristics are typically associated with a data lake compared to a data warehouse?

Select 3 answers

A.Supports batch and real-time processing

B.Stores data in its native format

C.Schema-on-read approach

D.Supports only structured data

E.Requires data transformation before loading

AnswersA, B, C

Correct: Data lakes handle both processing modes.

Why this answer

Data lakes are designed to ingest and process data in both batch and real-time streaming modes, unlike data warehouses which primarily handle batch ETL workloads. This flexibility is enabled by technologies like Apache Kafka for streaming and Apache Spark for batch processing, allowing the data lake to support diverse ingestion patterns without pre-schematization.

Exam trap

CompTIA often tests the misconception that data lakes require data transformation before loading (schema-on-write), when in fact they use schema-on-read, allowing raw data storage without upfront transformation.

Full explanation →

361

MCQhard

In Tableau, you want to create a view showing the total sales per region, but also want to allow users to filter by year without losing the ability to see all regions. What feature should you use to compute the total sales that ignores the year filter?

A.Table calculation running total

B.Parameter action

C.LOD expression: { FIXED [Region] : SUM([Sales]) }

D.Calculated field using SUM([Sales])

AnswerC

This computes total sales per region ignoring other dimensions.

Why this answer

A Level of Detail (LOD) expression with FIXED can compute a value at the region level, ignoring other dimensions like year.

Full explanation →

362

Multi-Selectmedium

A company needs to store data that is highly interconnected, such as social network relationships. Which two database types are best suited for this? (Select TWO.)

Select 2 answers

A.Relational database

B.Wide-column store (e.g., Cassandra)

C.Document store (e.g., MongoDB)

D.Graph database (e.g., Neo4j)

E.Key-value store (e.g., Redis)

AnswersC, D

Document stores can embed related data and are flexible for interconnected data.

Why this answer

Graph databases excel at storing relationships, and NoSQL databases support flexible schemas for interconnected data.

Full explanation →

363

MCQmedium

A dataset contains a variable 'Income' with many missing values. The analyst decides to impute missing values with the median income of the non-missing values. Which type of imputation is this?

A.Interpolation

B.Deletion

C.Median imputation

D.Forward-fill imputation

AnswerC

Correct term.

Why this answer

Replacing missing values with the median is a form of mean/median/mode imputation.

Full explanation →

364

MCQmedium

A data analyst needs to extract the year from a column named 'order_date' in a SQL database. The database supports standard SQL functions. Which function should they use?

A.GET_YEAR(order_date)

B.YEAR(order_date)

C.DATE_PART('year', order_date)

D.EXTRACT(YEAR FROM order_date)

AnswerD

Correct standard SQL syntax.

Why this answer

The EXTRACT function is standard SQL for extracting date parts. EXTRACT(YEAR FROM order_date) returns the year.

Full explanation →

365

MCQmedium

A business analyst needs to explain to a sales director that the reported revenue has a 95% confidence interval of ±2%. Which concept is being communicated?

A.Data governance

B.Uncertainty communication

C.Single version of truth

D.Data lineage

AnswerB

Correct. Confidence intervals communicate uncertainty.

Why this answer

Confidence intervals quantify the uncertainty around a metric, conveying that the true value may vary.

Full explanation →

366

MCQmedium

A data analyst wants to generate a report showing employee names and their department names, but some employees are not assigned to any department. The analyst wants to include all employees. Which JOIN type should be used?

A.INNER JOIN

B.LEFT JOIN

C.CROSS JOIN

D.RIGHT JOIN

AnswerB

LEFT JOIN includes all employees, even those without a department.

Why this answer

LEFT JOIN includes all rows from the left table (employees) even if no match in departments.

Full explanation →

367

MCQeasy

A data analyst needs to identify outliers in a dataset. Which of the following is a common method based on the interquartile range (IQR)?

A.Values more than 2 standard deviations from the mean

B.Values that are negative

C.Values below Q1 - 1.5*IQR or above Q3 + 1.5*IQR

D.Values below the 5th percentile or above the 95th percentile

AnswerC

Correct: IQR method.

Why this answer

A common rule is to consider any data point below Q1 - 1.5*IQR or above Q3 + 1.5*IQR as an outlier.

Full explanation →

368

MCQeasy

A data analyst needs to count the number of distinct product categories in a table named 'products'. Which SQL function should be used in the SELECT clause?

A.COUNT(category)

B.DISTINCT COUNT(category)

C.COUNT(DISTINCT category)

D.COUNT(*) WHERE category IS NOT NULL

AnswerC

This counts only unique non-null categories.

Why this answer

COUNT(DISTINCT column) counts unique non-null values in a column.

Full explanation →

369

Multi-Selecthard

Which THREE of the following are assumptions of linear regression? (Select THREE).

Select 3 answers

A.Normal distribution of independent variables

B.Multicollinearity among independent variables

C.Independence of errors

D.Homoscedasticity (constant variance of errors)

E.Linearity between independent and dependent variables

AnswersC, D, E

Errors should be independent.

Why this answer

Independence of errors is a core assumption of linear regression, meaning the residuals (errors) should not be correlated with each other. This is critical for valid inference because correlated errors violate the Gauss-Markov theorem, leading to biased standard errors and unreliable hypothesis tests. In time series data, this assumption is often violated due to autocorrelation, which can be detected using the Durbin-Watson test.

Exam trap

The trap here is that candidates confuse the normality assumption for errors with a normality assumption for the independent variables, leading them to incorrectly select Option A.

Full explanation →

370

Multi-Selecteasy

Which TWO of the following are examples of supervised learning algorithms?

Select 2 answers

A.Linear regression

B.K-means clustering

C.Principal component analysis (PCA)

D.Decision trees

E.Apriori algorithm

AnswersA, D

Supervised regression algorithm.

Why this answer

Linear regression is a supervised learning algorithm because it learns a mapping from input features to a continuous target variable using labeled training data. The model minimizes the difference between predicted and actual values (e.g., via ordinary least squares) to make predictions on new data.

Exam trap

CompTIA often tests the distinction between supervised and unsupervised learning by including clustering (K-means) and association (Apriori) as distractors, which candidates mistakenly think are supervised because they involve pattern discovery.

Full explanation →

371

MCQeasy

A dashboard should be designed so that the most important metric is prominently displayed. This is an example of which design principle?

A.Data-ink ratio

B.Consistent color coding

C.Appropriate precision

D.Visual hierarchy

AnswerD

Visual hierarchy arranges elements by importance.

Why this answer

Visual hierarchy is the design principle that dictates arranging elements to guide the viewer's eye to the most important information first. By making the key metric the most prominent element (e.g., larger, bolder, or top-left), the dashboard ensures immediate comprehension of the primary data point, which is critical for operational decision-making.

Exam trap

In the data-plus exam, visual hierarchy is often contrasted with data-ink ratio. Candidates may confuse 'making a metric prominent' with 'reducing non-data ink,' but the former is about emphasis while the latter is about eliminating visual clutter.

How to eliminate wrong answers

Option A is wrong because the data-ink ratio focuses on minimizing non-data ink (e.g., gridlines, borders) to maximize the proportion of ink used for actual data, not on emphasizing a specific metric. Option B is wrong because consistent color coding ensures that the same color represents the same category across visualizations, aiding comparison, but it does not inherently prioritize one metric over others. Option C is wrong because appropriate precision refers to displaying data with the correct level of detail (e.g., rounding to whole numbers when decimals are unnecessary), not to the visual prominence of a metric.

Full explanation →

372

MCQeasy

A company needs to visualize the trend of monthly sales revenue over the past two years. Which chart type is most appropriate?

A.Bar chart

B.Scatter plot

C.Line chart

D.Pie chart

AnswerC

Line charts excel at displaying trends over continuous time.

Why this answer

(line chart) is correct because line charts are best for showing trends over time. Option A (bar chart) is more for comparing categories, Option B (scatter plot) shows relationships between variables, and Option D (pie chart) shows parts of a whole.

Full explanation →

373

MCQmedium

A data analyst is examining the relationship between advertising spend (in dollars) and revenue (in dollars). The Pearson correlation coefficient r is calculated as +0.92. Which of the following interpretations is correct?

A.There is a strong negative linear relationship.

B.There is no linear relationship.

C.There is a strong positive linear relationship.

D.92% of the variation in revenue is explained by advertising spend.

AnswerC

Close to +1 indicates strong positive.

Why this answer

r = +0.92 indicates a strong positive linear relationship.

Full explanation →

374

MCQmedium

A data analyst wants to extract the year from a date column 'order_date' in a SQL database. Which function should be used?

A.YEAR(order_date)

B.DATEADD(year, order_date, 0)

C.DATEDIFF(year, order_date, GETDATE())

D.GETDATE()

AnswerA

Returns the year portion of the date.

Why this answer

The YEAR() function extracts the year from a date. DATEADD adds intervals, DATEDIFF calculates differences, GETDATE() returns current date.

Full explanation →

375

MCQhard

A data analyst creates a heatmap to show website click-through rates by hour and day of week. The heatmap uses a green-to-red gradient, but users cannot distinguish between moderate values. What is the best fix?

A.Switch to a diverging color scheme with a neutral center

B.Remove all but the highest and lowest values

C.Add black borders around each cell

D.Increase the size of each heatmap cell

AnswerA

Diverging palettes highlight midpoints and differentiate values better.

Why this answer

A diverging color scheme with a neutral center (e.g., white or light gray) allows users to distinguish moderate values from extremes by providing a clear visual midpoint. The original green-to-red gradient is a sequential scheme that compresses moderate values into a narrow perceptual range, making them indistinguishable. Switching to a diverging palette solves this by mapping moderate values to the neutral center and extremes to the endpoints.

Exam trap

The trap here is that candidates often think adding visual elements (borders or size) or filtering data will fix color perception issues, when the core problem is the color scheme's inability to represent moderate values distinctly.

How to eliminate wrong answers

Option B is wrong because removing all but the highest and lowest values discards the majority of the data, destroying the heatmap's purpose of showing the full distribution of click-through rates. Option C is wrong because adding black borders around each cell improves cell separation but does not address the perceptual compression of moderate values in the color gradient. Option D is wrong because increasing cell size only enhances readability of individual cells, not the discriminability of color values within the gradient.

Full explanation →

Page 5 of 14

All pages

1 2 3 4 5 6 7 8 9 10 11 12 13 14

Practice DA0-002 by domain

Target a specific domain to shore up weak areas.

Data Concepts and Environments Data Analysis Visualization and Reporting Data Acquisition and Preparation Data Governance

See all domains with question counts →