nerdexam
Microsoft

MB6-869 · Question #33

In Microsoft Dynamics AX 2012, you are creating a method on a table named VendTable. The method must return only the tax exemption number (VATNum). You need to return the VATNum for the vendor whose…

The correct answer is A. (select VendTable where VendTable.AccountNum == _accountNum).VatNum; C. (select firstOnly VATNum from VendTable where VendTable.AccountNum == _accountNum).VatNum. See the full explanation below for the reasoning.

Question

In Microsoft Dynamics AX 2012, you are creating a method on a table named VendTable. The method must return only the tax exemption number (VATNum). You need to return the VATNum for the vendor whose account number is 3000, by passing it in the _accountNum parameter. Which of the following select statements could you use? (Choose all that apply.)

Options

  • A(select VendTable where VendTable.AccountNum == _accountNum).VatNum;
  • B(select firstOnly VATNum from VendTable having VendTable.AccountNum == _accountNum).VatNum;
  • C(select firstOnly VATNum from VendTable where VendTable.AccountNum == _accountNum).VatNum;
  • D(select firstOnly VATNum from VendTable where VendTable.AccountNum == _accountNum).AccountNum;

How the community answered

(26 responses)
  • A
    81% (21)
  • B
    12% (3)
  • D
    8% (2)

Community Discussion

No community discussion yet for this question.

Full MB6-869 Practice