Instant Access CompTIA.DA0-002.v2026-07-25.q125 Actual Practice Test Engine for Free (Page 9)

Question 36

Which of the following best explains the purpose of data lineage?

A.To see the steps and path of data flow through different systems
B.To better understand the granularity of data variable relationships
C.To track data transformations from acquisition through reporting
D.To look up data definitions, ensuring consistent use across business units

Question 37

A manager wants a report that contains the days off for each direct report. The manager needs this report to always be up-to-date with the latest data. Which of the following describes the refresh frequency that the manager is requesting?

A.Real-time
B.Ad hoc
C.Snapshot
D.Dynamic

Question 38

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 data set. Given the following table:

Which of the following SQL statements resolves this issue?

A.SELECT DISTINCT Employee_ID FROM Employee WHERE Salary >= 125000
B.SELECT COUNT(DISTINCT Employee_ID) FROM Employee WHERE Salary >= 125000
C.SELECT DISTINCT Employee_ID FROM Employee WHERE Salary > 125000
D.SELECT COUNT(Employee_ID) FROM Employee WHERE Salary >= 125000

Question 39

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?

A.SELECT * FROM Employees UNION ALL SELECT * FROM Managers
B.SELECT * FROM Employees UNION SELECT * FROM Managers
C.SELECT * FROM Employees JOIN SELECT * FROM Managers
D.SELECT * FROM Employees CROSS JOIN SELECT * FROM Managers

Question 40

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

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

A.Completeness
B.Outlier
C.Mismatch
D.Duplication

Question 36

Question 37

Question 38

Question 39

Question 40

Download PDF File