Free CompTIA DataX DY0-001 Actual Exam Questions - Question 15 Discussion

B doesn’t make sense since UNION just stacks rows, not combine columns. It won’t link actors to their movies, so it can’t enrich the data as required.

D, since UNION or INTERSECT don’t combine columns like JOIN does.

A/D? Inner join (A) would only show movies with actors, but left join (D) keeps all movies, even those without actors. Since they want all movies listed, D seems safer to me.

D for sure, LEFT JOIN keeps all movies even if no actors match.

D imo, because LEFT JOIN includes all movies from Table 1 regardless of whether they have matching actors in Table 2. That’s key here since the question wants every movie listed, enriched with actors if any exist. A (INNER JOIN) would exclude movies without actors, which doesn’t fit the requirement. B (UNION) just stacks rows and doesn’t combine actor info properly, and C (INTERSECT) only keeps movies appearing in both tables, so it’s too restrictive. So, D is really the only one that meets all the criteria cleanly.

Maybe D makes the most sense because it keeps every movie from Table 1, even if no actors are listed in Table 2. INNER JOIN would drop movies without actors, which we don’t want here.

Not C, INTERSECT only gives movies common to both tables, so it won’t show all movies from Table 1 as required. LEFT JOIN (D) keeps every movie and adds actors where possible.

It’s D because INNER JOIN (A) would exclude movies without actors, and INTERSECT (C) only returns common movies. LEFT JOIN keeps all movies from Table 1, matching actors when available.

Not B, UNION would merge rows without matching actors to movies.

It’s D, because LEFT JOIN keeps all Table 1 movies, even those without actors listed.

Maybe D? LEFT JOIN sounds right since we want all movies from Table 1, even if some don’t have actors listed in Table 2. But does the data show if every movie has actors?