MENDIX ADVANCED EXAM STUDY GUIDE 2025/2026
QUESTIONS WITH SOLUTIONS GRADED A+
✔✔Let's say you want Teachers to be able to manage accounts for Students, but only
the Students who are in their class. So, you grant Teachers the ability to manage users
with the Student role in the app security menu. Will this be sufficient?
A. Yes, because Accounts are a specialization of the User entity.
B. No, because teachers will have the ability to edit the accounts of any Student, not
just their own.
C. Yes, because now Teachers can edit the account details of the Students.
D. No, because only Admins should have the ability to edit accounts.
Submit Answers - ✔✔B. No, because teachers will have the ability to edit the accounts
of any Student, not just their own.
✔✔What is a benefit of assigning only one user role to each user?
A. Better representation of business specific processes.
B. It requires users to create a new account if they need to change roles.
C. It is inherently more secure.
D. Simplicity. - ✔✔D. Simplicity.
✔✔Which operation can be used to select a specific set of rows in a table?
Elimination
Projection
Set operation
Selection - ✔✔Selection
✔✔The Set Union operation combines two lists into one that contains:
All elements that exist in both lists.
All elements from both lists.
All elements from both lists without duplicates.
All elements that appear in only one of the two lists. - ✔✔All elements from both lists
without duplicates.
✔✔What operation combines the data from two different entities into one table?
Projection
Set difference
Set union
Cartesian product - ✔✔Cartesian product
✔✔What does the Projection operation do?
It allows you to select attributes for all objects.
It allows you to add two lists into one.
It allows you to select objects from an entity.
It allows you to project an entity onto a data view.
,Submit Answers - ✔✔It allows you to select attributes for all objects.
✔✔What can you use a constraint function for?
To select objects based on enumerations.
To filter on strings and dates in XPath queries.
To use Java in your XPath queries.
To call a microflow into your XPath. - ✔✔To filter on strings and dates in XPath queries.
✔✔Which of the queries below can be used to filter on dates two weeks in the past?
[%BeginOfCurrentDay%] - 2 * [%WeekLength%]
[%CurrentDay%] - 2 + [%WeekLength%]
[%CurrentDay%] - 2 * [%WeekLength%]
[%BeginOfCurrentDay%] - 2 + [%WeekLength%] - ✔✔[%BeginOfCurrentDay%] - 2 *
[%WeekLength%]
✔✔One of your XPath queries that use the contains() function is not performing very
well. What is the most likely root cause?
You are using the function on an attribute that is not a string.
You have not implemented a separate XPath query for all the languages that your app
is using.
You have implemented a custom function in JavaScript.
You are using the function on a string that is set to 'unlimited'.
Submit Answers - ✔✔You are using the function on a string that is set to 'unlimited'.
Submit Answers
✔✔When using the OR operator:
You can omit the word 'or' and instead enter two separate XPath statements, each with
its own set of [].
You must enclose the statement following the 'or' in ().
Simply place the word 'or' between two XPath statements.
'or' must be the first word in the XPath expression. - ✔✔Simply place the word 'or'
between two XPath statements.
✔✔The not() function:
Generates a slow query.
Generates the same query as the != operator.
Can only be used on boolean attributes.
Cannot be used when you use the OR operator. - ✔✔Generates a slow query.
✔✔Which statement best describes how you would retrieve all related objects in the
most optimal way?
Mendix will optimize your XPath expressions at runtime.
When comparing to a related entity, it is enough to stop at the association to get the
most optimal query.
, When you use an object in your XPath, you need to compare it to an entity directly like
this: [Sales.Customer_Account/Administration.Account = $currentUser] to get the most
optimal query.
You can only compare an object to the id attribute of an entity of the same type to get
the most optimal query. - ✔✔When comparing to a related entity, it is enough to stop at
the association to get the most optimal query.
✔✔When should you apply an index?
You should only apply indexes on boolean attributes.
You should always apply indexes on all your attributes; that makes your app faster.
You should apply indexes on attributes that are used in searches when the performance
of your app is not up to par.
Mendix will apply indexes where needed, you don't need to worry about that. - ✔✔You
should apply indexes on attributes that are used in searches when the performance of
your app is not up to par.
✔✔What is normalization?
The addition of attributes to your entities to store data in multiple places to your app
runs faster.
The addition of entities to your domain model that help you track normal behavior of
your app.
The removal of duplicate data from your domain model.
The act of removing unneeded entities from your domain model. - ✔✔The removal of
duplicate data from your domain model.
✔✔Why would you want to normalize your domain model?
To increase the performance of your XPath retrieves.
To prepare your app for deployment on a cloud node.
To make your domain model easier to read.
To remove duplicate data from your app so you can avoid insertion, update, and
deletion anomalies. - ✔✔To remove duplicate data from your app so you can avoid
insertion, update, and deletion anomalies.
✔✔What is denormalization?
The addition of more entities in your domain model to increase performance.
The removal of XPath expressions to increase performance.
The addition of more associations to your domain model to increase performance.
The duplication of information in several entities to increase performance.
Submit Answers - ✔✔The duplication of information in several entities to increase
performance.
Submit Answers
✔✔What does idempotent mean?
That you can change all attribute values of the target object with such a request
That the input of multiple identical requests can be the same as a single such request
QUESTIONS WITH SOLUTIONS GRADED A+
✔✔Let's say you want Teachers to be able to manage accounts for Students, but only
the Students who are in their class. So, you grant Teachers the ability to manage users
with the Student role in the app security menu. Will this be sufficient?
A. Yes, because Accounts are a specialization of the User entity.
B. No, because teachers will have the ability to edit the accounts of any Student, not
just their own.
C. Yes, because now Teachers can edit the account details of the Students.
D. No, because only Admins should have the ability to edit accounts.
Submit Answers - ✔✔B. No, because teachers will have the ability to edit the accounts
of any Student, not just their own.
✔✔What is a benefit of assigning only one user role to each user?
A. Better representation of business specific processes.
B. It requires users to create a new account if they need to change roles.
C. It is inherently more secure.
D. Simplicity. - ✔✔D. Simplicity.
✔✔Which operation can be used to select a specific set of rows in a table?
Elimination
Projection
Set operation
Selection - ✔✔Selection
✔✔The Set Union operation combines two lists into one that contains:
All elements that exist in both lists.
All elements from both lists.
All elements from both lists without duplicates.
All elements that appear in only one of the two lists. - ✔✔All elements from both lists
without duplicates.
✔✔What operation combines the data from two different entities into one table?
Projection
Set difference
Set union
Cartesian product - ✔✔Cartesian product
✔✔What does the Projection operation do?
It allows you to select attributes for all objects.
It allows you to add two lists into one.
It allows you to select objects from an entity.
It allows you to project an entity onto a data view.
,Submit Answers - ✔✔It allows you to select attributes for all objects.
✔✔What can you use a constraint function for?
To select objects based on enumerations.
To filter on strings and dates in XPath queries.
To use Java in your XPath queries.
To call a microflow into your XPath. - ✔✔To filter on strings and dates in XPath queries.
✔✔Which of the queries below can be used to filter on dates two weeks in the past?
[%BeginOfCurrentDay%] - 2 * [%WeekLength%]
[%CurrentDay%] - 2 + [%WeekLength%]
[%CurrentDay%] - 2 * [%WeekLength%]
[%BeginOfCurrentDay%] - 2 + [%WeekLength%] - ✔✔[%BeginOfCurrentDay%] - 2 *
[%WeekLength%]
✔✔One of your XPath queries that use the contains() function is not performing very
well. What is the most likely root cause?
You are using the function on an attribute that is not a string.
You have not implemented a separate XPath query for all the languages that your app
is using.
You have implemented a custom function in JavaScript.
You are using the function on a string that is set to 'unlimited'.
Submit Answers - ✔✔You are using the function on a string that is set to 'unlimited'.
Submit Answers
✔✔When using the OR operator:
You can omit the word 'or' and instead enter two separate XPath statements, each with
its own set of [].
You must enclose the statement following the 'or' in ().
Simply place the word 'or' between two XPath statements.
'or' must be the first word in the XPath expression. - ✔✔Simply place the word 'or'
between two XPath statements.
✔✔The not() function:
Generates a slow query.
Generates the same query as the != operator.
Can only be used on boolean attributes.
Cannot be used when you use the OR operator. - ✔✔Generates a slow query.
✔✔Which statement best describes how you would retrieve all related objects in the
most optimal way?
Mendix will optimize your XPath expressions at runtime.
When comparing to a related entity, it is enough to stop at the association to get the
most optimal query.
, When you use an object in your XPath, you need to compare it to an entity directly like
this: [Sales.Customer_Account/Administration.Account = $currentUser] to get the most
optimal query.
You can only compare an object to the id attribute of an entity of the same type to get
the most optimal query. - ✔✔When comparing to a related entity, it is enough to stop at
the association to get the most optimal query.
✔✔When should you apply an index?
You should only apply indexes on boolean attributes.
You should always apply indexes on all your attributes; that makes your app faster.
You should apply indexes on attributes that are used in searches when the performance
of your app is not up to par.
Mendix will apply indexes where needed, you don't need to worry about that. - ✔✔You
should apply indexes on attributes that are used in searches when the performance of
your app is not up to par.
✔✔What is normalization?
The addition of attributes to your entities to store data in multiple places to your app
runs faster.
The addition of entities to your domain model that help you track normal behavior of
your app.
The removal of duplicate data from your domain model.
The act of removing unneeded entities from your domain model. - ✔✔The removal of
duplicate data from your domain model.
✔✔Why would you want to normalize your domain model?
To increase the performance of your XPath retrieves.
To prepare your app for deployment on a cloud node.
To make your domain model easier to read.
To remove duplicate data from your app so you can avoid insertion, update, and
deletion anomalies. - ✔✔To remove duplicate data from your app so you can avoid
insertion, update, and deletion anomalies.
✔✔What is denormalization?
The addition of more entities in your domain model to increase performance.
The removal of XPath expressions to increase performance.
The addition of more associations to your domain model to increase performance.
The duplication of information in several entities to increase performance.
Submit Answers - ✔✔The duplication of information in several entities to increase
performance.
Submit Answers
✔✔What does idempotent mean?
That you can change all attribute values of the target object with such a request
That the input of multiple identical requests can be the same as a single such request
