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

The correct answer is B. Merge. A merge operation joins two datasets on a common key (e.g., customer ID) and adds new columns from one dataset to the other - in this case, adding the secondary email field to existing customer records. Blend (A) is a temporary, display-level combination of data sources used in…

Data Concepts and Environments

Question

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

Options

ABlend
BMerge
CAppend
DAggregate

How the community answered

(23 responses)

A
4% (1)
B
91% (21)
C
4% (1)

Explanation

A merge operation joins two datasets on a common key (e.g., customer ID) and adds new columns from one dataset to the other - in this case, adding the secondary email field to existing customer records. Blend (A) is a temporary, display-level combination of data sources used in analysis tools, not a structural database change. Append (C) adds new rows (records), not new columns/fields. Aggregate (D) summarizes or groups data into calculated values. Since the goal is to add a new attribute column to existing records, merge is the correct technique.

Topics

#Data manipulation#Data enrichment#Database merge operations#Data integration

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice