CompTIA
DY0-001 · Question #29
DY0-001 Question #29: Real Exam Question with Answer & Explanation
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.
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.