Exam 70-778 topic 1 question 109 discussion

Actual exam question from Microsoft's 70-778

Question #: 109
Topic #: 1

You have two tables named Customer and Orders. A sample of the Data in Customer is shown in the following table.

A sample of the data in Orders is shown in the following table.

You need to create the following new table.

You must use Customer as the first table.
Which join kind should you use?

A. Right Anti
B. Right Outer
C. Left Anti
D. Left Outer
E. Inner

Show Suggested Answer

Suggested Answer: D 🗳️

by Brunobsv at Oct. 17, 2019, 10:35 a.m.

Comments

Submit Cancel

Brunobsv

Highly Voted 5 years, 8 months ago

In case you're wondering RADCAD has an explanation for this: - Left Outer (all from first, matching from second - Right Outer (all from second, matching from first) - Full Outer (all rows from both) - Inner (only matching rows); - Left Anti (rows only in first) - Right Anti (rows only in second)

upvoted 33 times

...

SaidDjaiz

Highly Voted 5 years, 3 months ago

Correct Answer is D

upvoted 8 times

...

Dirk

Most Recent 5 years, 3 months ago

It's never ever D. If the Customer table should be the first table in the join and all records from orders must be in the result then this is a Right Outer Join. Otherwise orders must be the first table in the join. So it must be B.

upvoted 3 times

Dirk

5 years, 3 months ago

sorry - must correct myself: The picture shows customer4 in the resultset although he has no orders. So it shows all records from customer and the matching records from Orders, So I vote for D.

upvoted 6 times

...

eug45

4 years, 9 months ago

you are o wrong, if you don't know it, please say anything

upvoted 2 times

...