nerdexam
Microsoft

70-779 · Question #13

You have two queries named Client and Invoices. A sample of Client is shown in the following table. A sample of Invoices is shown in the following table. You need to create a new table that has the…

The correct answer is B. Left Outer. See the full explanation below for the reasoning.

Question

You have two queries named Client and Invoices. A sample of Client is shown in the following table. A sample of Invoices is shown in the following table. You need to create a new table that has the following information. Which join kind should you use?

Exhibits

70-779 question #13 exhibit 1
70-779 question #13 exhibit 2

Options

  • AInner
  • BLeft Outer
  • CRight Anti
  • DLeft Anti

How the community answered

(32 responses)
  • A
    6% (2)
  • B
    78% (25)
  • C
    13% (4)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 70-779 Practice