CompTIA Data+ (DA0-001) — Question 253
A data analyst is working with a data set and would like to combine two fields into a single field. Which of the following data manipulation techniques should the analyst use?
Answer options
- A. Data merge
- B. Transpose
- C. Data append
- D. Concatenation
Correct answer: D
Explanation
The correct answer is D, Concatenation, as this technique specifically combines two or more fields into a single field. Options A (Data merge) and C (Data append) involve different processes of combining data sets rather than merging fields, while B (Transpose) reorganizes data rather than merging fields.