A report that uses a data provider is slow because it retrieves all records from a table and then aggregates them in code. The report is used by multiple departments, each with different filtering needs. You need to improve performance without changing the report's user interface. What should you do?

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

Create a separate report for each department with pre-filtered queries.

Use a temporary table in the report to cache the aggregated data.

Move the aggregation logic to the data provider query using SQL aggregation functions.

After capturing a trace of a slow sales order form, you notice that a query on the SalesTable table is performing a table scan. The query filters on the SalesId field and the OrderDate field. Currently, there is a non-clustered index on SalesId only. What should you do to improve the query performance?

Add a filter on the query to only return the first 100 records.

Drop the existing index on SalesId and create a clustered index on OrderDate.

Create a composite index on SalesId and OrderDate.

Use the Query Expression to add a range on SalesId only.

A table has an existing non-clustered index on the 'Type' field. A new query filters on both 'Type' and 'Status'. The query is slow. You need to modify the index to improve performance without affecting other queries that use the index. What should you do?

Change the index key to 'Status' and then 'Type'.

Drop the existing index and create a new composite index on 'Type' and 'Status'.

Create a new separate index on 'Status' and leave the existing index unchanged.

Add 'Status' as an included column to the existing index on 'Type'.

A data entity used for exporting sales orders is slow. The entity includes a method that calculates a discount based on a custom business rule. The export job processes 100,000 records. You need to improve the export performance. You have already optimized the query and added indexes. What else can you do?

Move the discount calculation from the entity method to a SQL view or a computed column that uses SQL functions.

Use the Async framework to run the export asynchronously.

Disable the entity's validation logic to speed up the export.

Increase the batch size of the export job to 200,000 records.

Microsoft Certified:Dynamics 365 Finance and Operations Apps Developer Associate

Domain 7Objective 3

Optimize Performance MB-500 Practice Questions (Page 4)

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 16–20

16foundation · easy
A developer needs to capture a performance trace to identify bottlenecks in a specific user scenario. Which tool is designed for this purpose?
Select an answer first
17expert · hard
A report that uses a data provider is slow because it retrieves all records from a table and then aggregates them in code. The report is used by multiple departments, each with different filtering needs. You need to improve performance without changing the report's user interface. What should you do?
Select an answer first
18application · medium
After capturing a trace of a slow sales order form, you notice that a query on the SalesTable table is performing a table scan. The query filters on the SalesId field and the OrderDate field. Currently, there is a non-clustered index on SalesId only. What should you do to improve the query performance?
Select an answer first
19expert · hard
A table has an existing non-clustered index on the 'Type' field. A new query filters on both 'Type' and 'Status'. The query is slow. You need to modify the index to improve performance without affecting other queries that use the index. What should you do?
Select an answer first
20expert · hard
A data entity used for exporting sales orders is slow. The entity includes a method that calculates a discount based on a custom business rule. The export job processes 100,000 records. You need to improve the export performance. You have already optimized the query and added indexes. What else can you do?
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 4)

Questions 16–20

A developer needs to capture a performance trace to identify bottlenecks in a specific user scenario. Which tool is designed for this purpose?

A table has an existing non-clustered index on the 'Type' field. A new query filters on both 'Type' and 'Status'. The query is slow. You need to modify the index to improve performance without affecting other queries that use the index. What should you do?

Keep studying — Implement security and optimize performance