CompTIA Data+ (DA0-001) — Question 328

A healthcare data analyst is working with data sets containing patient information, medical records, and metrics. The data analyst needs to combine two data sets that have a common field, Patient_ID. Which of the following data manipulation techniques should the analyst use?

Answer options

• A. Data blending
• B. Concatenation
• C. Data append
• D. Data merge

Correct answer: D

Explanation

The correct answer is D, Data merge, as it specifically allows the analyst to combine data sets based on a common field, such as Patient_ID. Options A, B, and C do not provide the same functionality as merging; data blending involves combining data from different sources without necessarily matching fields, concatenation joins data sets end-to-end, and data append adds records vertically rather than merging them based on a key.