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.
[Reference:The CompTIA Data+ Certification Exam Objectives outline various data manipulation techniques, including appending data, which is essential for adding new records to existing datasets., partners.comptia.org, , ]
Submit