Big Halloween Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: simple70

  1. Home
  2. Discussions
  3. CompTIA
  4. CompTIA Data+
  5. DY0-001 Discussions
  6. DY0-001 Exam Topic 2 Question 10 Discussion

CompTIA DataX Exam DY0-001 Question # 10 Topic 2 Discussion

 CompTIA Discussions      Browse All Questions      Go to Exam Detail      Get Premium Access
 Previous
Next  

CompTIA DataX Exam DY0-001 Question # 10 Topic 2 Discussion

DY0-001 Exam Topic 2 Question 10 Discussion:
Question #: 10
Topic #: 2

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.

DY0-001 Question 10

Which of the following query operations achieves the desired data set?
A.

Perform an INNER JOIN between Table 1 using column Movie, and Table 2 using column Acted_In.

B.

Perform a UNION between Table 1 using column Movie, and Table 2 using column Acted_In.

C.

Perform an INTERSECT between Table 1 using column Movie, and Table 2 using column Acted_In.

D.

Perform a LEFT JOIN on Table 1 using column Movie, with Table 2 using column Acted_In.

Get Premium DY0-001 Questions
Actual exam question for CompTIA DY0-001 exam by Zyra54055 at Aug 2, 2025, 12:00:00 AM

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.

Submit
 Previous
Next