CompTIA Data+ (DA0-001) — Question 193

An organization would like to add a secondary email field to its customer database in order to enrich the customer profiles. Which of the following data manipulation techniques should the analyst use to add this information?

Answer options

• A. Blend
• B. Merge
• C. Append
• D. Aggregate

Correct answer: B

Explanation

The correct answer is B, Merge, because this technique allows for the combination of two datasets based on a common key, which is essential for adding a secondary email field to existing customer profiles. The other options, such as Append and Aggregate, do not facilitate the integration of additional fields into existing records, while Blend typically refers to combining data from different sources without altering the original datasets.