Question 450
A month-end reconciliation should include only posted transactions from the fiscal period. The developer recommends the following change: Apply the right filters to query dataitems or columns before aggregation. Which technical explanation most directly justifies it in this case?
Explanation
Correct Answer
Query filters reduce the source rowset so subsequent joins and aggregates operate on relevant records. It connects the proposed action to the exact failure or requirement—A month-end reconciliation should include only posted transactions from the fiscal period. Confirmation would be results exclude records outside the filter and totals match the same filtered scope.
Incorrect Answers
That mechanism explains why the alternative action—use a pagetype api query for a read-only joined or aggregated endpoint—helps in another case. It does not justify the proposed fix here; query filters reduce the source rowset so subsequent joins and aggregates operate on relevant records. The distinguishing requirement is: A month-end reconciliation should include only posted transactions from the fiscal period.
That mechanism explains why the alternative action—use a normal query object suitable for viewing its dataset in the application—helps in another case. It does not justify the proposed fix here; query filters reduce the source rowset so subsequent joins and aggregates operate on relevant records. The distinguishing requirement is: A month-end reconciliation should include only posted transactions from the fiscal period.
That mechanism explains why the alternative action—evaluate replacing the record loop with a database-backed query and aggregation—helps in another case. It does not justify the proposed fix here; query filters reduce the source rowset so subsequent joins and aggregates operate on relevant records. The distinguishing requirement is: A month-end reconciliation should include only posted transactions from the fiscal period.





Microsoft Dynamics 365 Business Central Developer (MB-820) Practice Tests