A data analyst wants to use data manipulation to store newly acquired data. Which of the following techniques should the analyst use?

The correct answer is A. Data append. Data append adds new records (rows) to an existing dataset, making it the appropriate technique for storing newly acquired data without altering the existing records. Data transpose converts rows to columns or vice versa and does not add new data. Data blending combines data…

Data Concepts and Environments

Question

Options

AData append
BData transpose
CData blending
DData normalization

How the community answered

(20 responses)

A
90% (18)
C
5% (1)
D
5% (1)

Explanation

Data append adds new records (rows) to an existing dataset, making it the appropriate technique for storing newly acquired data without altering the existing records. Data transpose converts rows to columns or vice versa and does not add new data. Data blending combines data from multiple sources for analysis purposes, typically in a visualization tool, and is not a storage technique. Data normalization restructures a database to reduce redundancy and is a design technique, not a method for adding new records. Data append directly addresses the need to store new incoming data alongside existing data.

Topics

#Data manipulation#Data appending#Data ingestion#Data storage

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice