CompTIA
DA0-002 · Question #7
A data analyst is joining two tables with different content and one common field. Which of the following should the analyst do to most efficiently meet this requirement?
Sign in or unlock DA0-002 to reveal the answer and full explanation for question #7. The question stem and answer options stay visible for context.
Data Acquisition and Preparation
Question
A data analyst is joining two tables with different content and one common field. Which of the following should the analyst do to most efficiently meet this requirement?
Options
- AMatch the records of the related columns and merge the tables.
- BCreate a cluster to facilitate data integration between the tables.
- CExplode both tables to identify unique values and reorder the fields in one table.
- DAppend the values of the matching columns and concatenate the other data fields.
Unlock DA0-002 to see the answer
You've previewed enough free DA0-002 questions. Unlock DA0-002 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Joining tables#Data merging#Common fields#Data manipulation