ExamTopics Logo
Mail Us[email protected]
Menu
Comptia Discussions
exam questions

Exam DY0-001 All Questions

View all questions & answers for the DY0-001 exam
Go to Exam

Exam DY0-001 topic 1 question 38 discussion

Actual exam question from CompTIA's DY0-001
Question #: 38
Topic #: 1
[All DY0-001 Questions]

A data scientist is merging two tables. Table 1 contains employee IDs and roles. Table 2 contains employee IDs and team assignments. Which of the following is the best technique to combine these data sets?

  • A. INNER JOIN between Table 1 and Table 2
  • B. LEFT JOIN on Table 1 with Table 2
  • C. RIGHT JOIN on Table 1 with Table 2
  • D. OUTER JOIN between Table 1 and Table 2
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by SuntzuLegacy at May 19, 2025, 9:24 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
SuntzuLegacy
1 month, 1 week ago
Selected Answer: B
A common best practice in this scenario is to treat the “employee” table (Table 1) as the primary (“left”) table and bring in the matching information from Table 2. That way, all employees in Table 1 appear in the result—even if some are missing from Table 2—while still merging in the team assignments for those that do match. In SQL terms, this is a LEFT JOIN of Table 1 to Table 2. Hence, the best choice is: B. LEFT JOIN on Table 1 with Table 2.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel