An analyst is updating a customer contacts database with information obtained from a survey of new customers. Which of the following data manipulation techniques should the analyst use?

The correct answer is B. Append. Appending adds new records to the end of an existing dataset without altering the existing data. Since the analyst is adding new customers (new rows) from a survey into an existing contacts database, Append is the correct technique. A Join combines datasets based on a shared…

Data Concepts and Environments

Question

Options

AJoin
BAppend
CTransform
DBlend

How the community answered

(50 responses)

A
2% (1)
B
92% (46)
C
4% (2)
D
2% (1)

Explanation

Appending adds new records to the end of an existing dataset without altering the existing data. Since the analyst is adding new customers (new rows) from a survey into an existing contacts database, Append is the correct technique. A Join combines datasets based on a shared key (used when matching existing records). Transform changes the format or structure of existing data. Blend merges data from multiple sources, typically in BI tools, often without a direct key match.

Topics

#Data manipulation#Database operations#Append#Data integration

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice