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

Questions 26–30

1. 26foundation · easy

   Which property on a table in Dynamics 365 Finance and Operations makes it a temporary table?

   • ATableType = TempDB
   • BTableGroup = Transaction
   • CReplication = NotReplicated
   • DCacheLookup = EntireTable
   Reveal Solution Discussion Select an answer first
2. 27application · medium

   A developer notices that two batch jobs frequently deadlock because they update the same set of records in different orders. What should the developer do to reduce the chance of deadlocks?

   • AEnsure both jobs update records in the same order.
   • BRun both jobs on the same batch server.
   • CIncrease the transaction isolation level to Serializable.
   • DUse the NoLock hint on all queries in both jobs.
   Reveal Solution Discussion Select an answer first
4. 28expert · hard

   A developer is building a service that provides real-time inventory availability. The service is called by multiple users across different sessions and must return results in under 2 seconds. The inventory data is stored in a table that is updated by a separate batch process every 15 minutes. The developer initially used a singleton class to cache the inventory data in a static variable. However, after a deployment, users reported that the service returned stale data for up to an hour. The developer also noticed that the singleton class holds a large container that is consuming significant memory on the AOS. What should the developer do to fix the staleness issue and reduce memory usage?

   • AReplace the singleton with AppGlobalCache and set an expiration of 15 minutes to match the batch update cycle
   • BChange the singleton to store the data in a temporary table instead of a static variable
   • CUse a combination of the singleton and AppGlobalCache, storing the data in both to ensure availability
   • DKeep the singleton but add a method to manually clear the static variable when the batch process completes
   Reveal Solution Discussion Select an answer first
5. 29foundation · easy

   In Dynamics 365 Finance and Operations, which caching mechanism is used to store table records in memory so that repeated lookups of the same record do not require a database round trip?

   • AForm-level caching
   • BRecord-level caching
   • CGlobal cache
   • DTemporary table caching
   Reveal Solution Discussion Select an answer first
6. 30foundation · easy

   In Dynamics 365 Finance and Operations, which type of table is used to store intermediate data during a process without persisting it to the database?

   • ATemporary table
   • BExternal table
   • CView
   • DRegular table
   Reveal Solution Discussion Select an answer first