Microsoft
70-778 · Question #143
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 correct answer is D. Left Outer. See the full explanation below for the reasoning.
Question
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?
Exhibits
Options
- ARight Anti
- BRight Outer
- CLeft Anti
- DLeft Outer
- EInner
How the community answered
(15 responses)- C7% (1)
- D87% (13)
- E7% (1)
Community Discussion
No community discussion yet for this question.