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

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

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.