Optimize Performance MB-500 Practice Questions (Page 3)

Questions 11–15

1. 11application · medium

   A batch job that sends email notifications is taking too long. The job loops through a large number of records and sends an email for each one. You need to optimize the batch job. What should you do?

   • AUse the Async framework to send emails asynchronously.
   • BRefactor the job to use set-based operations to collect the recipients and send emails in bulk, if the email service supports it.
   • CIncrease the batch job's priority to give it more resources.
   • DSplit the batch job into multiple smaller jobs that run in parallel.
   Reveal Solution Discussion Select an answer first
2. 12application · medium

   A financial report that uses a data provider is slow to render because it queries a large fact table without any filters. Users typically run the report for a specific fiscal year. You need to improve the report's performance. What should you do?

   • ADisable the report's interactive rendering and only allow export to Excel.
   • BUse a temporary table in the report's data provider to cache the data.
   • CAdd a range on the fiscal year field in the report's data provider query.
   • DIncrease the number of rows returned by the query to ensure all data is available.
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   A custom list page displays open sales orders. The query joins the SalesTable and SalesLine tables and filters on the SalesStatus field. The page loads slowly. You review the query and find that the SalesStatus field is not indexed. You need to improve the query performance without changing the user experience. What should you do?

   • AChange the query to use a 'ExistsJoin' instead of an 'InnerJoin' to reduce the result set.
   • BAdd a range on the RecId field to limit the number of records returned.
   • CModify the query to use a 'GroupBy' clause to aggregate the sales lines.
   • DCreate a non-clustered index on the SalesStatus field in the SalesTable table.
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   When modifying an existing index to optimize query performance, which property is commonly adjusted?

   • ATable name
   • BField order
   • CLabel
   • DHelpText
   Reveal Solution Discussion Select an answer first
6. 15application · medium

   A data entity used for importing customer records is taking too long to process. The entity has a single data source with a large table, and the import job processes thousands of records. You need to improve the throughput of the data import. What should you do?

   • AEnable the 'Enable data entity performance' option on the entity and use a set-based operation.
   • BCreate a new index on the primary key of the table.
   • CAdd a second data source to the entity to split the load.
   • DUse the Data Management Framework's 'Generate sequence numbers' option.
   Reveal Solution Discussion Select an answer first