A developer is writing a procedure that parses a string containing a list of item numbers separated by semicolons. The developer needs to extract each item number and store it in a temporary table. The string may contain empty entries (e.g., 'ITEM1;;ITEM2;'). The developer needs to skip empty entries. Which AL code should the developer use?

Use the STRPOS function to find semicolons and then use COPYSTR to extract each item.

Use the SPLIT function and then loop through the resulting array, skipping empty strings.

Use the DELCHR function to remove semicolons and then process the remaining string.

Use the COPYSTR function to extract each item number based on the semicolon position.

Microsoft Certified:Dynamics 365 Business Central Developer Associate

Domain 4Objective 3

Use AL to Extend Business Central MB-820 Practice Questions (Page 2)

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

33questions here

7free pages

10concepts

15–20%of the exam

Questions 6–10

6application · easy
A developer is writing AL code to store a customer's phone number. The phone number can contain digits, spaces, and hyphens, and may be up to 30 characters. Which data type should the developer use for the variable?
Select an answer first
7application · medium
A developer is writing a procedure that calculates the average of a set of decimal values. The values are stored in a temporary table. The developer declares a variable to hold the sum and another to hold the count. Which data types should the developer use for these variables?
Select an answer first
8expert · hard
A developer is writing a procedure that parses a string containing a list of item numbers separated by semicolons. The developer needs to extract each item number and store it in a temporary table. The string may contain empty entries (e.g., 'ITEM1;;ITEM2;'). The developer needs to skip empty entries. Which AL code should the developer use?
Select an answer first
9foundation · easy
Which AL method is used to update an existing record in a table?
Select an answer first
10foundation · easy
Which AL method is used to insert a new record into a table?
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.

Use AL to Extend Business Central MB-820 Practice Questions (Page 2)

Questions 6–10

A developer is writing AL code to store a customer's phone number. The phone number can contain digits, spaces, and hyphens, and may be up to 30 characters. Which data type should the developer use for the variable?

A developer is writing a procedure that calculates the average of a set of decimal values. The values are stored in a temporary table. The developer declares a variable to hold the sum and another to hold the count. Which data types should the developer use for these variables?

Which AL method is used to update an existing record in a table?

Which AL method is used to insert a new record into a table?

Keep studying — Develop by using AL