Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

CompTIA Exam DA0-002 Topic 3 Question 5 Discussion

Actual exam question for CompTIA's DA0-002 exam
Question #: 5
Topic #: 3
[All DA0-002 Questions]

[Data Acquisition and Preparation]

A data analyst needs to create a combined report that includes information from the following two tables:

Managers table

ID

First_name

Last_name

Job_title

1001

John

Doe

Manager

1002

Jane

Roe

Director

Non-managers table

ID

First_name

Last_name

Job_title

1003

Robert

Roe

Business Analyst

1004

Jane

Doe

Sales Representative

1005

John

Roe

Operations Analyst

Which of the following query methods should the analyst use for this task?

Show Suggested Answer Hide Answer
Suggested Answer: C

by Christiane at Jun 13, 2025, 05:34 PM

Limited Time Offer

25%

Off

Get Premium DA0-002 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Lou
3 days ago
Hmm, I'm not sure. I was thinking maybe C) Union would work, since we want to combine the data from both tables. But you make a good point about using a JOIN.
upvoted 0 times
...
Lauran
10 days ago
I'm not sure about Join. I think Union could also work because it combines the results of two queries into a single result set.
upvoted 0 times
...
Stephanie
16 days ago
I think the correct answer is B) Join. We need to combine the data from the two tables, and a JOIN operation would be the best way to do that.
upvoted 0 times
...
Viola
17 days ago
I agree with Dorsey. Join is the right query method for this task because it combines data based on a related column.
upvoted 0 times
...
Dorsey
30 days ago
I think the analyst should use a Join to combine the information from the two tables.
upvoted 0 times
...

Save Cancel