Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. CompTIA
  5. DA0-002

CompTIA DA0-002 Exam Questions
CompTIA Data+ (2025) (Page 4 )

Updated On: 21-Feb-2026
Page 4 of 24
PDF with 111 Questions

[Data Analysis]
A data analyst receives a request for the current employee head count and runs the following SQL statement:
SELECT COUNT(EMPLOYEE_ID) FROM JOBS
The returned head count is higher than expected because employees can have multiple jobs.
Which of the following should return an accurate employee head count?

  1. SELECT JOB_TYPE, COUNT DISTINCT(EMPLOYEE_ID) FROM JOBS
  2. SELECT DISTINCT COUNT(EMPLOYEE_ID) FROM JOBS
  3. SELECT JOB_TYPE, COUNT(DISTINCT EMPLOYEE_ID) FROM JOBS
  4. SELECT COUNT(DISTINCT EMPLOYEE_ID) FROM JOBS

Answer(s): D



[Data Governance]
A data analyst created a dashboard to illustrate the traffic volume and mean response time for a call center. The traffic data is current, but the mean response time has not updated for more than an hour.
Which of the following is the best way to verify the data's freshness?

  1. Refactoring the code base
  2. Testing for network connectivity issues
  3. Checking the last time the calculation script ran
  4. Determining the number of calls with no timestamps

Answer(s): C



[Data Governance]
Which of the following pieces of information, if made public, results in a data privacy violation?

  1. Gender
  2. Driver's license
  3. Age
  4. Employment status

Answer(s): B



[Data Acquisition and Preparation]
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?

  1. Merging
  2. Appending
  3. Parsing
  4. Clustering

Answer(s): B



[Data Analysis]
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
00124
West
30000
Home
00125
South
40000
Garden
00126
North
50000
Furniture
00127
East
60000
Baby
Which of the following techniques should the team use for this task?

  1. Standardization
  2. Concatenate
  3. Binning
  4. Appending

Answer(s): C






Post your Comments and Discuss CompTIA DA0-002 exam dumps with other Community members:

Join the DA0-002 Discussion