Big Cyber Monday Sale 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: clap70

DA0-002 CompTIA Data+ Exam (2025) Questions and Answers

Questions 4

Which of the following data repositories stores unaltered data?

Options:

A.

Data lake

B.

Data warehouse

C.

Data table

D.

Data factory

Buy Now
Questions 5

The human resources department wants to understand the relationship between the ages and incomes of all employees. Which of the following graphics is the most appropriate to present the analysis?

Options:

A.

Scatter plot

B.

Area plot

C.

Bar chart

D.

Pie chart

Buy Now
Questions 6

A data analyst receives the following sales data for a convenience store:

Item

Quantity

Price

Chocolate Bars

7

$1.99

Vanilla Ice Bars

2

$4.99

Chocolate Wafers

6

$0.99

Peanut Butter

2

$2.99

Cups

3

$4.99

Strawberry Jam

3

$4.99

Chocolate Cake

9

$6.99

Milk Chocolate

2

$2.99

Almonds

5

$2.99

The analyst needs to provide information on the products that contain chocolate. Which of the following RegEx should the analyst use to filter the chocolate products?

Options:

A.

Chocolate!

B.

Chocolate$

C.

%Chocolate&

D.

#Chocolate#$

Buy Now
Questions 7

Before distributing a report, a marketing analyst notices that the total distinct promotional email messages is less than the combined total of emails sent. Which of the following is the most likely reason for this difference?

Options:

A.

The aggregation did not include all emails.

B.

Some emails were not delivered.

C.

The report failed to run properly.

D.

A recipient received duplicate emails.

Buy Now
Questions 8

Which of the following data sources makes online data consumption easier?

Options:

A.

Data mart

B.

Web scraping

C.

Database

D.

Application programming interface

Buy Now
Questions 9

A data analyst is creating a report about cars sold within the last twelve months. The current data set only contains information from the last ten months. Which of the following is the most appropriate way to accomplish this task?

Options:

A.

Join the records from the last two months of the previous year and append them to the data table.

B.

Parse the records from the last two months of the previous year and append them to the data table.

C.

Merge the records from the last two months of the previous year and append them to the data table.

D.

Extract the records from the last two months of the previous year and append them to the data table.

Buy Now
Questions 10

Which of the following best describes the semi-structured data that is gathered when web scraping?

Options:

A.

JSON

B.

CSV

C.

CSS

D.

HTML

Buy Now
Questions 11

A data analyst receives four files that need to be unified into a single spreadsheet for further analysis. All of the files have the same structure, number of columns, and field names, but each file contains different values. Which of the following methods will help the analyst convert the files into a single spreadsheet?

Options:

A.

Merging

B.

Appending

C.

Parsing

D.

Clustering

Buy Now
Questions 12

A data analyst is working on an initial analysis of the dataset in the following table:

DateTime

Count

2024-01-01

12

2024-01-02

245

2024-01-02

13

2024-01-03

13

2024-01-03

12

00:00:00

12

Which of the following issues should the analyst flag in the data report?

Options:

A.

Completeness

B.

Outlier

C.

Mismatch

D.

Duplication

Buy Now
Questions 13

The sales department wants to include the composition of total sales amounts across all three sales channels in a report. Given the following sample sales table:

Sales channel

Month

Sales (million $)

Digital

January

135

Store

February

145

Online

March

165

Store

April

200

Store

May

125

Online

June

155

Digital

July

120

Online

August

145

Digital

September

160

Which of the following visualizations is the most appropriate?

Options:

A.

Pivot table

B.

Pie chart

C.

KPI card

D.

Box plot

Buy Now
Questions 14

A data engineer needs to create a reporting solution that has predefined filters and the ability to download .csv files. Which of the following is the best solution?

Options:

A.

Developing a dynamic dashboard that refreshes daily

B.

Generating a weekly executive summary

C.

Creating a self-service portal on the company's intranet

D.

Building an email template to request ad hoc reports

Buy Now
Questions 15

A product goes viral on social media, creating high demand. Distribution channels are facing supply chain issues because the testing and training models that are used for sales forecasting have not encountered similar demand. Which of the following best describes this situation?

Options:

A.

Model bias

B.

Data drift

C.

Incorrect sizing

D.

Skewing

Buy Now
Questions 16

An administrator needs to design a table that will include foreign words. Which of the following is the best option for storing non-native language characters?

Options:

A.

VARCHAR

B.

NVARCHAR

C.

CLOB

D.

CHAR

Buy Now
Questions 17

A data analyst troubleshoots a dashboard every day for a week. Which of the following techniques best addresses how to validate the data moving forward?

Options:

A.

Inquiring about structure changes

B.

Setting up monitoring alerts

C.

Reaching out to users daily

D.

Rebuilding the dashboard

Buy Now
Questions 18

A data analyst is creating a pivot table for a large dataset for an upcoming board meeting. Which of the following is the purpose of the pivot table?

Options:

A.

To visualize the data in a dashboard

B.

To retrieve and clean data from several sources

C.

To summarize and analyze the data

D.

To organize the data for reporting

Buy Now
Questions 19

A data analyst needs to create and deliver a dashboard that displays the company's financial transactions as they are updated. Which of the following delivery methods should the analyst consider? (Select two).

Options:

A.

Real-time

B.

Snapshot

C.

Dynamic

D.

Static

E.

Ad hoc

F.

Time series

Buy Now
Questions 20

A sales manager wants to understand how sales are trending year over year. Which of the following chart types is the most appropriate to display the information?

Options:

A.

Line

B.

Donut

C.

Bubble

D.

Hierarchy

Buy Now
Questions 21

Which of the following best describes the function of a data type?

Options:

A.

To provide a generic identifier for files used in analysis

B.

To identify the program needed to open a file

C.

To differentiate the real value of the field in its context

D.

To make the addition of individual records simpler

Buy Now
Questions 22

A data analyst is generating a custom report for a Chief Executive Officer's executive meeting. Later, the analyst learns that other custom reports will be required for future executive meetings. Which of the following delivery methods should the analyst use?

Options:

A.

Ad hoc

B.

Real-time

C.

Recurring

D.

Self-service

Buy Now
Questions 23

An analyst needs to produce a final dataset using the following tables:

CourseID

SectionNumber

StudentID

MATH1000

1

10009

MATH1000

2

10007

PSYC1500

1

10009

PSYC1500

1

10015

StudentID

FirstName

LastName

10009

Jane

Smith

10007

John

Doe

10015

Robert

Roe

The expected output should be formatted as follows:

| CourseID | SectionNumber | StudentID | FirstName | LastName |

Which of the following actions is the best way to produce the requested output?

Options:

A.

Aggregate

B.

Join

C.

Group

D.

Filter

Buy Now
Questions 24

A company's entire server environment is located at the company’s headquarters. Which of the following describes this type of environment?

Options:

A.

Cloud

B.

On-premises

C.

Public

D.

Hybrid

Buy Now
Questions 25

A table contains several rows of cellular numbers with call timestamps, call durations, called numbers, and carriers of the called number. Which of the following allows a data analyst to sort the cellular numbers based on the carriers of the called numbers and include the total call durations?

Options:

A.

SELECT cellular_number, called_number_carrier, SUM(call_duration) FROM calls GROUP BY cellular_number ORDER BY called_number_carrier;

B.

SELECT cellular_number, SUM(call_duration) FROM calls GROUP BY call_duration ORDER BY called_number_carrier;

C.

SELECT cellular_number, called_number_carrier, SUM(call_duration) FROM calls GROUP BY cellular_number, called_number_carrier ORDER BY called_number_carrier;

D.

SELECT cellular_number, called_number_carrier, SUM(call_duration) FROM calls GROUP BY call_duration ORDER BY called_number_carrier;

Buy Now
Questions 26

The following SQL code returns an error in the program console:

SELECT firstName, lastName, SUM(income)

FROM companyRoster

SORT BY lastName, income

Which of the following changes allows this SQL code to run?

Options:

A.

SELECT firstName, lastName, SUM(income) FROM companyRoster HAVING SUM(income) > 10000000

B.

SELECT firstName, lastName, SUM(income) FROM companyRoster GROUP BY firstName, lastName

C.

SELECT firstName, lastName, SUM(income) FROM companyRoster ORDER BY firstName, income

D.

SELECT firstName, lastName, SUM(income) FROM companyRoster

Buy Now
Questions 27

A company's analytics manager wants all reports to be delivered once every seven days. Which of the following is the best delivery method?

Options:

A.

Recurring

B.

Ad hoc

C.

Custom

D.

Snapshot

Buy Now
Questions 28

Which of the following file types separates data using a delimiter?

Options:

A.

XML

B.

HTML

C.

JSON

D.

CSV

Buy Now
Questions 29

A data breach occurs at a company. Which of the following actions should be taken?

Options:

A.

Make an announcement on social media so customers are aware as soon as possible.

B.

Tell the company management team and then tell regulatory agencies.

C.

Keep the incident a secret until the issue is resolved.

D.

Inform the entire IT sector, but ask for discretion.

Buy Now
Questions 30

Which of the following best enables the retrieval and manipulation of data that is stored in a relational database?

Options:

A.

XML

B.

SQL

C.

Excel

D.

JavaScript

Buy Now
Questions 31

Which of the following is the best language to use in a notebook?

Options:

A.

Haskell

B.

Python

C.

JavaScript

D.

SAS

Buy Now
Questions 32

A data analyst is analyzing the following dataset:

Transaction Date

Quantity

Item

Item Price

12/12/12

11

USB Cords

9.99

11/11/11

3

Charging Block

8.89

10/10/10

5

Headphones

50.15

Which of the following methods should the analyst use to determine the total cost for each transaction?

Options:

A.

Parsing

B.

Scaling

C.

Compressing

D.

Deriving

Buy Now
Questions 33

A data analyst is joining two tables with different content and one common field. Which of the following should the analyst do to most efficiently meet this requirement?

Options:

A.

Match the records of the related columns and merge the tables.

B.

Create a cluster to facilitate data integration between the tables.

C.

Explode both tables to identify unique values and reorder the fields in one table.

D.

Append the values of the matching columns and concatenate the other data fields.

Buy Now
Questions 34

A data analyst must combine service calls into low-, medium-, and high-priority levels in order to analyze organizational responses. Which of the following techniques should the analyst use for this task?

Options:

A.

Augmentation

B.

Imputation

C.

Scaling

D.

Binning

Buy Now
Questions 35

A data analyst is gathering data from multiple tables in a database. The analyst needs certain columns from each table. Which of the following is the best method to accomplish this task?

Options:

A.

Aggregate

B.

Union

C.

Nest

D.

Join

Buy Now
Questions 36

A manager wants to use the information in a recurring report on incomplete timesheets for the prior month to guide employee outreach. Which of the following report types is the best for this task?

Options:

A.

Summary

B.

Infographic

C.

Snapshot

D.

Ad hoc

Buy Now
Exam Code: DA0-002
Exam Name: CompTIA Data+ Exam (2025)
Last Update: Dec 4, 2025
Questions: 121
DA0-002 pdf

DA0-002 PDF

$25.5  $84.99
DA0-002 Engine

DA0-002 Testing Engine

$30  $99.99
DA0-002 PDF + Engine

DA0-002 PDF + Testing Engine

$40.5  $134.99