CompTIACompTIA
DA0-001 · Question #348
DA0-001 Question #348: Real Exam Question with Answer & Explanation
Sign in or unlock DA0-001 to reveal the answer and full explanation for question #348. The question stem and answer options stay visible for context.
Data Analysis
Question
A data analyst has been asked to create one table that has each employee's first name, last name, sales, and address. The sales and addresses are listed in the tables below: Which of the following steps should the analyst take to create the table?
Options
- ATranspose the first name and last name in both tables. Use lookup to pull the address field from
- BUse lookup with the first name or first name to pull the address field from Table 2 into Table 1.
- CUse the append formula in both tables for the first name and last name. Use lookup to pull the
- DCreate a column that concatenates the first name and last name in each table. Use concatenate
Unlock DA0-001 to see the answer
You've previewed enough free DA0-001 questions. Unlock DA0-001 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
#Data manipulation#Data integration#Data merging#Concatenation