Question 310
At fictional Juniper Hospitality, the Business Central development team is supporting property purchasing and billing and reviewing object model and application extensibility during a troubleshooting exercise (MB820-3.2-069). The observed development issue is that a developer performs costly record aggregation inside a print trigger for every row. Which recurring engineering check would best prevent this issue from returning?
Explanation
Correct Answer
The ongoing check is to track report duration and query volume after design changes. This helps detect recurrence when a developer performs costly record aggregation inside a print trigger for every row. The associated correction is to move expensive aggregations to appropriate query or dataset design and profile execution; a confirming result is that output totals remain correct while runtime and database workload decline.
Incorrect Answers
“Test boundary date filters and saved request settings” concerns the separate step “add a report request page exposing the supported filters and options”. The reported issue is that a developer performs costly record aggregation inside a print trigger for every row, so the direct response is to track report duration and query volume after design changes.
“Review cross-company access before enabling consolidated reporting” concerns the alternative task “make the company scope explicit and use supported authorized company access mechanisms”, but the stated failure is that a developer performs costly record aggregation inside a print trigger for every row. The required measure is to track report duration and query volume after design changes.
The proposed “Test report execution with limited permission sets” tests a different control: apply appropriate report access controls and design minimized datasets or output views. The reported condition is that a developer performs costly record aggregation inside a print trigger for every row; the more direct action is to track report duration and query volume after design changes.