You are creating a report that lists inventory items with their current stock level. The report should only include items where the stock level is below the reorder point. You want to perform this filtering in the report code, not in the query. What should you do?

Use the OnInitReport trigger to set a filter on the item data item for the stock level field.

Use the OnAfterGetRecord trigger to check the stock level and skip the record if it is not below the reorder point.

Use the OnPostDataItem trigger to delete records that do not meet the condition from the report dataset.

Use the OnPreDataItem trigger to set a filter on the item data item for the stock level field.

In an AL report object, where are the columns that appear in the report defined?

In the data item's column section

A company has a standard report 'Customer - Top 10' that is used in a role center. They have created a custom report with ReportSubstitution to replace it. However, after deployment, the role center still shows the original report. What is the most likely reason?

The custom report does not have the same data items as the original report.

The custom report is not published to the same extension as the role center.

The custom report is not set as the default layout for the original report.

The role center is using a different report ID, not the one that was substituted.

A company has a standard report that is used in multiple places, including a page action and a codeunit. They have created a custom report with the ReportSubstitution property set to the standard report's ID. However, when the report is run from the codeunit, the standard report is still used. What is the most likely reason?

The codeunit uses the Report.Run method with the standard report's ID, which bypasses substitution.

The custom report is not published to the production environment.

The custom report has a different data model than the standard report.

The ReportSubstitution property is set on the standard report instead of the custom report.

Microsoft Certified:Dynamics 365 Business Central Developer Associate

Domain 3Objective 2

Build and Extend Reports MB-820 Practice Questions (Page 3)

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 31 practice questions to prepare you well beyond it. (estimate)

31questions here

7free pages

8concepts

35–40%of the exam

Questions 11–15

11foundation · easy
Which file formats can be used to create custom report layouts for Business Central reports?
Select an answer first
12application · medium
You are creating a report that lists inventory items with their current stock level. The report should only include items where the stock level is below the reorder point. You want to perform this filtering in the report code, not in the query. What should you do?
Select an answer first
13foundation · easy
In an AL report object, where are the columns that appear in the report defined?
Select an answer first
14expert · hard
A company has a standard report 'Customer - Top 10' that is used in a role center. They have created a custom report with ReportSubstitution to replace it. However, after deployment, the role center still shows the original report. What is the most likely reason?
Select an answer first
15expert · hard
A company has a standard report that is used in multiple places, including a page action and a codeunit. They have created a custom report with the ReportSubstitution property set to the standard report's ID. However, when the report is run from the codeunit, the standard report is still used. What is the most likely reason?
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.

Build and Extend Reports MB-820 Practice Questions (Page 3)

Questions 11–15

Which file formats can be used to create custom report layouts for Business Central reports?

You are creating a report that lists inventory items with their current stock level. The report should only include items where the stock level is below the reorder point. You want to perform this filtering in the report code, not in the query. What should you do?

In an AL report object, where are the columns that appear in the report defined?

A company has a standard report 'Customer - Top 10' that is used in a role center. They have created a custom report with ReportSubstitution to replace it. However, after deployment, the role center still shows the original report. What is the most likely reason?

Keep studying — Develop by using AL objects