CompTIA Data+ (DA0-001) — Question 211

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?

Answer options

• A. Data transpose
• B. Data concatenation
• C. Data append
• D. Data normalization

Correct answer: C

Explanation

The correct method is Data append, as it allows for the addition of new data records to an existing dataset, which is ideal for creating separate datasets for each year. Data transpose changes the orientation of the data, Data concatenation combines datasets but does not separate them by year, and Data normalization focuses on structuring data efficiently, not on creating historical datasets.