Apply Fundamental Performance Optimization Techniques MB-500 Practice Questions (Page 5)

Questions 21–25

1. 21expert · hard

   A Dynamics 365 Finance and Operations environment is experiencing deadlocks during peak hours. The developer analyzes the deadlock graphs and finds that two batch jobs are updating the same set of records in different orders. The batch jobs run concurrently and are both critical to the business. The developer wants to eliminate the deadlocks without reducing the concurrency of the batch jobs. What should the developer do?

   • AUse a temporary table to stage the updates and then apply them in a single transaction
   • BEnsure both batch jobs update records in the same order by sorting the data before processing
   • CUse pessimistic locking in both batch jobs to prevent concurrent access to the same records
   • DIncrease the CacheLookup property of the affected tables to EntireTable to reduce lock contention
   Reveal Solution Discussion Select an answer first
2. 22application · medium

   A developer needs to update the status field to 'Closed' for all sales orders that have no open line items. The sales order header table has 1 million records, and the line table has 5 million records. The current implementation loops through each header record and checks for open lines, then updates the status. This takes several hours. What should the developer do to improve performance?

   • AUse a while select loop but add a 'where exists' clause to filter the headers before the loop
   • BChange the CacheLookup property of the header table to EntireTable to speed up the loop
   • CUse an update_recordset with a notexists join to the line table to update all qualifying headers in one set-based operation
   • DCreate a temporary table with the qualifying header record IDs, then loop through the temporary table to update each header
   Reveal Solution Discussion Select an answer first
4. 23foundation · easy

   Which technique is commonly used in forms to cache the result of a computed field so that it is not recalculated every time the form refreshes?

   • AUsing a global variable to store the value
   • BUsing a temporary table to store the computed value
   • CSetting the CacheDataMethod property on the display method
   • DWriting the computed value to the database
   Reveal Solution Discussion Select an answer first
5. 24application · medium

   A query that joins the SalesTable and SalesLine tables is used in a report. The query currently selects all fields from both tables. The report only displays the SalesId, CustAccount, and LineAmount fields. Users report the report is slow. What should the developer do to improve the query's performance?

   • AAdd a range on the SalesId field to filter the result set.
   • BAdd a temporary table to the query to pre-aggregate the data.
   • CUse a while select loop instead of the query to fetch the data.
   • DChange the query to select only the fields needed by the report.
   Reveal Solution Discussion Select an answer first
6. 25foundation · easy

   Which modification to an existing query in Dynamics 365 Finance and Operations is most likely to improve its performance?

   • ARemoving unnecessary joins
   • BRemoving all filters
   • CAdding more fields to the select statement
   • DUsing a while select instead of a set-based operation
   Reveal Solution Discussion Select an answer first