Certification Test, D365FO

Exam MB-500: Microsoft Dynamics 365: Finance and Operations Apps Developer

Updated 2021-04-02: This preparation guide includes information and tools to assist you in preparation for Exam MB-500: Microsoft Dynamics 365: Finance and Operations Apps Developer

Why get certified in Microsoft Dynamics 365 For Finance and Operations?

Instructor-led training for MB-500

Physical classroom course: MB-500 Apps Developer

Live Online Course: MB-500 Apps Developer

Training manuals for MB-500

SkillPipe MB-500T00 (Microsoft Official Courseware)
Additional AXcademy materials

Who should take this exam?

Candidates for this exam are developers who work with Finance and Operations apps in Microsoft Dynamics 365 to implement and extend applications that meet the requirements of a business. Candidates provide fully realized solutions by using standardized application coding patterns, extensible features, and external integrations.

Candidates develop business logic by using X++, create and modify Finance and Operations reports and workspaces, customize user interfaces, provide endpoints and APIs to support Power Platform apps and external systems, perform testing, monitor performance, analyze and manipulate data, create technical designs and implementation details, and implement permission policies and security requirements.

Candidates should have a deep knowledge and experience using the underlying framework, data structures, and objects associated with the Finance and Operations solutions.

Candidates should have experience with products that include Visual Studio, Azure DevOps, Lifecycle Services (LCS) tools, and SQL Server Management Studio.

Certification

This exam is part of

Microsoft Certified: Dynamics 365: Finance and Operations Apps Developer Associate. Required exams: Exam MB-500 (this one) and Exam MB-300

Skills measured (as of 2021-04-02)

NOTE: The bullets that appear below each of the skills measured are intended to illustrate how Microsoft is assessing that skill. This list is NOT definitive or exhaustive.

NOTE: Most questions cover features that are General Availability (GA). The exam may contain questions on Preview features if those features are commonly used.

Plan architecture and solution design (10-15%)

Identify the major components of Dynamics 365 Finance and Operations apps

identify the Finance and Operations app modules required for a solution based on business requirements
identify architectural differences between the cloud and on-premises versions of Finance and Operations apps
identify components of the application stack
differentiate the purposes and interrelationships between packages, projects, models, and elements

Design and implement a user interface

describe the Finance and Operations user interface layouts and components
design the workspaces
design and personalize user interface elements including grids, forms, and pages
configure filtering options

Implement Application Lifecycle Management (ALM) and Lifecycle Services (LCS)

describe the capabilities of the Environment Monitoring Tool within Lifecycle Services (LCS)
select the purpose and appropriate uses of LCS tools and components
research and resolve issues by using Issue Search
identify activities that require asset libraries
prepare deployment packages and deploy packages

Apply Developer Tools (10-15%)

Customize Finance and Operations apps by using Visual Studio

create extension models
design and build projects
manage metadata using Application Explorer
synchronize data dictionary changes with the application database
create elements by using the Element Designer

Manage source code and artifacts by using version control

create, check out, and check in code and artifacts
branch and merge code
compare code and resolve version conflicts

Implement Finance and Operations app framework functionality

implement the SysOperation framework
implement the asynchronous framework
implement the workflow framework
implement the unit test framework
identify the need for and implement the Sandbox framework

Design and develop AOT Elements (20-25%)

Create forms

add a new form to a project and apply a pattern (template)
configure a data source for the form
add a grid and grid fields, groups, and other controls to a form
create and populate menu items
test form functionality and data connections
add a form extension to a project for selected standard forms

Create and extend tables

add tables to a project
add table fields and field properties to a table
add a table extension to a project for a table
add fields groups, relations, delete actions, and indices

Create Extended Data Types (EDT) and enumerations

add an EDT to a project and populate EDT properties
add an enumeration to a project
add or update enumeration elements and enumeration element properties
add an extension of EDT and enumerations

Create classes and extend AOT elements

add a new class to a project
create a new class extension and add new methods
add event handler methods to a class

Develop and test code (10-15%)

Develop X++ code

identify and implement base types and operators
implement common structured programming constructs of X++
create, read, update, and delete (CRUD) data
identify and implement global functions in X++
implement table and form methods

Develop object-oriented code

implement X++ variable scoping
implement inheritance and abstraction concept
implement query objects and the QueryBuilder class
implement attribute classes implement chain of command

Implement reporting (10-15%)

Describe the capabilities and limitations of reporting tools in Dynamics 365 Finance and Operations apps

create and modify report data sources and supporting classes
implement reporting security requirements
describe the report publishing process
describe the differences between using Entity store and Bring your own database (BYOD) as reporting data stores

Design, create, and revise Dynamics reports

create and modify reports in Finance and Operations apps that use SQL Server Reporting Services (SSRS)
create and modify Finance and Operations apps reports by using Power BI
create and modify Finance and Operations apps reports FO by using Microsoft Excel

Design, create, and revise Dynamics workspaces

design KPIs
create drill-through workspace elements
implement built-in charts, KPIs, aggregate measurement, aggregate dimension, and other reporting components

Integrate and manage data solutions (10-15%)

Identify data integration scenarios

select an appropriate data integration API
identify differences between synchronous vs. asynchronous patterns

Implement data integration concepts and solutions

develop a data entity by using Visual Studio
develop, import, and export composite data entities
identify and manage unmapped fields in data entities
consume external web services by using OData and RESTful APIs
integrate Finance and Operations apps with Microsoft Excel by using OData
develop and integrate Power Automate and Power Apps

Implement data management

import and export data using entities between Finance and Operations apps and other systems
monitor the status and availability of entities
enable Entity Change Tracking
set up a data project and recurring data jobs
design entity sequencing
generate field mapping between source and target data structures
develop data transformations

Implement security and optimize performance (10-15%)

Implement role-based security policies and requirements

create or modify duties, privileges, permissions, and roles
enforce permissions policies
implement record-level security by using Extensible Data Security (XDS)

Apply fundamental performance optimization techniques

identify and apply caching mechanisms for forms and tables
implement the global cache
create or modify temporary tables for optimization purposes
determine when to use set-based queries and row-based queries
modify queries to optimize performance
modify variable scope to optimize performance
analyze and optimize concurrency

Optimize user interface performance

capture traces by using TraceParser and analyze traces
diagnose and optimize client performance by using Microsoft Edge F12 Developer tools, Fiddler, and other common tools
diagnose and optimize client performance by using Performance Timer

Preparation options for Exam MB-500

Instructor-led training for MB-500

Live Online Class: MB-500 Apps Developer Exam preparation course

Exam MB-500: Microsoft Dynamics 365: Finance and Operations Apps Developer

Training manuals for MB-500

MB-500
AXcademy

Self-paced training

Coming soon

Schedule exam

Schedule the exam at Microsoft

More information about D365FO exams

View the complete list of Microsoft Dynamics 365 FO Certification Exams

Skills measured – older versions

Skills measured (From 2020-05-22 to 2021-04-01)

NOTE: The bullets that appear below each of the skills measured are intended to illustrate how Microsoft is assessing that skill. This list is not definitive or exhaustive.

NOTE: In most cases, exams do NOT cover preview features, and some features will only be added to an exam when they are GA (General Availability).

Overview:

Plan Architecture and Solution Design (10-15%)
Apply Developer Tools (10-15%)
Design and Develop AOT Elements (20-25%)
Develop and Test Code (10-15%)
Implement Reporting (10-15%)
Integrate and Manage Data Solutions (10-15%)
Implement Security and Optimize Performance (10-15%)

Details:

Plan Architecture and Solution Design (10-15%)

Identify the major components of Dynamics 365 Finance and Operation

select application components and architecture based on business components
identify architectural differences between the cloud and on-premises versions of Dynamics FO
prepare and deploy the deployment package
identify components of the application stack and map them to the standard models
differentiate the purpose and interrelationships between packages, projects, models, and elements

Design and implement a user interface

describe the Dynamics 365 FO user interface layout and components
design the workspace and define navigation
select page options
identify filtering options

Implement Application Lifecycle Management (ALM)

create extension models
configure the DevOps source control process
describe the capabilities of the Environment Monitoring Tool within Lifecycle Services (LCS)
select the purpose and appropriate uses of LCS tools and components
research and resolve issues using Issue Search
identify activities that require asset libraries

Apply Developer Tools (10-15%)

Customize Dynamics 365 FO by using Visual Studio

design and build projects
manage metadata using Application Explorer
synchronize data dictionary changes with the application database
create elements by using the Element Designer

Manage source code and artifacts by using version control

create, check out, and check in code and artifacts
compare code and resolve version conflicts

Implement D365 FO framework functionality

implement the SysOperation framework
implement asynchronous framework
implement workflow framework
implement the unit test framework
identify the need for and implement the Sandbox framework

Design and Develop AOT Elements (20-25%)

Create forms

add a new form to a project and apply a pattern (template)
configure a data source for the form
add a grid and grid fields and groups
create and populate menu items
test form functionality and data connections
add a form extension to a project for selected standard forms

Create and extend tables

add tables and table fields to a project
populate table and field properties
add a table extension to a project for a table
add fields, field groups, relations, and indices

Create Extended Data Types (EDT) and enumerations

add an EDT to a project and populate EDT properties
add an enumeration to a project
add or update enumeration elements
add or update enumeration element properties
add an extension of EDT and enumerations

Create classes and extend AOT elements

add a new class to a project
create a new class extension and add new methods
add event handler methods to a class

Develop and Test Code (10-15%)

Develop X++ code

identify and implement base types and operators
implement common structured programming constructs of X++
create, read, update, and delete (CRUD) data using embedded SQL code
identify and implement global functions in X++
ensure correct usage of Display Fields
implement table and form methods

Develop object-oriented code

implement X++ variable scoping
implement inheritance and abstraction concept
implement query objects and QueryBuilder
implement attribute classes
implement chain of command

Implement Reporting (10-15%)

Describe the capabilities and limitations of reporting tools in Dynamics 365 FO

create and modify report data sources and supporting classes
implement reporting security requirements
describe the report publishing process
describe the capabilities of the Electronic reporting (ER) tool

Describe the differences between using Entity store and Bring your own database (BYOD) as
reporting data stores

Design, create, and revise Dynamics Reports

create and modify reports in Dynamics 365 FO that use SQL Server Reporting Services (SSRS)
create and modify reports in Dynamics 365 FO by using Power BI
create and modify reports in Dynamics 365 FO by using Microsoft Excel

Design, create, and revise Dynamics workspace

design KPIs
create drill-through workspace elements
implement built-in charts, KPIs, aggregate measurement, aggregate dimension, and other reporting components

Integrate and Manage Data Solutions (10-15%)

Identify data integration scenarios

select appropriate data integration capabilities
identify differences between synchronous vs. asynchronous scenarios

Implement data integration concepts and solutions

develop a data entity in Visual Studio
develop, import, and export composite data entities
identify and manage unmapped fields in data entities
consume external web services by using OData and RESTful APIs
integrate Dynamics 365 FO with Excel using OData
develop and integrate Microsoft Flow and Power Apps

Implement data management

import and export data using entities between D365 FO and other systems
monitor the status and availability of entities
enable Entity Change Tracking
set up a data project and recurring data job
design entity sequencing
generate field mapping between source and target data structures
develop data transformations

Implement Security and Optimize Performance (10-15%)

Implement role-based security policies and requirements

create or modify duties, privileges, and permissions
enforce permissions policy
implement record-level security by using Extensible Data Security (XDS)

Apply fundamental performance optimization techniques

identify and apply caching mechanisms
create or modify temp tables for optimization
determine when to use set-based queries and row-based queries
modify queries for optimization
modify variable scope to optimize performance
analyze and optimize concurrency

Optimize user interface performance

diagnose and optimize client performance by using browser-based tools
diagnose and optimize client performance by using Performance Timer

Skills measured – valid until 2020-05-22

This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam. Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text.

Overview:

Plan Architecture and Solution Design (10-15%)
Apply Developer Tools (10-15%)
Design and Develop AOT Elements (20-25%)
Develop and Test Code (10-15%)
Implement Reporting (10-15%)
Integrate and Manage Data Solutions (10-15%)
Implement Security and Optimize Performance (10-15%)

Details:

Plan Architecture and Solution Design (10-15%)

Identify the major components of Dynamics 365 Finance and Operation

select application components and architecture based on business components
identify architectural differences between the cloud and on-premises versions of Dynamics FO
prepare and deploy the deployment package
identify components of the application stack and map them to the standard models
differentiate the purpose and interrelationships between packages, projects, models, and elements

Design and implement a user interface

describe the Dynamics 365 FO user interface layout and components
design the workspace and define navigation
select page options
identify filtering options

Implement Application Lifecycle Management (ALM)

create overlayered and extension models
configure the DevOps source control process
describe the capabilities of the Environment Monitoring Tool within Lifecycle Services (LCS)
select the purpose and appropriate uses of LCS tools and components
research and resolve issues using Issue Search
identify activities that require asset libraries

Apply Developer Tools (10-15%)

Customize Dynamics 365 FO by using Visual Studio

design and build projects
manage metadata using Application Explorer
synchronize data dictionary changes with the application database
create elements by using the Element Designer

Manage source code and artifacts by using version control

create, check out, and check in code and artifacts
compare code and resolve version conflicts

Implement D365 FO framework functionality

implement the SysOperation framework
implement asynchronous framework
implement workflow framework
implement the unit test framework
identify the need for and implement the Sandbox framework

Design and Develop AOT Elements (20-25%)

Create forms

add a new form to a project and apply a pattern (template)
configure a data source for the form
add a grid and grid fields and groups
create and populate menu items
test form functionality and data connections
add a form extension to a project for selected standard forms

Create and extend tables

add tables and table fields to a project
populate table and field properties
add a table extension to a project for a table
add fields, field groups, relations, and indices

Create Extended Data Types (EDT) and enumerations

add an EDT to a project and populate EDT properties
add an enumeration to a project
add or update enumeration elements
add or update enumeration element properties
add an extension of EDT and enumerations

Create classes and extend AOT elements

add a new class to a project
create a new class extension and add new methods
add event handler methods to a class

Develop and Test Code (10-15%)

Develop X++ code

identify and implement base types and operators
implement common structured programming constructs of X++
create, read, update, and delete (CRUD) data using embedded SQL code
identify and implement global functions in X++
ensure correct usage of Display Fields
implement table and form methods

Develop object-oriented code

implement X++ variable scoping
implement inheritance and abstraction concept
implement query objects and QueryBuilder
implement attribute classes
implement chain of command

Implement Reporting (10-15%)

Describe the capabilities and limitations of reporting tools in Dynamics 365 FO

create and modify report data sources and supporting classes
implement reporting security requirements
describe the report publishing process

Design, create, and revise Dynamics Reports

create and modify reports in Dynamics 365 FO that use SQL Server Reporting Services (SSRS)
create and modify reports in Dynamics 365 FO by using Power BI
create and modify reports in Dynamics 365 FO by using Microsoft Excel

Design, create, and revise Dynamics workspace

design KPIs
create drill-through workspace elements
implement built-in charts, KPIs, aggregate measurement, aggregate dimension, and other reporting components

Integrate and Manage Data Solutions (10-15%)

Identify data integration scenarios

select appropriate data integration capabilities
identify differences between synchronous vs. asynchronous scenarios

Implement data integration concepts and solutions

develop a data entity in Visual Studio
develop, import, and export composite data entities
identify and manage unmapped fields in data entities
consume external web services by using OData and RESTful APIs
integrate Dynamics 365 FO with Excel using OData
develop and integrate Microsoft Flow and Power Apps

Implement data management

import and export data using entities between D365 FO and other systems
monitor the status and availability of entities
enable Entity Change Tracking
set up a data project and recurring data job
design entity sequencing
generate field mapping between source and target data structures
develop data transformations

Implement Security and Optimize Performance (10-15%)

Implement role-based security policies and requirements

create or modify duties, privileges, and permissions
enforce permissions policy
implement record-level security by using Extensible Data Security (XDS)

Apply fundamental performance optimization techniques

identify and apply caching mechanisms
create or modify temp tables for optimization
determine when to use set-based queries and row-based queries
modify queries for optimization
modify variable scope to optimize performance
analyze and optimize concurrency

Optimize user interface performance

diagnose and optimize client performance by using browser-based tools
diagnose and optimize client performance by using Performance Timer

FAQ Section – exam MB-500

[sc_fs_multi_faq headline-0=”h1″ question-0=”Who should take this exam?” answer-0=”Developers who work with Finance and Operations apps in Microsoft Dynamics 365 to implement and extend applications to meet the requirements of the business” headline-1=”h2″ question-1=”What are my options for preparing for the exams?” answer-1=”You could do self-study on-demand, participate in open classes, attend webinars, or a mix (blended learning)” headline-2=”h3″ question-2=”Do you offer mock exams?” answer-2=”As part of our training, we offer quizzes, test your knowledge questions, and hands-on labs/practices” headline-3=”h3″ question-3=”Do I have to pass MB-300 Core, before I can sit this exam?” answer-3=”No, the sequence doesn't matter. But you have to pass MB-300 Core, as well as this specific exam MB-500 to obtain the ‘Microsoft Certified: Dynamics 365: Finance and Operations Apps Developer Associate' certification” count=”4″ html=”true”]