You need to store a 'Status' field on a new table. The status can only be 'Open', 'In Progress', or 'Closed'. You also want to ensure that only these values can be entered. What should you do?

Create an enum with the three values and use it as the data type of the Status field.

Create a separate table for statuses and use a Codeunit to check the value before insert.

Create a field with the Text data type and add a table-level validation rule.

Create a field with the Integer data type and use a comment to document the allowed values.

You are building a new table for service orders. You need a field that stores the service priority: 'Low', 'Medium', 'High', or 'Critical'. You also need to be able to add a new priority later without changing the table schema. What should you do?

Create a field with the Text data type and use a table relation to a new Priority table.

Create a field with the Integer data type and use a codeunit to validate the value.

Create a field with the Option data type and define the values in the field's OptionString property.

Create an enum with the four priority values and use it as the field data type.

Microsoft Certified:Dynamics 365 Business Central Developer Associate

Domain 3Objective 1

Build and Extend Tables and Pages 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 17 practice questions to prepare you well beyond it. (estimate)

17questions here

4free pages

5concepts

35–40%of the exam

Questions 6–10

6application · medium
You need to store a 'Status' field on a new table. The status can only be 'Open', 'In Progress', or 'Closed'. You also want to ensure that only these values can be entered. What should you do?
Select an answer first
7expert · hard
You need to create a page that shows a list of customers and allows the user to drill down to a single customer's details. The list should also allow inline editing of the customer's name and phone number. Which page type should you use?
Select an answer first
8application · easy
A company uses a page to view a single customer record with fields and FactBoxes. They now need a page that shows a list of all customers with the ability to drill down to the single customer page. Which page type should you use for the new list page?
Select an answer first
9foundation · easy
A developer is creating a Role Center page in Business Central. Which page type should be used as the main page for the Role Center?
Select an answer first
10application · medium
You are building a new table for service orders. You need a field that stores the service priority: 'Low', 'Medium', 'High', or 'Critical'. You also need to be able to add a new priority later without changing the table schema. What should you do?
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 Tables and Pages in Business Central MB-820 Practice Questions (Page 2)

Questions 6–10

You need to store a 'Status' field on a new table. The status can only be 'Open', 'In Progress', or 'Closed'. You also want to ensure that only these values can be entered. What should you do?

You need to create a page that shows a list of customers and allows the user to drill down to a single customer's details. The list should also allow inline editing of the customer's name and phone number. Which page type should you use?

A company uses a page to view a single customer record with fields and FactBoxes. They now need a page that shows a list of all customers with the ability to drill down to the single customer page. Which page type should you use for the new list page?

A developer is creating a Role Center page in Business Central. Which page type should be used as the main page for the Role Center?

You are building a new table for service orders. You need a field that stores the service priority: 'Low', 'Medium', 'High', or 'Critical'. You also need to be able to add a new priority later without changing the table schema. What should you do?

Keep studying — Develop by using AL objects