A report that shows inventory turnover is slow. The report uses a data provider that queries the InventTrans table and joins with InventTable. The report is used by multiple users at the same time. You need to improve the report's performance. You have already added indexes on the join fields. What else can you do?

Increase the report's timeout value to allow more time for the query to complete.

Change the report to use a 'CrossCompany' query to include all legal entities.

Move the report to a batch process that runs overnight.

Pre-aggregate the data in a separate table or view that is updated by a batch job.

What is a common technique to enhance the performance of a data source query?

Adding appropriate indexes on the underlying tables

Removing all filters from the query

Disabling caching on the data source

What is a common approach to improve the performance of a report that queries a large dataset?

Use a less efficient data source

Increase the number of fields in the report

Use appropriate filters to limit the data retrieved

Remove all filters to show all data

What is the primary purpose of capturing a performance trace using Trace Parser?

To debug logic errors in X++ code

To identify performance bottlenecks in code execution

Microsoft Certified:Dynamics 365 Finance and Operations Apps Developer Associate

Domain 7Objective 3

Optimize Performance MB-500 Practice Questions (Page 8)

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 36–40

36expert · hard
A report that shows inventory turnover is slow. The report uses a data provider that queries the InventTrans table and joins with InventTable. The report is used by multiple users at the same time. You need to improve the report's performance. You have already added indexes on the join fields. What else can you do?
Select an answer first
37foundation · easy
What is a common technique to enhance the performance of a data source query?
Select an answer first
38foundation · easy
What is a common approach to improve the performance of a report that queries a large dataset?
Select an answer first
39foundation · easy
After capturing a performance trace, which view in Trace Parser is used to see the most time-consuming operations?
Select an answer first
40foundation · easy
What is the primary purpose of capturing a performance trace using Trace Parser?
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 8)

Questions 36–40

What is a common technique to enhance the performance of a data source query?

What is a common approach to improve the performance of a report that queries a large dataset?

After capturing a performance trace, which view in Trace Parser is used to see the most time-consuming operations?

What is the primary purpose of capturing a performance trace using Trace Parser?

Keep studying — Implement security and optimize performance