Latest CompTIA DA0-002 Exam questions and answers [Q13-Q32]

18Nov 2025 by admin No Comments

4.5/5 - (2 votes)

Latest CompTIA DA0-002 Exam questions and answers

PracticeMaterial DA0-002 Exam Practice Test Questions (Updated 113 Questions)

QUESTION 13
Which of the following supports capabilities such as automatic versioning, corruption checks, KPIs, and user authentication?

Notebook

REST API

Pipeline

Source control

QUESTION 14
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?

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

Create a cluster to facilitate data integration between the tables.

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

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

QUESTION 15
Which of the following is a NoSQL database?

PostgreSQL

MySQL

Oracle

MongoDB

QUESTION 16
A data analyst wants to use the following tables to find all the customers who have not placed an order:
Customers table
ID
Name
Address
Products table
ID
Name
Customer_ID
Which of the following SQL statements is the best way to accomplish this task?

SELECT * FROM CUSTOMERS AS C LEFT JOIN PRODUCTS AS P ON C.ID = P.Customer_ID WHERE P.Customer_ID IS NULL

SELECT * FROM CUSTOMERS AS C INNER JOIN PRODUCTS AS P ON C.ID = C.IDWHERE COUNT(P.) = 0

SELECT * FROM PRODUCTS AS P INNER JOIN CUSTOMERS AS C ON P.Customer_ID = C.ID WHERE (SELECT COUNT(P.) = 0)

SELECT * FROM PRODUCTS AS P LEFT JOIN CUSTOMERS AS C ON P.Customer_ID = C.ID WHERE P.Customer_ID IS NOT NULL

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

Recurring

Ad hoc

Custom

Snapshot

QUESTION 18
A data analyst team needs to segment customers based on customer spending behavior. Given one million rows of data like the information in the following sales order table:
Customer_ID
Region
Amount_spent
Product_category
Quantity_of_items
00123
East
20000
Baby
4
00124
West
30000
Home
6
00125
South
40000
Garden
7
00126
North
50000
Furniture
8
00127
East
60000
Baby
10
Which of the following techniques should the team use for this task?

Standardization

Concatenate

Binning

Appending

QUESTION 19
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?

Augmentation

Imputation

Scaling

Binning

QUESTION 20
Which of the following is the best tool for creating a dynamic dashboard?

Power BI

RStudio

Excel

SAS

QUESTION 21
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?

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

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

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

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

QUESTION 22
A data analyst is preparing a survey for Paralympic Games athletes. Which of the following should the analyst consider when creating this survey?

Idioms

Color contrast

Refresh speed

Granularity

QUESTION 23
Which of the following data repositories stores unaltered data?

Data lake

Data warehouse

Data table

Data factory

QUESTION 24
The human resources department wants to know the number of employees who earn $125,000 or more.
However, the department is concerned about duplicates in the dataset. Given the following table:
Employee_ID
Level
Salary
001
1
10000
002
2
20000
003
2
256000
004
2
125000
001
1
10000
002
2
20000
Which of the following SQL statements resolves this issue?

SELECT DISTINCT Employee_ID FROM Employee WHERE Salary >= 125000

SELECT COUNT(DISTINCT Employee_ID) FROM Employee WHERE Salary >= 125000

SELECT DISTINCT Employee_ID FROM Employee WHERE Salary > 125000

SELECT COUNT(Employee_ID) FROM Employee WHERE Salary >= 125000

QUESTION 25
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?

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

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

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

SELECT firstName, lastName, SUM(income) FROM companyRoster

QUESTION 26
A data analyst is following up on a recent, company-wide data audit of customer invoice data. Which of the following is the best option for the analyst to use?

PCI DSS

GDPR

ISO

PII

QUESTION 27
A recent server migration applied an update to dataset naming conventions. Multiple users are now reporting stale information in an existing dashboard. The date in the dataset confirms a successful data refresh. Which of the following should a data analyst do first?

Confirm the dashboard is pointed to the newest dataset.

Filter the data in the dashboard.

Escalate user permissions on the server.

Verify that the dashboard subscription is not expired.

QUESTION 28
A data analyst needs to provide a weekly sales report for the Chief Financial Officer. Which of the following delivery methods is the most appropriate?

A granular daily report in a dashboard

A detailed text document

A spreadsheet with raw data

A high-level email

QUESTION 29
A data analyst needs to remove all duplicate values between two tables, “Employees” and “Managers,” using SQL SELECT statements. Which of the following should the analyst use for this task?

SELECT * FROM Employees UNION ALL SELECT * FROM Managers

SELECT * FROM Employees UNION SELECT * FROM Managers

SELECT * FROM Employees JOIN SELECT * FROM Managers

SELECT * FROM Employees CROSS JOIN SELECT * FROM Managers

QUESTION 30
Which of the following is the most efficient to use when programming repeatable tasks?

LLM

Deep learning

NLP

RPA

QUESTION 31
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?

Merging

Appending

Parsing

Clustering

QUESTION 32
Which of the following AI types is the best option for time-series forecasting?

Generative AI

Foundational models

Natural language processing

Robotic process automation