Microsoft
MB-500 · Question #37
An organization has two million customers that are part of the International customer group. Validation must occur when customer records are updated. For all customers where the value of the customer
Sign in or unlock MB-500 to reveal the answer and full explanation for question #37. The question stem and answer options stay visible for context.
Develop business logic
Question
An organization has two million customers that are part of the International customer group. Validation must occur when customer records are updated. For all customers where the value of the customer group field is international, you must the delivery mode to Air. You need to update the customer records. Which two segments can you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. A. B. C. D. E.
Exhibit
Options
- Attsbegin; while select forupdate CustTable where CustTable.CustGroup == 'International' { CustTable.DlvMode = 'Air'; CustTable.update(); } ttscommit;
- Bttsbegin; update CustTable set DlvMode = 'Air'; where CustTable.CustGroup == 'International' ttscommit;
- Cttsbegin; update_recordset CustTable setting DlvMode = 'Air' where CustTable.CustGroup == 'International' ttscommit;
- Dttsbegin; while select forupdate CustTable where CustTable.CustGroup == 'International' { CustTable.DlvMode = 'Air'; CustTable.doUpdate(); } ttscommit;
- Ettsbegin; update_recordset CustTable setting DlvMode = 'Air' where CustTable.CustGroup == 'International' ttscommit;
Unlock MB-500 to see the answer
You've previewed enough free MB-500 questions. Unlock MB-500 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#update_recordset#while select forupdate#X++ DML#set-based operations