What is a common reason to modify an existing index?

To add a new field to the table

To change the table's primary key

To align the index with new query patterns

A batch job that processes sales orders is running slowly. The job uses a loop to update each order and then sends an email notification. You need to optimize the job while ensuring that each order is processed exactly once. What should you do?

Increase the batch job's priority to give it more resources.

Use the Async framework to process each order in parallel.

Use a set-based update for the orders and then send emails in a separate loop.

Remove the email notification to speed up the job.

What is a primary goal of optimizing batch processes?

Reduce the need for user interaction

Increase the number of batch jobs

Improve system performance and resource utilization

A custom form has a button that triggers a long-running operation to generate a report. The form freezes until the operation completes. You need to improve the user experience by making the operation asynchronous. What should you do?

Increase the form's timeout value to allow the operation to complete.

Use the Sandbox framework to run the operation in an isolated environment.

Change the operation to run as a batch job that is triggered by the button.

Use the Async framework to run the operation in the background, and notify the user when it completes.

Microsoft Certified:Dynamics 365 Finance and Operations Apps Developer Associate

Domain 7Objective 3

Optimize Performance MB-500 Practice Questions (Page 5)

Part of the Implement security and optimize performance domain, which accounts for 10–15% of the MB-500 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~4–10 in this domain), expect 1–3 from this objective — we provide 41 practice questions to prepare you well beyond it. (estimate)

41questions here

9free pages

10concepts

10–15%of the exam

Questions 21–25

21foundation · easy
What is a common reason to modify an existing index?
Select an answer first
22expert · hard
A batch job that processes sales orders is running slowly. The job uses a loop to update each order and then sends an email notification. You need to optimize the job while ensuring that each order is processed exactly once. What should you do?
Select an answer first
23foundation · easy
What is a primary goal of optimizing batch processes?
Select an answer first
24application · medium
A custom form has a button that triggers a long-running operation to generate a report. The form freezes until the operation completes. You need to improve the user experience by making the operation asynchronous. What should you do?
Select an answer first
25foundation · easy
Which property on a data source query can be used to limit the number of records retrieved, thereby improving query performance?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to MB-500

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “MB-500” is a trademark of its owner, used for identification only.