Optimize Performance MB-500 Practice Questions (Page 2)

Questions 6–10

1. 6application · medium

   A custom list page displays a large number of records from a table that has a natural index on the primary key. The page is slow to load because the query retrieves all columns and then filters in code. You need to optimize the data source query. What should you do?

   • AChange the page to use a temporary table instead of a regular table.
   • BUse the 'CrossCompany' property on the query to include all legal entities.
   • CAdd a range on the query to filter the records in the database.
   • DRemove the index on the primary key to speed up inserts.
   Reveal Solution Discussion Select an answer first
2. 7expert · hard

   A data entity used for importing vendor records is slow. The entity includes a method that validates the vendor's tax ID using a web service call. The import job processes 10,000 records. You need to improve the import performance. You have already optimized the query and added indexes. What else can you do?

   • AUse the Async framework to run the import asynchronously.
   • BDisable the entity's validation logic to speed up the import.
   • CIncrease the batch size of the import job to 20,000 records.
   • DMove the tax ID validation to a batch process that runs after the import, and use a set-based approach to update the validation status.
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   What is a key benefit of optimizing data entities for performance?

   • AReduced need for batch processing
   • BEnhanced user interface design
   • CImproved data processing efficiency
   • DSimplified security configuration
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   What is the primary purpose of the Sandbox framework in Dynamics 365 Finance and Operations?

   • ATo deploy code to production
   • BTo optimize database indexes
   • CTo isolate and test changes in a controlled environment
   • DTo manage user permissions
   Reveal Solution Discussion Select an answer first
6. 10expert · hard

   A batch job that posts inventory transactions is running longer than expected. The job processes a large number of records and uses a loop that calls the 'update' method on each record individually. You need to optimize the batch job to reduce its runtime. You have captured a trace and see that the majority of time is spent on database round trips. What should you do?

   • ARefactor the loop to use set-based operations, such as 'update_recordset' or 'insert_recordset', where possible.
   • BSplit the batch job into multiple smaller batch jobs that run in parallel.
   • CDisable the batch job's transaction logging to reduce overhead.
   • DIncrease the batch job's priority so it runs with more system resources.
   Reveal Solution Discussion Select an answer first