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?
Correct Answer: B
Comprehensive and Detailed In-Depth Explanation:
When incorporating new customer information from a survey into an existing customer contacts database, the appropriate data manipulation technique is:
Option B:Append
* Rationale:Appending involves adding new records to the end of an existing dataset without altering the existing data. In this scenario, the analyst adds the new customer information as additional records in the database.
Option A:Join
* Rationale:Joining combines data from two or more tables based on a related column, creating a new dataset with combined information. This is not necessary when simply adding new records.
Option C:Transform
* Rationale:Transformation involves changing the format, structure, or values of data. While important in data processing, it doesn't pertain to adding new records.
Option D:Blend
* Rationale:Data blending combines data from different sources into a single dataset, often used in analysis rather than updating a database with new records.