Exam MB-500 topic 6 question 42 discussion

Actual exam question from Microsoft's MB-500

Question #: 42
Topic #: 6

An organization has 1,000 vendors that are part of a vendor group named Employee. You have a field named DlvTerm that is used to describe the delivery terms for a vendor.

You need to set the value of DlvTerm to Cash for all vendors in the vendor group. You must update all vendor records in the vendor group as a single bulk operation.

Which two code segments can you use? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer: BC 🗳️

by kself at Jan. 25, 2024, 2:41 a.m.

Comments

Submit Cancel

globeearth

1 month, 1 week ago

Selected Answer: BD

why it is D instead of C? Use update(): When you are writing custom X++ code to perform a targeted update on a specific data entity. When the update is a standalone operation, and you don’t need the additional overhead of the full data management pipeline. Use execute(): When the update is part of a larger data management process, such as importing data from an external file or running a data migration job. When you need to leverage the Data Management framework’s built-in features, such as staging tables, error logging, or batch processing.

upvoted 1 times

...

kself

1 year, 5 months ago

I agree that BC are probably the best answers, but A also appears to be a valid answer unless I'm missing something small

upvoted 1 times

a50dc84

1 year, 4 months ago

A is not bulk, it's a while select that is record-by-record

upvoted 5 times

8933e4c

9 months ago

Correct, the kernel will replace the update_recordset with a while internally, since the update trigger is overwritten.

upvoted 1 times

8933e4c

9 months ago

I found a comment in the code, that execute is obsolete: [Hookable(false), SysObsolete('Use the update method instead of this method', false, 02\04\2020)]

upvoted 2 times

...