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

Questions 1–5

1. 1foundation · easy

   In a query, you want to include all records from the first data item even if there is no matching record in the second data item. Which DataItemLinkType should you use?

   • ARightOuterJoin
   • BFullOuterJoin
   • CLeftOuterJoin
   • DInnerJoin
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   Which property on a query column is used to perform an aggregation such as Sum or Average?

   • AMethod
   • BSourceColumn
   • CAggregation
   • DDataItemLinkType
   Reveal Solution Discussion Select an answer first
4. 3application · medium

   A developer needs to generate a list of all customers and the total number of open sales orders for each customer. The list will be used in a report. Which approach should the developer use to retrieve this data efficiently?

   • AUse a query that links the Customer and Sales Header tables, filters on the Status field for 'Open', and uses the Count aggregate on the Sales Header dataitem.
   • BUse a report that uses the Sales Header table as the data source and counts the orders in the report's data item.
   • CUse a record variable to loop through the Customer table and, for each customer, use a record variable to count the open sales orders.
   • DUse a page with a subpage that shows the Sales Header records for each customer, and let the user count the orders manually.
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   You are building a report that shows a list of customers and their total sales. You already have a query that returns this aggregated data. How do you make the report use that query?

   • ASet the DataItemTable property to the query's name.
   • BSet the DataItemQuery property of the report's data item to the query's name.
   • CUse the query as a global variable and call it in the report's OnPreReport trigger.
   • DCopy the query's AL code into the report's codeunit.
   Reveal Solution Discussion Select an answer first
6. 5application · medium

   A query is used to show the total quantity of items sold per item. The query currently returns individual sales line records. You need to modify the query to aggregate the quantity by item. Which change should you make?

   • AAdd the Average aggregate to the Quantity field and group by the Item No. field.
   • BAdd a filter on the Quantity field to only include positive values and keep the query as is.
   • CAdd the Count aggregate to the Quantity field and group by the Item No. field.
   • DAdd the Sum aggregate to the Quantity field and group by the Item No. field.
   Reveal Solution Discussion Select an answer first