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

Questions 41–45

1. 41foundation · easy

   Which tool or feature in Dynamics 365 Finance and Operations can be used to analyze concurrency issues?

   • ACode editor
   • BForm designer
   • CData entity wizard
   • DTrace parser
   Reveal Solution Discussion Select an answer first
2. 42application · medium

   A developer is troubleshooting a slow-running query that joins the SalesTable and SalesLine tables. The query filters on the SalesId field in SalesTable and the ItemId field in SalesLine. The developer notices that the query plan is performing a table scan on SalesLine. What should the developer do to improve the query's performance?

   • AAdd an index on the ItemId field in the SalesLine table
   • BUse a temporary table to store the filtered SalesLine records before joining
   • CRewrite the query to use a while select loop instead of a join
   • DChange the CacheLookup property of SalesLine to EntireTable to avoid the scan
   Reveal Solution Discussion Select an answer first
4. 43expert · hard

   A developer is refactoring a method that is called frequently in a loop. The method currently declares a large list object and populates it with data from a database query. The list is only used to check if a specific value exists. The developer wants to reduce memory usage and improve performance. What should the developer do?

   • AUse a temporary table to store the list and query it for existence.
   • BReplace the list with a set-based exists query that checks the value directly in the database.
   • CMove the list declaration outside the loop and reuse it across iterations.
   • DUse a singleton class to hold the list so it is created only once.
   Reveal Solution Discussion Select an answer first
5. 44foundation · easy

   In a Dynamics 365 Finance and Operations form, which property controls whether the form's data is cached on the client to improve responsiveness when navigating between records?

   • ADataCache
   • BRunOn
   • CFormDataSource.CacheLookup
   • DCacheDataMethod
   Reveal Solution Discussion Select an answer first
6. 45foundation · easy

   Which strategy can help optimize concurrency and improve system throughput in Dynamics 365 Finance and Operations?

   • AIncreasing the number of locks on tables
   • BUsing longer transactions to hold locks
   • CReducing the number of database round trips by using set-based operations
   • DDisabling all caching
   Reveal Solution Discussion Select an answer first