Create Queries in Business Central MB-820 Practice Questions (Page 3)

Questions 11–15

1. 11application · medium

   A developer needs to retrieve a list of customers with their total sales for the last 30 days. The result will be used to generate a one-time report. Which approach is most appropriate?

   • ACreate a query that joins Customer with Sales Invoice Header, groups by Customer No., and sums the Total Amount, then use the query in the report.
   • BUse a record variable to loop through all customers and, for each, loop through Sales Invoice Headers to sum the totals.
   • CCreate a temporary table, populate it with customer totals using a codeunit, and then use the temporary table in the report.
   • DUse a page with a repeater that calculates totals on the fly from the Customer and Sales Invoice Header tables.
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   What is a primary advantage of using a query object over a record variable when retrieving data from multiple related tables?

   • AQueries automatically update the database when data changes.
   • BQueries can join multiple tables and return only the needed fields in a single read operation.
   • CQueries do not require permissions on the underlying tables.
   • DQueries can be used to insert records into multiple tables at once.
   Reveal Solution Discussion Select an answer first
4. 13expert · hard

   A developer must create a page that shows a list of customers with their total sales for the current year. The page must be fast even with a large customer base. The developer is considering using a query versus a record variable loop. Which consideration is most important?

   • ARecord variable loops are always faster because they use the application server's cache.
   • BRecord variable loops are more efficient because they allow for complex business logic during aggregation.
   • CQueries push the join and aggregation to the database, returning only the aggregated rows, which is more efficient for large data sets.
   • DQueries cannot be used on pages; only record variables can be used.
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   In a Business Central query object, which property is used to define how two data items are related to each other?

   • ADataItemLinkType
   • BDataItemTableFilter
   • CDataItemLink
   • DLinkTable
   Reveal Solution Discussion Select an answer first
6. 15application · medium

   A query joins the Item table with the Item Ledger Entry table to show item quantities. The developer must ensure the query only returns items that have at least one ledger entry. Which join type should be used?

   • ALeftOuterJoin
   • BCrossJoin
   • CInnerJoin (default)
   • DRightOuterJoin
   Reveal Solution Discussion Select an answer first