CompTIA
DY0-001 · Question #29
A movie production company would like to find the actors appearing in its top movies using data from the tables below. The resulting data must show all movies in Table 1, enriched with actors listed…
Sign in or unlock DY0-001 to reveal the answer and full explanation for question #29. The question stem and answer options stay visible for context.
Data Processing Technologies
Question
A movie production company would like to find the actors appearing in its top movies using data from the tables below. The resulting data must show all movies in Table 1, enriched with actors listed in Table 2. Which of the following query operations achieves the desired data set?
Exhibit
Options
- APerform an INNER JOIN between Table 1 using column Movie, and Table 2 using column
- BPerform a UNION between Table 1 using column Movie, and Table 2 using column Acted_In.
- CPerform an INTERSECT between Table 1 using column Movie, and Table 2 using column
- DPerform a LEFT JOIN on Table 1 using column Movie, with Table 2 using column Acted_In.
Unlock DY0-001 to see the answer
You've previewed enough free DY0-001 questions. Unlock DY0-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
#SQL joins#LEFT JOIN#data integration#relational databases