Exam MB-820 topic 1 question 97 discussion

Actual exam question from Microsoft's MB-820

Question #: 97
Topic #: 1

DRAG DROP
-

You develop a table named Contoso Setup and a page.

You plan to use No. Series to automatically assign a unique number to data entries. You set up No. Series on the Vendor Nos. field of the Contoso Setup table.

You need to apply the No. Series Design Pattern to the trigger OnInsert().

Which four code segments should you use to develop the solution? To answer, move the appropriate code segments from the list of code segments to the answer area and arrange them in the correct order.

Show Suggested Answer

Suggested Answer:

by month8848 at Jan. 18, 2025, 12:57 p.m.

Comments

Submit Cancel

Fennek1893

Highly Voted 4 months, 2 weeks ago

Answer is horrendous: 6 - if "No." = '' then begin [we need the 'begin', otherwise the 'end;' in 5 doesn't make sense] 1 - ContosoSetup.Get(); [Even tho setup-tables dont have to be singletons we would need a "FindFirst" or "FindSet" to use a setup then] 4 - ContosoSetup.TestField("Vendor Nos."); [Tests if field in setup-table is filled and throws an Error if ist empty] 5 - NoSeriesManagement.InitSeries(ContosoSetup."Vendor Nos.", xRec."No. Series", 0D, "No.", "No. Series"); end; [Field in ContosoSetup is Called "Vendor Nos." not "No. Series"] you can rearrange it potentially to 1-4-6-5, but then we would need begin and end and the setup-table would be called everytime even tho its not needed everytime (perfomance would be "worse")

upvoted 7 times

...