Mendix Advanced Developer Certification - Mendix Academy -
Academic Year 2026/2027 - Comprehensive Certification
Examination with 50 Verified Questions and Correct Answer
Rationales
About This Exam Bank
This comprehensive 147-question exam bank is designed to prepare candidates for Mendix Advanced Developer
Certification - Mendix Academy - Academic Year 2026/2027 - Comprehensive Certification Examination with 50
Verified Questions and Correct Answer Rationales. Every question is aligned with the latest official content outline
and includes a detailed, evidence-based rationale, an explanation of why each remaining option is incorrect, and a
supporting reference.
Keywords
Mendix Advanced Developer Certification - Mendix Academy - Academic Year 2026/2027 - Comprehensive
Certification Examination with 50 Verified Questions and Correct Answer Rationales, exam bank, practice
questions, verified answers, detailed rationales, test prep, study guide, review questions, certification exam, latest
update, Mendix Advanced Developer Certification - Mendix Academy - Academic Year 2026/2027 - Comprehensive
Certification Examination with 50 Verified Questions and Correct Answer Rationales, exam bank, practice
questions, verified answers, detailed rationales
PART 1: DESIGN AND IMPLEMENT COMPLEX DOMAIN MODELS WITH INHERITANCE,
ASSOCIATIONS, AND VALIDATION RULES
1. In a Mendix domain model, an entity 'Order' has a 1-* association to 'OrderLine'. To ensure that deleting an Order
automatically deletes all its OrderLines, which delete behavior should be configured on the association?
A) Delete 'Order' and 'OrderLine'
B) Delete 'Order' and 'OrderLine' with cascade
C) Delete 'Order' and 'OrderLine' with cascade and prevent delete of 'Order' if 'OrderLine' exists
D) Delete 'Order' and 'OrderLine' with cascade and prevent delete of 'OrderLine' if 'Order' exists
' Correct Answer: B
Rationale: The cascade option ensures that when the parent (Order) is deleted, all associated child (OrderLine)
objects are also deleted. Option A would delete only the Order and leave orphaned OrderLines. Options C and D add
unnecessary constraints that would prevent deletion or cause errors.
2. A microflow contains a loop that retrieves a large set of objects and performs a commit for each object. What is
the most effective optimization to reduce database round-trips?
A) Replace the loop with a single commit activity outside the loop.
B) Use a 'Commit' activity with the 'with events' option disabled.
C) Add a 'Change object' activity before the commit.
D) Use a 'Retrieve' activity with the 'Range' option to limit the number of objects.
' Correct Answer: A
Rationale: Committing each object individually causes multiple database round-trips. Moving the commit outside
the loop and committing the entire list in one operation significantly reduces database load. Option B disables events
but still commits per object. Options C and D do not address the round-trip issue.
Page 1
,3. Which module role configuration correctly enforces that only users with the 'Manager' role can view and edit
'Employee' records, while 'Staff' can only view them?
A) Entity access: Manager has read/write, Staff has read only.
B) Entity access: Manager has read/write, Staff has read/write but with a constraint.
C) Microflow access: Manager can call the microflow, Staff cannot.
D) Page access: Manager can view the page, Staff cannot.
' Correct Answer: A
Rationale: Entity access rules directly control CRUD operations on data. Setting Manager to read/write and Staff to
read-only enforces the requirement. Option B would allow Staff to edit if constraints are not properly set. Options C
and D control access to logic and UI, not data-level permissions.
4. When integrating a Mendix app with an external REST API that returns a large JSON payload, which approach
best minimizes memory usage and improves performance?
A) Use a Java action to parse the JSON and store it in a non-persistent entity.
B) Use the 'Call REST' activity with the 'Store response in a variable' option and then parse with a microflow.
C) Use the 'Call REST' activity with the 'Store response in a file' option and then import the file.
D) Use the 'Call REST' activity with the 'Store response in a string' option and then use a JSON structure.
' Correct Answer: C
Rationale: Storing the response in a file avoids loading the entire payload into memory, which is critical for large
responses. Parsing from a file can be done incrementally. Options A, B, and D load the full response into memory,
potentially causing out-of-memory errors.
5. In a Mendix app, a nanoflow is used to perform client-side validation before committing an object. Which
statement about nanoflows is true?
A) Nanoflows can directly commit objects to the database.
B) Nanoflows run on the server and can access all microflow activities.
C) Nanoflows run on the client and can only access data already available in the client context.
D) Nanoflows can call microflows but cannot be called from microflows.
' Correct Answer: C
Rationale: Nanoflows execute on the client side and are limited to data already retrieved to the client; they cannot
directly commit to the database. Option A is false because commits require a microflow. Option B is false as
nanoflows are client-side. Option D is false because microflows can call nanoflows in certain contexts.
6. A Mendix application experiences slow performance due to frequent database queries on an entity with a large
dataset. Which indexing strategy is most appropriate?
A) Create an index on the entity's primary key.
B) Create an index on attributes frequently used in XPath constraints.
C) Create an index on all attributes to cover all queries.
D) Avoid indexes as they slow down insert operations.
' Correct Answer: B
Rationale: Indexes should be created on attributes that are frequently used in search conditions (XPath) to speed up
retrieval. Option A is unnecessary as primary keys are already indexed. Option C is excessive and can degrade write
performance. Option D is incorrect because proper indexing improves read performance significantly.
7. Which statement accurately describes the purpose of a 'Microflow' in Mendix?
A) It defines the user interface layout.
B) It encapsulates business logic and can be executed on the server.
C) It is used only for client-side validations.
Page 2
, D) It manages database schema changes.
' Correct Answer: B
Rationale: Microflows are server-side business logic units that can perform complex operations, including database
interactions. Option A describes pages. Option C describes nanoflows. Option D describes domain model
synchronization.
8. When configuring a Mendix app for deployment to a cloud environment, which file is essential for defining
environment-specific settings?
A) settings.json
B) config.json
C) mendix.env
D) deployment.yaml
' Correct Answer: B
Rationale: The config.json file (or environment-specific configurations) defines settings such as database
connections and external service URLs. Option A is not standard. Option C is not used. Option D is used in
container orchestration but not specific to Mendix configuration.
9. In a Mendix app, a user reports that a page loads slowly due to a large data grid. Which optimization technique is
most effective?
A) Enable pagination on the data grid.
B) Increase the page size to show all records.
C) Disable caching for the data grid.
D) Use a microflow to retrieve all records at once.
' Correct Answer: A
Rationale: Pagination limits the number of records loaded at once, improving page load time. Option B would
worsen performance. Option C would increase server load. Option D would retrieve all records, causing delays.
10. Which Mendix feature allows you to define custom logic that can be reused across multiple microflows?
A) Sub-microflow
B) Nanoflow
C) Java action
D) Microflow call
' Correct Answer: A
Rationale: Sub-microflows are reusable microflows that can be called from other microflows, promoting
modularity. Option B is client-side and not reusable in the same way. Option C is custom Java code, not a Mendix
native reusable logic unit. Option D is the act of calling a microflow, not the reusable component itself.
11. In a Mendix microflow, a Retrieve activity on entity Order uses an XPath constraint with a parameterized token.
Which statement best characterizes how Mendix 10+ handles this parameter and the resulting data set under a
production PostgreSQL database?
A) The parameter is bound at design time; changing its value at runtime requires a model redeploy.
B) The parameter is bound at runtime per execution, and the XPath is compiled into a parameterized SQL query
executed by the database.
C) The parameter is ignored unless the Retrieve is marked 'Apply constraint in database'.
D) The parameter is substituted textually into the XPath and re-parsed on the client, causing N+1 queries.
' Correct Answer: B
Rationale: Mendix binds XPath parameters at runtime for each microflow execution and translates the XPath into a
parameterized SQL statement executed by the database, avoiding SQL injection and enabling plan caching.
Page 3
, Design-time binding (A) is false, parameters are never silently ignored (C), and XPath is not client-side textually
substituted (D).
12. A developer needs to expose a REST endpoint that returns only the fields a mobile client is authorized to see,
while reusing the same domain model used by a full-page web UI. Which combination is the most appropriate?
A) A published REST service with a custom microflow that builds a non-persistent export entity and entity access
rules restricting the persistent entity.
B) A published REST service mapped directly to the persistent entity with default entity access, relying on the
client to filter fields.
C) A published OData service with 'Apply entity access' disabled to maximize performance.
D) A consumed REST service pointing back to the same app's REST endpoint to enforce field-level security.
' Correct Answer: A
Rationale: The secure pattern is a published REST service backed by a microflow that maps to a non-persistent
export entity, so only authorized fields leave the app, while entity access rules continue to protect the persistent
entity. Direct mapping (B) leaks fields, disabling entity access (C) removes the security boundary, and a consumed
service (D) does not enforce outbound field-level security.
13. Which statement correctly distinguishes a Mendix 'scheduled event' from a 'task queue' when designing resilient
background processing in a clustered runtime?
A) Scheduled events run on every cluster node simultaneously; task queues run on one node only.
B) Scheduled events are executed by a single elected node per scheduled time; task queues distribute individual
tasks across nodes with configurable concurrency and cluster-wide coordination.
C) Both are executed exclusively on the first node in the cluster and cannot be distributed.
D) Task queues require an external message broker; scheduled events are purely in-memory and lost on restart.
' Correct Answer: B
Rationale: Mendix scheduled events are coordinated so a single node executes each scheduled occurrence, whereas
task queues distribute tasks across the cluster with configurable concurrency and cluster-wide coordination. (A)
inverts the behavior, (C) is false for task queues, and (D) misstates both mechanisms.
14. A microflow iterates a list of 10,000 Orders and, inside the loop, performs a Retrieve on Customer for each
Order. Which refactoring most directly eliminates the N+1 query pattern while preserving behavior?
A) Add a 'Commit' activity inside the loop to flush pending changes.
B) Replace the loop with a single Retrieve over Customer using an XPath 'id = $Order_Customer' association path
and then associate in a second loop.
C) Retrieve the associated Customers in one Retrieve over the association from the Orders list, then iterate the
Orders and look up the Customer in memory.
D) Enable 'Optimize retrieve' on the Retrieve activity inside the loop.
' Correct Answer: C
Rationale: Retrieving all associated Customers in a single query and then resolving them in memory from the
retrieved list avoids one query per Order. Committing inside the loop (A) worsens performance, retrieving by id per
Order (B) still issues many queries, and there is no 'Optimize retrieve' toggle (D).
15. In a Mendix native mobile app, a developer must guarantee that data entered offline is eventually synchronized
exactly once to the server, even if the device retries after a network failure. Which design best achieves this?
A) Rely on the default offline synchronization, which guarantees exactly-once delivery.
B) Assign a client-generated idempotency key to each record and have the server-side synchronization microflow
upsert by that key.
C) Use a scheduled event on the device to post records directly to a REST endpoint without keys.
D) Disable offline synchronization and require the user to retry manually until success.
Page 4
Academic Year 2026/2027 - Comprehensive Certification
Examination with 50 Verified Questions and Correct Answer
Rationales
About This Exam Bank
This comprehensive 147-question exam bank is designed to prepare candidates for Mendix Advanced Developer
Certification - Mendix Academy - Academic Year 2026/2027 - Comprehensive Certification Examination with 50
Verified Questions and Correct Answer Rationales. Every question is aligned with the latest official content outline
and includes a detailed, evidence-based rationale, an explanation of why each remaining option is incorrect, and a
supporting reference.
Keywords
Mendix Advanced Developer Certification - Mendix Academy - Academic Year 2026/2027 - Comprehensive
Certification Examination with 50 Verified Questions and Correct Answer Rationales, exam bank, practice
questions, verified answers, detailed rationales, test prep, study guide, review questions, certification exam, latest
update, Mendix Advanced Developer Certification - Mendix Academy - Academic Year 2026/2027 - Comprehensive
Certification Examination with 50 Verified Questions and Correct Answer Rationales, exam bank, practice
questions, verified answers, detailed rationales
PART 1: DESIGN AND IMPLEMENT COMPLEX DOMAIN MODELS WITH INHERITANCE,
ASSOCIATIONS, AND VALIDATION RULES
1. In a Mendix domain model, an entity 'Order' has a 1-* association to 'OrderLine'. To ensure that deleting an Order
automatically deletes all its OrderLines, which delete behavior should be configured on the association?
A) Delete 'Order' and 'OrderLine'
B) Delete 'Order' and 'OrderLine' with cascade
C) Delete 'Order' and 'OrderLine' with cascade and prevent delete of 'Order' if 'OrderLine' exists
D) Delete 'Order' and 'OrderLine' with cascade and prevent delete of 'OrderLine' if 'Order' exists
' Correct Answer: B
Rationale: The cascade option ensures that when the parent (Order) is deleted, all associated child (OrderLine)
objects are also deleted. Option A would delete only the Order and leave orphaned OrderLines. Options C and D add
unnecessary constraints that would prevent deletion or cause errors.
2. A microflow contains a loop that retrieves a large set of objects and performs a commit for each object. What is
the most effective optimization to reduce database round-trips?
A) Replace the loop with a single commit activity outside the loop.
B) Use a 'Commit' activity with the 'with events' option disabled.
C) Add a 'Change object' activity before the commit.
D) Use a 'Retrieve' activity with the 'Range' option to limit the number of objects.
' Correct Answer: A
Rationale: Committing each object individually causes multiple database round-trips. Moving the commit outside
the loop and committing the entire list in one operation significantly reduces database load. Option B disables events
but still commits per object. Options C and D do not address the round-trip issue.
Page 1
,3. Which module role configuration correctly enforces that only users with the 'Manager' role can view and edit
'Employee' records, while 'Staff' can only view them?
A) Entity access: Manager has read/write, Staff has read only.
B) Entity access: Manager has read/write, Staff has read/write but with a constraint.
C) Microflow access: Manager can call the microflow, Staff cannot.
D) Page access: Manager can view the page, Staff cannot.
' Correct Answer: A
Rationale: Entity access rules directly control CRUD operations on data. Setting Manager to read/write and Staff to
read-only enforces the requirement. Option B would allow Staff to edit if constraints are not properly set. Options C
and D control access to logic and UI, not data-level permissions.
4. When integrating a Mendix app with an external REST API that returns a large JSON payload, which approach
best minimizes memory usage and improves performance?
A) Use a Java action to parse the JSON and store it in a non-persistent entity.
B) Use the 'Call REST' activity with the 'Store response in a variable' option and then parse with a microflow.
C) Use the 'Call REST' activity with the 'Store response in a file' option and then import the file.
D) Use the 'Call REST' activity with the 'Store response in a string' option and then use a JSON structure.
' Correct Answer: C
Rationale: Storing the response in a file avoids loading the entire payload into memory, which is critical for large
responses. Parsing from a file can be done incrementally. Options A, B, and D load the full response into memory,
potentially causing out-of-memory errors.
5. In a Mendix app, a nanoflow is used to perform client-side validation before committing an object. Which
statement about nanoflows is true?
A) Nanoflows can directly commit objects to the database.
B) Nanoflows run on the server and can access all microflow activities.
C) Nanoflows run on the client and can only access data already available in the client context.
D) Nanoflows can call microflows but cannot be called from microflows.
' Correct Answer: C
Rationale: Nanoflows execute on the client side and are limited to data already retrieved to the client; they cannot
directly commit to the database. Option A is false because commits require a microflow. Option B is false as
nanoflows are client-side. Option D is false because microflows can call nanoflows in certain contexts.
6. A Mendix application experiences slow performance due to frequent database queries on an entity with a large
dataset. Which indexing strategy is most appropriate?
A) Create an index on the entity's primary key.
B) Create an index on attributes frequently used in XPath constraints.
C) Create an index on all attributes to cover all queries.
D) Avoid indexes as they slow down insert operations.
' Correct Answer: B
Rationale: Indexes should be created on attributes that are frequently used in search conditions (XPath) to speed up
retrieval. Option A is unnecessary as primary keys are already indexed. Option C is excessive and can degrade write
performance. Option D is incorrect because proper indexing improves read performance significantly.
7. Which statement accurately describes the purpose of a 'Microflow' in Mendix?
A) It defines the user interface layout.
B) It encapsulates business logic and can be executed on the server.
C) It is used only for client-side validations.
Page 2
, D) It manages database schema changes.
' Correct Answer: B
Rationale: Microflows are server-side business logic units that can perform complex operations, including database
interactions. Option A describes pages. Option C describes nanoflows. Option D describes domain model
synchronization.
8. When configuring a Mendix app for deployment to a cloud environment, which file is essential for defining
environment-specific settings?
A) settings.json
B) config.json
C) mendix.env
D) deployment.yaml
' Correct Answer: B
Rationale: The config.json file (or environment-specific configurations) defines settings such as database
connections and external service URLs. Option A is not standard. Option C is not used. Option D is used in
container orchestration but not specific to Mendix configuration.
9. In a Mendix app, a user reports that a page loads slowly due to a large data grid. Which optimization technique is
most effective?
A) Enable pagination on the data grid.
B) Increase the page size to show all records.
C) Disable caching for the data grid.
D) Use a microflow to retrieve all records at once.
' Correct Answer: A
Rationale: Pagination limits the number of records loaded at once, improving page load time. Option B would
worsen performance. Option C would increase server load. Option D would retrieve all records, causing delays.
10. Which Mendix feature allows you to define custom logic that can be reused across multiple microflows?
A) Sub-microflow
B) Nanoflow
C) Java action
D) Microflow call
' Correct Answer: A
Rationale: Sub-microflows are reusable microflows that can be called from other microflows, promoting
modularity. Option B is client-side and not reusable in the same way. Option C is custom Java code, not a Mendix
native reusable logic unit. Option D is the act of calling a microflow, not the reusable component itself.
11. In a Mendix microflow, a Retrieve activity on entity Order uses an XPath constraint with a parameterized token.
Which statement best characterizes how Mendix 10+ handles this parameter and the resulting data set under a
production PostgreSQL database?
A) The parameter is bound at design time; changing its value at runtime requires a model redeploy.
B) The parameter is bound at runtime per execution, and the XPath is compiled into a parameterized SQL query
executed by the database.
C) The parameter is ignored unless the Retrieve is marked 'Apply constraint in database'.
D) The parameter is substituted textually into the XPath and re-parsed on the client, causing N+1 queries.
' Correct Answer: B
Rationale: Mendix binds XPath parameters at runtime for each microflow execution and translates the XPath into a
parameterized SQL statement executed by the database, avoiding SQL injection and enabling plan caching.
Page 3
, Design-time binding (A) is false, parameters are never silently ignored (C), and XPath is not client-side textually
substituted (D).
12. A developer needs to expose a REST endpoint that returns only the fields a mobile client is authorized to see,
while reusing the same domain model used by a full-page web UI. Which combination is the most appropriate?
A) A published REST service with a custom microflow that builds a non-persistent export entity and entity access
rules restricting the persistent entity.
B) A published REST service mapped directly to the persistent entity with default entity access, relying on the
client to filter fields.
C) A published OData service with 'Apply entity access' disabled to maximize performance.
D) A consumed REST service pointing back to the same app's REST endpoint to enforce field-level security.
' Correct Answer: A
Rationale: The secure pattern is a published REST service backed by a microflow that maps to a non-persistent
export entity, so only authorized fields leave the app, while entity access rules continue to protect the persistent
entity. Direct mapping (B) leaks fields, disabling entity access (C) removes the security boundary, and a consumed
service (D) does not enforce outbound field-level security.
13. Which statement correctly distinguishes a Mendix 'scheduled event' from a 'task queue' when designing resilient
background processing in a clustered runtime?
A) Scheduled events run on every cluster node simultaneously; task queues run on one node only.
B) Scheduled events are executed by a single elected node per scheduled time; task queues distribute individual
tasks across nodes with configurable concurrency and cluster-wide coordination.
C) Both are executed exclusively on the first node in the cluster and cannot be distributed.
D) Task queues require an external message broker; scheduled events are purely in-memory and lost on restart.
' Correct Answer: B
Rationale: Mendix scheduled events are coordinated so a single node executes each scheduled occurrence, whereas
task queues distribute tasks across the cluster with configurable concurrency and cluster-wide coordination. (A)
inverts the behavior, (C) is false for task queues, and (D) misstates both mechanisms.
14. A microflow iterates a list of 10,000 Orders and, inside the loop, performs a Retrieve on Customer for each
Order. Which refactoring most directly eliminates the N+1 query pattern while preserving behavior?
A) Add a 'Commit' activity inside the loop to flush pending changes.
B) Replace the loop with a single Retrieve over Customer using an XPath 'id = $Order_Customer' association path
and then associate in a second loop.
C) Retrieve the associated Customers in one Retrieve over the association from the Orders list, then iterate the
Orders and look up the Customer in memory.
D) Enable 'Optimize retrieve' on the Retrieve activity inside the loop.
' Correct Answer: C
Rationale: Retrieving all associated Customers in a single query and then resolving them in memory from the
retrieved list avoids one query per Order. Committing inside the loop (A) worsens performance, retrieving by id per
Order (B) still issues many queries, and there is no 'Optimize retrieve' toggle (D).
15. In a Mendix native mobile app, a developer must guarantee that data entered offline is eventually synchronized
exactly once to the server, even if the device retries after a network failure. Which design best achieves this?
A) Rely on the default offline synchronization, which guarantees exactly-once delivery.
B) Assign a client-generated idempotency key to each record and have the server-side synchronization microflow
upsert by that key.
C) Use a scheduled event on the device to post records directly to a REST endpoint without keys.
D) Disable offline synchronization and require the user to retry manually until success.
Page 4
