CompTIA Data+ (DA0-001) — Questions and Answers

Question 1: In a box plot, what does the line inside the box represent?

Standard deviation
Mode
Median (Correct answer)
Mean

Correct answer: Median

The line inside the box of a box plot marks the median (Q2), the middle value of the dataset.

Question 2: In BI, what is a 'drill-down'?

Navigating from a summary level to more detailed underlying data (Correct answer)
Merging two reports together
Applying a date filter to a chart
Exporting a report to PDF

Correct answer: Navigating from a summary level to more detailed underlying data

Drill-down allows users to move from a high-level summary (e.g., annual sales) to more granular data (e.g., monthly or daily breakdown).

Question 3: What does MoM stand for in business analytics?

Mode of Market
Margin on Merchandise
Method of Measurement
Month-over-Month (Correct answer)

Correct answer: Month-over-Month

MoM (Month-over-Month) is a growth metric comparing a value in one month to the value in the previous month.

Question 4: What does a correlation coefficient of -0.9 indicate?

No relationship between variables
Strong negative relationship (Correct answer)
Weak positive relationship
Perfect positive relationship

Correct answer: Strong negative relationship

A correlation of -0.9 is close to -1, indicating a strong inverse relationship where one variable increases as the other decreases.

Question 5: What is churn rate?

The rate at which new customers are acquired
The number of support tickets opened monthly
The revenue generated per customer
The percentage of customers who stop using a product or service in a period (Correct answer)

Correct answer: The percentage of customers who stop using a product or service in a period

Churn rate measures the proportion of customers who discontinue a service within a given time frame.

Question 6: Which Python library is most commonly used for data visualization?

NumPy
Matplotlib (Correct answer)
Pandas
Scikit-learn

Correct answer: Matplotlib

Matplotlib is the foundational Python visualization library used to create line charts, bar charts, scatter plots, and more.

Question 7: What is a confidence interval?

The standard deviation of a sample
A range of values likely to contain the true population parameter (Correct answer)
The p-value expressed as a percentage
The exact true value of a population parameter

Correct answer: A range of values likely to contain the true population parameter

A confidence interval provides a range within which the true population parameter is expected to fall with a specified level of confidence.

Question 8: What does the SQL ORDER BY clause do?

Removes duplicate values
Filters rows meeting a condition
Groups rows by a column value
Sorts result rows by one or more columns (Correct answer)

Correct answer: Sorts result rows by one or more columns

ORDER BY sorts query results in ascending (ASC, default) or descending (DESC) order based on specified columns.

Question 9: What is a leading indicator?

A metric that reflects past performance
A forward-looking metric that predicts future outcomes (Correct answer)
A ratio comparing two revenue streams
A KPI measured on a monthly basis

Correct answer: A forward-looking metric that predicts future outcomes

Leading indicators are predictive metrics that signal future performance, allowing proactive action before outcomes occur.

Question 10: What Excel function counts cells that meet a specific condition?

SUMIF
COUNTIF (Correct answer)
AVERAGEIF
IFERROR

Correct answer: COUNTIF

COUNTIF counts the number of cells in a range that satisfy a given condition, such as counting all values above a threshold.

Question 11: What is the term used for predicting future trends in data mining?

Summarizing
Classification
Forecasting (Correct answer)
Regression

Correct answer: Forecasting

In data mining, forecasting is the term used for predicting future trends or values based on historical data and identified patterns. It involves analyzing past observations to make informed estimates about future events. This technique is crucial for business planning, economic analysis, and various other predictive applications.

Question 12: What is a dashboard in data reporting?

A single interface showing key metrics and visualizations (Correct answer)
A collection of unrelated datasets
A document containing raw data
A software program for data encryption

Correct answer: A single interface showing key metrics and visualizations

A dashboard in data reporting is a visual display that consolidates key performance indicators (KPIs), metrics, and data visualizations into a single, easy-to-understand interface. Its purpose is to provide a quick, at-a-glance overview of current status, trends, and performance related to specific objectives. Dashboards are often interactive, allowing users to explore data further and gain deeper insights.

Question 13: What is data provenance?

A method for deduplicating records in a database
The process of encrypting sensitive data fields
A record of where data originated and how it has been transformed over time (Correct answer)
The classification of data by sensitivity level

Correct answer: A record of where data originated and how it has been transformed over time

Data provenance tracks the origin, movement, and transformation of data, providing an audit trail of its history.

Question 14: Which of the following best describes an outlier?

A duplicated record
A value significantly different from the rest of the dataset (Correct answer)
A missing value in the dataset
A data point that is exactly equal to the mean

Correct answer: A value significantly different from the rest of the dataset

An outlier is a data point that lies far outside the typical range of values and can skew analysis results.

Question 15: A company shares customer data with a third-party vendor for analysis. Which data governance control is most critical to establish first?

Row-level security in the database
A data sharing agreement or DPA (Correct answer)
Data deduplication procedures
An ETL pipeline for the transfer

Correct answer: A data sharing agreement or DPA

A Data Processing Agreement (DPA) or data sharing agreement legally defines how the third party may use, protect, and dispose of the data.

Question 16: What is a subquery in SQL?

A query nested inside another query (Correct answer)
A query that modifies table structure
A query that joins multiple tables
A query stored as a view

Correct answer: A query nested inside another query

A subquery is a query embedded within another SQL query, often in the WHERE, FROM, or SELECT clause.

Question 17: What is a pivot table used for in Excel or data analysis?

Generating random sample data
Formatting cells conditionally
Summarizing, aggregating, and reorganizing data interactively (Correct answer)
Writing macros for automation

Correct answer: Summarizing, aggregating, and reorganizing data interactively

Pivot tables let analysts quickly summarize large datasets by grouping and aggregating values across rows and columns.

Question 18: Which of the following is a best practice when designing a data report?

Using as many colors as possible for visuals
Keeping the report clear, concise, and focused on the main objectives (Correct answer)
Overloading the report with detailed technical language
Including only raw data without summaries

Correct answer: Keeping the report clear, concise, and focused on the main objectives

When designing a data report, it is a best practice to prioritize clarity, conciseness, and focus on the main objectives. This ensures that the audience can easily understand the key messages and insights without being overwhelmed by unnecessary detail or jargon. A clear and focused report helps stakeholders quickly grasp the findings and make informed decisions.

Question 19: Which of the following is a sign of low-quality data?

High row count
Unique primary key values
High percentage of NULL values in critical fields (Correct answer)
Consistent date formats across columns

Correct answer: High percentage of NULL values in critical fields

A high proportion of NULLs in important columns indicates data quality issues that can undermine analysis accuracy.

Question 20: What does the GROUP BY clause do in SQL?

Aggregates rows sharing the same value in specified columns (Correct answer)
Joins tables on matching columns
Sorts the result set
Filters rows before the query executes

Correct answer: Aggregates rows sharing the same value in specified columns

GROUP BY collapses rows that have the same value in the specified column(s) so aggregate functions like SUM or COUNT apply per group.

Question 21: What does 'data minimization' mean in the context of privacy regulations?

Collecting only the data necessary for the specified purpose (Correct answer)
Reducing the number of data sources in a pipeline
Compressing data to reduce storage costs
Aggregating data to remove row-level details

Correct answer: Collecting only the data necessary for the specified purpose

Data minimization is a GDPR principle requiring organizations to collect and retain only the data that is strictly necessary for a defined purpose.

Question 22: What does data deduplication mean?

Identifying and removing duplicate records (Correct answer)
Splitting a dataset into training and test sets
Adding new records to a dataset
Converting data types

Correct answer: Identifying and removing duplicate records

Deduplication removes redundant rows that represent the same entity, preventing double-counting in analysis.

Question 23: What is the difference between revenue and profit?

Profit is only used in non-profit organizations
Revenue is after expenses; profit is before
They are the same metric
Revenue is total income; profit is revenue minus costs (Correct answer)

Correct answer: Revenue is total income; profit is revenue minus costs

Revenue is total income generated from sales, while profit is what remains after all costs and expenses are deducted.

Question 24: What does a LEFT JOIN return?

All rows from both tables with no filtering
Only rows unique to the left table
Only matching rows from both tables
All rows from the left table and matching rows from the right (Correct answer)

Correct answer: All rows from the left table and matching rows from the right

A LEFT JOIN returns all rows from the left table and the matched rows from the right table; unmatched right-table rows appear as NULL.

Question 25: What is a data type mismatch issue?

When two datasets have different numbers of rows
When a column stores values in an incorrect format for its intended data type (Correct answer)
When a dataset has no primary key
When column names differ between tables

Correct answer: When a column stores values in an incorrect format for its intended data type

A data type mismatch occurs when values are stored in the wrong format, such as dates stored as strings, causing calculation errors.

Question 26: What is the purpose of the pd.merge() function in pandas?

Concatenate rows from two DataFrames
Combine two DataFrames based on a common key column, similar to a SQL JOIN (Correct answer)
Remove duplicate rows
Reshape a DataFrame from wide to long format

Correct answer: Combine two DataFrames based on a common key column, similar to a SQL JOIN

pd.merge() joins two DataFrames on one or more key columns, supporting inner, left, right, and outer joins.

Question 27: Which of the following is an example of implicit bias in a dataset?

Inconsistent date formats across data sources
Missing values in a timestamp column
A training dataset that underrepresents women in leadership roles (Correct answer)
Duplicate records caused by a data entry error

Correct answer: A training dataset that underrepresents women in leadership roles

Implicit bias occurs when historical patterns or systemic inequalities are reflected in the data, causing models trained on it to perpetuate those patterns.

Question 28: In machine learning, what is "overfitting"?

When a model does not capture enough complexity from the data
When a model captures too little data
When a model performs well on training data but poorly on new data (Correct answer)
When a model cannot classify any data

Correct answer: When a model performs well on training data but poorly on new data

Overfitting occurs in machine learning when a model learns the training data too well, including its noise and specific quirks, rather than the underlying general relationships. This results in the model performing exceptionally well on the data it was trained on but poorly on new, unseen data. It indicates a failure to generalize effectively, making the model unreliable for real-world predictions.

Question 29: What is customer acquisition cost (CAC)?

The total cost to acquire one new customer (Correct answer)
The lifetime value of a customer
The number of marketing channels used
The average order value

Correct answer: The total cost to acquire one new customer

CAC is calculated by dividing total marketing and sales spend by the number of new customers acquired in that period.

Question 30: What is the purpose of benchmarking in business intelligence?

Automating report generation
Comparing performance metrics against industry standards or competitors (Correct answer)
Testing BI tool performance
Storing large datasets efficiently

Correct answer: Comparing performance metrics against industry standards or competitors

Benchmarking compares an organization's KPIs against best-in-class standards or competitors to identify gaps and improvement opportunities.

Question 31: Which SQL statement is used to modify existing data in a table?

ALTER
INSERT
MODIFY
UPDATE (Correct answer)

Correct answer: UPDATE

UPDATE changes existing records in a table based on a specified condition in the WHERE clause.

CompTIA Data+ (DA0-001)

CompTIA Data+ validates foundational data analytics skills including data mining, analysis, visualization, and governance. It is vendor-neutral and designed for analysts, data technicians, and report developers with 18-24 months of hands-on experience.

Questions

90 min

Time Limit

75%

To Pass

Checking for saved progress...

Exam Rules

You can skip questions and return to them later
Flag questions for review before submitting
No feedback shown until you submit the entire exam
Unanswered questions count as wrong — answer everything
10 pretest questions are mixed in and don't affect your score
Timer auto-submits when time runs out
Your progress is auto-saved every 30 seconds