Logo ExamsQA
Exit
Official Bank 0/121

CompTIA DATA+ Certification (DA0-002) - CompTIA Exam Questions

Last updated on June 20, 2026

97% Exam Compliance
121 Total Questions
1
Question
Software end users are happy with the quality of product support provided. However, they frequently raise concerns about the long wait time for resolutions. An IT manager wants to improve the current support process. Which of the following should the manager use for this review?
Options
A Infographic
B Survey
C KPI
D UAT
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2
Question
A data analyst receives a new data source that contains employee IDs, job titles, dates of birth, addresses, years of service, and employees’ birth months. Which of the following inconsistencies should the analyst identify?
Options
A Redundancy
B Equivalence
C Parallel
D Duplication
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3
Question
A database administrator needs to implement security triggers for an organization's user information database. Which of the following data classifications is the administrator most likely using? (Select two).
Select 2
Options
A Encrypted
B Public
C Non-Sensitive
D Sensitive
E Open
F Private
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

4
Question
Which of the following file types separates data using a delimiter?
Options
A XML
B CSV
C HTML
D JSON
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

5
Question
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?
Options
A SELECT DISTINCT Employee_ID FROM Employee WHERE Salary >= 125000
B SELECT COUNT(Employee_ID) FROM Employee WHERE Salary >= 125000
C SELECT DISTINCT Employee_ID FROM Employee WHERE Salary > 125000
D SELECT COUNT(DISTINCT Employee_ID) FROM Employee WHERE Salary >= 125000
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

Finish Practice?

Are you sure you want to finish? This will end your practice session.