What is the primary purpose of the Async framework in Dynamics 365 Finance and Operations?

To provide a user interface for batch jobs

To handle synchronous database transactions

To manage asynchronous operations and improve system responsiveness

Which of the following is a recommended practice to optimize the performance of a data entity?

Include all fields from the underlying table

Use a single data source for all entities

Enable the 'Is Read Only' property on the entity

Avoid using indexes on the underlying table

A custom form's data source query is slow because it joins two large tables. The query uses a range on the first table's primary key. You notice that the query plan uses a table scan on the second table. You need to optimize the query. What should you do?

Change the join type from InnerJoin to OuterJoin.

Create an index on the foreign key field of the second table that is used in the join.

Add a range on the second table's primary key to reduce the rows.

Use the 'Exists' join instead of the 'InnerJoin'.

A Dynamics 365 Finance and Operations environment is experiencing slow response times on a specific sales order entry form. The form uses a custom data source that joins several tables. You suspect the issue is related to a missing index. You need to confirm the bottleneck before making any changes. What should you do first?

Capture a performance trace using Trace Parser while reproducing the slow form operation, then analyze the query statistics and execution plans in the trace.

Run the SQL Server Database Engine Tuning Advisor directly against the production database to get index recommendations.

Review the form's data source properties and change the 'JoinMode' to 'ExistsJoin' to reduce the data returned.

Create a new index on the most frequently used table in the data source and then re-test the form to see if performance improves.

Microsoft Certified:Dynamics 365 Finance and Operations Apps Developer Associate

Domain 7Objective 3

Optimize Performance MB-500 Practice Questions (Page 6)

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 26–30

26foundation · easy
What is the primary purpose of the Async framework in Dynamics 365 Finance and Operations?
Select an answer first
27foundation · easy
Which of the following is a recommended practice to optimize the performance of a data entity?
Select an answer first
28expert · hard
A custom form's data source query is slow because it joins two large tables. The query uses a range on the first table's primary key. You notice that the query plan uses a table scan on the second table. You need to optimize the query. What should you do?
Select an answer first
29application · medium
A Dynamics 365 Finance and Operations environment is experiencing slow response times on a specific sales order entry form. The form uses a custom data source that joins several tables. You suspect the issue is related to a missing index. You need to confirm the bottleneck before making any changes. What should you do first?
Select an answer first
30foundation · easy
Which feature in Dynamics 365 Finance and Operations is used to improve report performance by pre-aggregating data?
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.

Optimize Performance MB-500 Practice Questions (Page 6)

Questions 26–30

What is the primary purpose of the Async framework in Dynamics 365 Finance and Operations?

Which of the following is a recommended practice to optimize the performance of a data entity?

A custom form's data source query is slow because it joins two large tables. The query uses a range on the first table's primary key. You notice that the query plan uses a table scan on the second table. You need to optimize the query. What should you do?

Which feature in Dynamics 365 Finance and Operations is used to improve report performance by pre-aggregating data?

Keep studying — Implement security and optimize performance