Microsoft
MB-500 · Question #341
MB-500 Question #341: Real Exam Question with Answer & Explanation
Sign in or unlock MB-500 to reveal the answer and full explanation for question #341. The question stem and answer options stay visible for context.
Question
A company uses Dynamics 365 Supply Chain Management. You are performing a review of the code that returns the total sum of transactions for all customers in customer group 10. You observe that the following query takes a long time to complete. You need to modify the query to optimize performance. Which code segment should you use?
Exhibit
Options
- ASelect sum(AmountMst) from custTrans join custId, custGroup from custTable where
- BAmountMST sumTrans = 0; while select AmountMst from custTrans join custTable where
- Cselect sum(AmountMst) from custTrans join custTable where custTable.AccountNum ==
- Dselect sum(AmountMst) from custTrans exists join custTable where custTable.AccountNum ==
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.