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

Questions 1–5

1. 1application · medium

   A Dynamics 365 Finance and Operations environment is experiencing slow performance during peak hours. The developer analyzes the database and finds that multiple batch jobs are running concurrently and performing large updates on the same table, causing lock contention. What should the developer do to reduce concurrency-related bottlenecks?

   • AUse a temporary table to stage the updates and then apply them in a single transaction
   • BSchedule the batch jobs to run at different times to avoid concurrent updates on the same table
   • CChange the batch job's concurrency model to use pessimistic locking
   • DIncrease the CacheLookup property of the table to EntireTable to reduce database locks
   Reveal Solution Discussion Select an answer first
2. 2expert · hard

   A developer is optimizing a complex financial reconciliation process. The process must: (1) identify all general journal entries posted in the last month, (2) calculate a running balance for each account, (3) flag any account where the balance exceeds a threshold, and (4) update a summary table. The journal entry table has 2 million records, and the summary table has 10,000 accounts. The developer initially wrote a while select loop that processes each journal entry, updates the running balance, and flags accounts. This takes 45 minutes. The developer rewrote the logic to use a set-based aggregate query to calculate balances and update the summary table, reducing the time to 5 minutes. However, a new requirement states that the process must also generate a detailed audit trail of every journal entry that contributed to a flagged account. The audit trail must include the journal entry ID, account, and amount. What is the most appropriate approach to meet the new requirement while maintaining the performance improvement?

   • AUse a set-based query to identify flagged accounts, then use a while select loop to insert the audit trail records for only those accounts
   • BUse a single set-based insert_recordset to populate the audit trail table directly from the journal entries, joining to the flagged accounts
   • CStore the audit trail data in the global cache and write it to the table asynchronously
   • DUse a temporary table to store the flagged account IDs, then loop through the journal entries to insert audit trail records for those accounts
   Reveal Solution Discussion Select an answer first
4. 3application · medium

   A developer is writing a batch job that processes a large set of inventory transactions. The job needs to aggregate data from multiple tables and then perform several lookups on the aggregated data. The aggregated data is only needed within the job. What should the developer use to store the intermediate results?

   • AAn in-memory temporary table (InMemory) that is declared as a local variable.
   • BA regular table buffer with the Temporary property set to No.
   • CA list of containers that hold the aggregated values.
   • DA regular database table with a unique index on the aggregation key.
   Reveal Solution Discussion Select an answer first
5. 4application · medium

   A developer is writing a method that processes a large collection of records. The method declares a large container variable at the top of the method, but the container is only used in a small block of code near the end. The method is called frequently and consumes a lot of memory. What should the developer do to reduce memory usage?

   • AMove the container declaration inside the block where it is used.
   • BDeclare the container as static to reuse it across calls.
   • CUse a temporary table instead of a container.
   • DUse a global variable instead of a local variable.
   Reveal Solution Discussion Select an answer first
6. 5expert · hard

   A Dynamics 365 Finance environment has a batch job that processes a large number of records. The job is running slowly, and the developer suspects that the job is experiencing lock contention with other processes. The developer wants to reduce lock contention without sacrificing data consistency. What should the developer do?

   • ARun the batch job during off-peak hours only.
   • BUse the NoLock hint on all queries in the batch job.
   • CIncrease the transaction isolation level to Serializable.
   • DBreak the batch job into smaller transactions that commit more frequently.
   Reveal Solution Discussion Select an answer first