nerdexam
Microsoft

MB6-869 · Question #58

In Microsoft Dynamics AX 2012, some customers for whom customer information is stored in the CustTable table do not have corresponding bank account information stored in the CustBankAccount table…

The correct answer is B. outer join. See the full explanation below for the reasoning.

Question

In Microsoft Dynamics AX 2012, some customers for whom customer information is stored in the CustTable table do not have corresponding bank account information stored in the CustBankAccount table. You need to produce a list of all customers with corresponding bank account information if it exists. Which type of query join should you use?

Options

  • Ainner join
  • Bouter join
  • Cexists join
  • Dnot exists join

How the community answered

(28 responses)
  • A
    7% (2)
  • B
    71% (20)
  • C
    18% (5)
  • D
    4% (1)

Community Discussion

No community discussion yet for this question.

Full MB6-869 Practice