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

Questions 6–10

1. 6application · medium

   A developer is working on a data migration job that reads from a legacy table and inserts into a new table. The job currently uses a while select loop with individual insert() calls for each record. The developer wants to improve performance by using a temporary table as an intermediate buffer. What is the most efficient way to use the temporary table in this scenario?

   • ASkip the temporary table and use a view to join the legacy and destination tables, then use update_recordset to copy data
   • BInsert records into the temporary table one at a time in the loop, then use insert_recordset to copy to the destination table
   • CInsert all records into the temporary table using insert_recordset, then use insert_recordset again to copy from the temporary table to the destination table
   • DUse the temporary table as a cache by setting its CacheLookup property to EntireTable and then loop through it to insert into the destination
   Reveal Solution Discussion Select an answer first
2. 7expert · hard

   A developer is tuning a frequently used form that displays customer details. The form queries the CustTable and CustTrans tables. The CustTable has 100,000 records, and CustTrans has 5 million records. The form currently uses the default CacheLookup settings. Users report that the form is slow when opening for a customer with many transactions. The developer analyzes the query and finds that the form is performing a full table scan on CustTrans. The developer also notices that the CustTable records are read frequently but rarely updated. What combination of changes should the developer make to improve the form's performance?

   • ASet CacheLookup for CustTable to EntireTable and add an index on the foreign key field in CustTrans that links to CustTable
   • BChange the form's data source to use a temporary table and populate it with a while select loop on form open
   • CUse AppGlobalCache to store the CustTrans records for each customer and retrieve them on form open
   • DSet CacheLookup for CustTrans to EntireTable and keep the default index on CustTable
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   What is the effect of using the 'forupdate' keyword in a select statement on concurrency?

   • AIt has no effect on concurrency
   • BIt locks the selected records, which can reduce concurrency if held for a long time
   • CIt improves concurrency by releasing locks immediately
   • DIt prevents any other user from accessing the table
   Reveal Solution Discussion Select an answer first
5. 9application · medium

   A developer is writing code that must calculate a total for each customer based on thousands of sales orders. The calculation requires a complex aggregation that cannot be done with a single SQL statement. The developer decides to use a temporary table to store intermediate results. What is the most efficient way to populate the temporary table?

   • AUse a container to hold the data and then insert it all at once.
   • BUse a set-based insert ... select statement to populate the temporary table.
   • CUse a record buffer and call insert() inside a loop.
   • DUse a while select loop to insert one record at a time.
   Reveal Solution Discussion Select an answer first
6. 10application · medium

   A Dynamics 365 Finance environment experiences slow performance during peak hours. The developer suspects that long-running transactions are blocking other users. Which tool should the developer use to identify the blocking transactions?

   • AThe Dynamics 365 Lifecycle Services (LCS) environment monitoring.
   • BThe form's Performance timer.
   • CThe Trace parser tool.
   • DThe SQL Server Management Studio Activity Monitor.
   Reveal Solution Discussion Select an answer first