An analyst wants to create a historical data set for the past five years with each year in its own data set. Which of the following methods is the best way to create this historical data set?

The correct answer is C. Data append. Data append (also called data stacking) combines multiple datasets with the same structure by adding rows from one to the bottom of another - ideal for combining five yearly datasets into one unified historical dataset. Concatenation is similar but often refers to string…

Data Concepts and Environments

Question

Options

AData transpose
BData concatenation
CData append
DData normalization

How the community answered

(34 responses)

B
6% (2)
C
91% (31)
D
3% (1)

Explanation

Data append (also called data stacking) combines multiple datasets with the same structure by adding rows from one to the bottom of another - ideal for combining five yearly datasets into one unified historical dataset. Concatenation is similar but often refers to string operations or joining at the column level. Transpose changes row/column orientation. Normalization reduces data redundancy in a relational model and does not combine datasets.

Topics

#Data append#Data combination#Dataset merging

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice