A developer needs to retrieve a list of all customers with their outstanding balances from the Customer and Detailed Customer Ledger Entry tables. The list will be displayed in a page and does not require any additional processing. Which approach should the developer use?

Use a record variable to loop through the Customer table and, for each customer, loop through the Detailed Customer Ledger Entry table to sum the Amount field.

Use a query object that links the Customer and Detailed Customer Ledger Entry tables and aggregates the Amount field by customer.

Use a report that uses the Customer table as the data item and the Detailed Customer Ledger Entry table as a sub-data item without aggregation.

Use a page with a subpage that directly displays the Detailed Customer Ledger Entry table for each customer.

You want to limit the results of a query to only customers in the 'EAST' region. Which property should you set on the Customer data item?

DataItemTableFilter = "Region" = filter('EAST')

ColumnFilter = "Region" = filter('EAST')

DataItemLink = "Region" = filter('EAST')

You are creating a query that shows sales orders with their related customer names. Which element in the query object defines the relationship between the Sales Header and Customer data items?

DataItemTableFilter on the Customer data item

Column with a SourceColumn property

DataItemLink with DataItemLinkType=InnerJoin

Microsoft Certified:Dynamics 365 Business Central Developer Associate

Domain 3Objective 6

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

Part of the Develop by using AL objects domain, which accounts for 35–40% of the MB-820 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~14–26 in this domain), expect 2–4 from this objective — we provide 16 practice questions to prepare you well beyond it. (estimate)

16questions here

4free pages

6concepts

35–40%of the exam

Questions 6–10

6foundation · easy
Which property in a query data item is used to apply a static filter to the underlying table?
Select an answer first
7application · medium
A developer needs to retrieve a list of all customers with their outstanding balances from the Customer and Detailed Customer Ledger Entry tables. The list will be displayed in a page and does not require any additional processing. Which approach should the developer use?
Select an answer first
8foundation · easy
You want to limit the results of a query to only customers in the 'EAST' region. Which property should you set on the Customer data item?
Select an answer first
9foundation · easy
You are creating a query that shows sales orders with their related customer names. Which element in the query object defines the relationship between the Sales Header and Customer data items?
Select an answer first
10foundation · easy
Which property in a query object determines whether a data item is joined using an inner join or a left outer join?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to MB-820

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “MB-820” is a trademark of its owner, used for identification only.

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

Questions 6–10

Which property in a query data item is used to apply a static filter to the underlying table?

A developer needs to retrieve a list of all customers with their outstanding balances from the Customer and Detailed Customer Ledger Entry tables. The list will be displayed in a page and does not require any additional processing. Which approach should the developer use?

You want to limit the results of a query to only customers in the 'EAST' region. Which property should you set on the Customer data item?

You are creating a query that shows sales orders with their related customer names. Which element in the query object defines the relationship between the Sales Header and Customer data items?

Which property in a query object determines whether a data item is joined using an inner join or a left outer join?

Keep studying — Develop by using AL objects