DA0-001 · Question #351
DA0-001 Question #351: Real Exam Question with Answer & Explanation
The correct answer is C: Data append. {"question_number": 4, "question": "An analyst wants to create a historical data set for the past five years with each year in its own data set.", "correct_answer": "C. Data append", "explanation": "Data append (also called data stacking) combines multiple datasets with the same
Question
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?
Options
- AData transpose
- BData concatenation
- CData append
- DData normalization
Explanation
{"question_number": 4, "question": "An analyst wants to create a historical data set for the past five years with each year in its own data set.", "correct_answer": "C. Data append", "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.", "generated_by": "claude-sonnet", "llm_judge_score": 4}
Topics
Community Discussion
No community discussion yet for this question.