Microsoft Certification
60 practice questions with correct answers and detailed explanations. Use this guide to review concepts before taking the practice exam.
The Microsoft Business Central Developer (MB-820) certification validates professional expertise in Microsoft technologies. This study guide covers all 60 practice questions from our MB-820 practice test, complete with correct answers and explanations to help you understand each concept thoroughly.
Review each question and explanation below, then test yourself with the full interactive practice exam to measure your readiness.
When creating a new table extension in Business Central, which property is mandatory to establish the relationship with the base table?
The 'Extends' property is mandatory in a table extension object to specify which base table is being extended. This establishes the relationship between the extension and the original table.
You need to add a field to an existing page without modifying the original page object. What is the best approach?
Page extensions allow you to add fields, actions, and other controls to existing pages without modifying the original page object, which is the best practice in modern Business Central development.
In AL, what is the purpose of the 'var' keyword when declaring variables inside a procedure?
The 'var' keyword declares local variables with scope limited to the procedure in which they are declared. These variables exist only during the procedure's execution.
You are implementing a business rule where a sales order cannot be posted if the total amount exceeds a customer's credit limit. Where should this validation logic be placed for optimal performance?
The OnBeforePost trigger is the appropriate location for posting validations as it executes just before the record is posted, preventing invalid data from being committed to the database.
What is the main advantage of using query objects in Business Central instead of directly querying tables with code?
Query objects are optimized for data retrieval and provide built-in support for filtering, sorting, and aggregation, making them more efficient and maintainable than raw table queries in application code.
When implementing an event subscriber in AL, which trigger method is used to subscribe to a published event?
The [EventSubscriber] attribute is used to subscribe to published events. The procedure signature must match the event signature, including parameters and return types.
You need to display a confirmation dialog to the user asking whether they want to proceed with an action. Which method should you use?
The Confirm() function is specifically designed to display a yes/no confirmation dialog and returns a boolean value indicating the user's choice.
In a report object, what is the purpose of the 'RDLCLayout' property?
The RDLCLayout property contains the RDLC XML that defines how the report data is visually presented, including formatting, sections, and control placement.
What does the 'FlowField' property on a table field accomplish?
A FlowField is a calculated field that dynamically computes values like sums or counts based on FlowFilters. It doesn't store data but calculates it on-demand from related tables.
You are developing a codeunit that performs critical financial operations. Which access modifier should you use to ensure it can only be called from specific approved objects?
The 'Internal' access modifier restricts a codeunit's accessibility to objects within the same application package, providing control over which objects can invoke critical operations.
When using the FILTER function on a record variable in AL, what data type must the filter expression be?
The FILTER function accepts a Text parameter with Business Central's specific filter syntax (e.g., 'Status=Open'). The filter is applied to the record variable's current view.
What is the primary purpose of using a 'Codeunit' with the 'SingleInstance' property set to true?
Setting 'SingleInstance' to true creates a codeunit that maintains its state (global variables) throughout the user's session, useful for caching and performance optimization.
In AL development, which method is used to create a new record in a table without triggering validation triggers?
The INIT() method initializes a record with default values, and INSERT(false) inserts it without running validation triggers. This combination allows insertion without triggering standard validations.
You need to handle an error that occurs during record deletion and prevent the deletion from completing. Which trigger should you use?
The OnBeforeDelete trigger executes before the deletion occurs, allowing you to add conditions and use ERROR() to prevent the deletion if business rules are violated.
What is the correct syntax for declaring a procedure with multiple optional parameters in AL?
Optional parameters in AL are declared by providing a default value using the ':=' operator. Parameters without defaults are required, while those with defaults are optional.
When developing a page that displays customer information, you want to ensure specific actions are only visible to users with the appropriate permissions. How should you implement this?
The AccessByPermission property on page actions allows you to specify required permission sets, automatically hiding or disabling the action based on the user's permissions.
In Business Central, what is the primary difference between a 'List' page type and a 'Card' page type?
List pages use a repeater control to show multiple records in tabular format for browsing and selection, while Card pages display a single record with all its details for editing or viewing.
You are implementing a feature that requires executing a long-running process without blocking the user interface. Which approach should you use?
TaskScheduler.CreateTask() allows you to schedule a codeunit to run asynchronously in the background, preventing the UI from blocking while long-running operations complete.
What is the purpose of the 'UpdatePropagation' property on a table field?
UpdatePropagation controls whether changes to a field trigger recalculation of FlowFields in related tables, ensuring that calculated fields remain accurate when source data changes.
In a table extension, you want to add a new field that references another table. Which property must you use on the field to establish this relationship?
The TableRelation property establishes a relationship between a field and another table's key field, enabling validation and lookup functionality in the user interface.
You need to create a report that aggregates sales data by month and department. Which report element should you use for grouping and aggregation?
DataItems in reports support hierarchical grouping through the DataItemLink property and aggregate functions (SUM, COUNT, AVG) in column expressions for efficient data summarization.
When implementing a webhook integration in Business Central, which object type should you create to receive and process incoming HTTP requests?
API pages and queries allow you to expose Business Central data through REST APIs and handle incoming HTTP requests. They support standard HTTP methods like GET, POST, PATCH, and DELETE.
What is the correct way to iterate through a filtered recordset and perform operations on each record in AL?
The standard pattern in AL is to use a WHILE loop with the NEXT() method, which returns true if a record exists and false at the end, allowing iteration through filtered recordsets.
In the Business Central mobile app, which page type provides the optimal user experience for data entry on small screens?
Card pages provide the best mobile experience with their vertical, single-column layout and ability to group related fields, making them suitable for small screens and touch-based interaction.
You are developing a feature that must validate customer credit limits during sales order posting. This validation requires checking multiple conditions and should abort posting if conditions are not met. Which mechanism is most appropriate?
Implementing validation in OnBeforePost triggers with ERROR() function ensures that posting is aborted before any database changes occur, preventing invalid data from being committed.
When creating a new table extension in Business Central, which property is mandatory to establish the relationship between the extension and the base table?
The Source property must reference the base table that is being extended. This property is mandatory and establishes the inheritance relationship.
What is the primary purpose of using the OnModify trigger in a table?
The OnModify trigger fires before a record is updated in the database, occurring before validation checks. This allows for pre-modification logic.
Which AL data type is best suited for storing a reference to another record without creating a hard dependency?
RecordId stores a reference to a record that can be used later to retrieve the record dynamically, allowing flexible record references without direct table dependencies.
In Business Central development, what does the RunModal method do when applied to a page object?
RunModal opens a page in modal mode, meaning the user must close it before control returns to the calling code. This differs from Run, which opens non-modally.
When implementing a custom lookup in a page, which event should you subscribe to in order to modify the lookup behavior?
The OnLookup event is triggered when a user initiates a lookup action, allowing you to customize the lookup page or logic before the standard lookup executes.
What is the correct syntax to define a field group in a table to control which fields appear in a list view by default?
The 'listheader' fieldgroup designates which fields display in list views. Other fieldgroups like 'Brick' are used for card view layouts in the Web client.
In AL, which method would you use to retrieve all records from a table filtered by a specific field value without modifying the original filter?
The Copy method creates a copy of the current record variable with its filters intact, allowing independent operations without affecting the original variable's state.
What is the purpose of using the [ServiceEnabled] attribute on a procedure in a page or table in Business Central?
The [ServiceEnabled] attribute makes a procedure callable from external services like Power Automate, Power Apps, and the Business Central API.
When should you use the GetRec method instead of directly assigning one record variable to another?
GetRec is rarely used in modern AL, but direct assignment copies both the record data and filters. Using Copy method is preferred for independent filter management.
In a Business Central page, what is the difference between a Group and a GridGroup control?
GridGroup controls enable multi-column grid layouts for better space utilization, while regular Group controls arrange fields in a single vertical column.
Which AL statement would you use to conditionally execute code only if a record exists and pass control to an error scenario if not?
The if...then...else statement is the standard AL syntax for conditional execution. FindFirst returns a boolean indicating whether a record was found.
What is the primary advantage of using a table buffer instead of directly querying the database in a performance-critical scenario?
A temporary table buffer holds data in memory, reducing the number of database calls and improving performance in loops or complex operations.
When implementing a codeunit with procedure events, what does the [IntegrationEvent] attribute signify?
The [IntegrationEvent] attribute marks a procedure as a public event designed for external subscribers, indicating it is safe and stable for third-party extensions to hook into.
In Business Central, what is the purpose of the [TransactionModel] attribute on a codeunit?
The [TransactionModel] attribute controls whether a codeunit executes within a single transaction or manages its own transactions, affecting data consistency and rollback behavior.
What does the Validate method do when called on a field in AL code?
The Validate method triggers the OnValidate event for a field, executing any validation logic defined for that field as if the user had entered the value.
Which permission object type in Business Central is used to control access to specific tables and their operations?
Table Permissions control read (R), insert (I), modify (M), and delete (D) operations on tables. These are fundamental to data access control in Business Central.
In AL, when you use the 'var' keyword to declare a variable, what scope does it have?
Variables declared with 'var' are local to the procedure or trigger block in which they are declared and are destroyed when execution leaves that scope.
What is the primary function of the FlowFields feature in Business Central tables?
FlowFields compute values dynamically from related tables using formulas like Sum, Count, or Lookup, displaying results without consuming storage space.
When creating a report in Business Central, what is the primary purpose of the dataset section?
The dataset section defines the data source, including tables, filters, and columns that populate the report. The rendering section handles the visual layout.
What is the correct way to throw a custom error in AL that will be displayed to the user?
The Error function in AL displays a message to the user and halts execution. Message and Alert display information without stopping execution.
In the context of Business Central extensions, what is the purpose of an AppSource submission checklist?
The AppSource submission checklist verifies compliance with Microsoft's requirements for performance, security, data handling, and user experience before marketplace approval.
What is the difference between using Insert(true) and Insert(false) when creating a new record in AL?
The boolean parameter controls trigger execution: Insert(true) runs triggers, Insert(false) skips them for performance when triggers are unnecessary.
In Business Central, what does the [Scope] attribute control when applied to a global variable in a codeunit?
The [Scope] attribute determines if a global variable is available to external callers (Public) or only within the same object (Internal), affecting API exposure.
When implementing a page action that should only appear in the Web client but not on mobile devices, what property or attribute would you use?
The [Platform] attribute filters UI elements to display only on specified clients. Using [Platform(Web)] restricts an action to the Web client only.
What is the primary role of the app.json file in a Business Central development project?
The app.json file contains critical metadata including the app name, publisher, version, dependencies on other extensions, and runtime requirements like minimum AL language version.
You are developing a page extension for the Customer list page in Business Central. You need to add a new action that calls a codeunit procedure. Which page element should you use to define this action?
Actions are defined within action groups in the actions section of a page. These actions can trigger procedures from codeunits or perform other operations when clicked by the user.
When implementing table triggers in Business Central, you want to prevent deletion of records that have related entries in another table. Which trigger should you use to implement this validation?
The OnDelete trigger fires when a record is being deleted. You can use it to perform validation logic and call Error() to prevent deletion if conditions are not met.
You need to create a query object that returns summarized sales data grouped by customer and filtered by date range. Which query element property allows you to aggregate data across multiple rows?
The GroupTotalType property in query columns enables aggregation of data (such as Sum, Count, Average) across groups, making it essential for summarized reporting.
You are creating a codeunit that processes batch transactions. You need to ensure that if any error occurs during processing, all changes are rolled back. Which statement should you use?
In AL, transaction control is handled implicitly, but you should use try-catch blocks to handle errors and explicitly call ROLLBACK() in the catch block to undo changes when errors occur.
When developing a report that displays customer transactions, you need to filter records based on a user-selected date range. How should you define this requirement?
Report parameters allow users to provide filter criteria at runtime. The report dataset should be filtered based on these parameters in the OnPreDataItem trigger or dataset definition.
You are implementing a permission set for a new role. The role requires access to specific tables but not others. Which security object should you use to grant table-level permissions?
Permission Sets define what objects users can access and what operations they can perform. They contain individual permission entries that specify Read, Insert, Modify, and Delete access to specific tables and other objects.
In a page extension, you want to modify the behavior of an existing action without replacing it entirely. Which approach should you use?
The modify keyword in page extensions allows you to change properties and triggers of existing page elements without completely replacing them, maintaining backwards compatibility.
You need to implement a web service that allows external systems to create and update sales orders in Business Central. Which approach is most appropriate?
API pages are the modern, recommended approach for exposing Business Central data to external systems. They automatically handle REST operations (GET, POST, PATCH, DELETE) and provide OData compliance.
When debugging AL code in Visual Studio Code, you want to inspect the value of a variable at a specific point in execution. Which debugging feature should you use?
The Watch window in the AL debugger allows you to monitor variable values during execution, and conditional breakpoints let you pause execution when specific conditions are met.
You are designing a table structure where a field value must be unique across all records. How should you enforce this uniqueness constraint?
Keys in Business Central tables can be marked as unique with the Unique property. This database-level constraint ensures that no duplicate values can exist for that key combination.
You've reviewed all 60 questions. Take the interactive practice exam to simulate the real test environment.
▶ Start Practice Exam — Free