MENDIX ADVANCED EXAMS SCRIPT 2025 QUESTIONS AND
ANSWERS RATED A+
✔✔If both the App and User time zones are set, the value of the localized DateTime
attribute displayed in the client depends on: - ✔✔The Client time zone
✔✔Jane in the Amsterdam time zone [UTC +2] selects 07/11/2020 in a date picker for a
non-localized attribute. What will be the value stored in the database? - ✔✔07/11/2020
12:00 AM
✔✔Nick in the Amsterdam time zone [UTC +2] selects 07/11/2020 in a date picker for a
non-localized attribute. What will be the date value if Nick converts it to a string in a
microflow using formatDateTime? - ✔✔07/11/2020 02:00 AM
✔✔The Mendix Client is: - ✔✔Built on a combination of HTML, CSS, and JavaScript
and runs in your browser.
✔✔Static resources in Mendix: - ✔✔Include stylesheets transmitted in CSS format to
the client.
✔✔The Communication between the Mendix Runtime and Database Server: -
✔✔Includes communication between the supported database servers using JDBC.
✔✔What is NOT an advantage of using the database source option versus the XPath
option? - ✔✔The database source option can be used to specify constraints that span
entities.
✔✔When you want to show a list of shipped orders, will the Database data source
generate a different request than the XPath data source option? - ✔✔No, the database
data source will always lead to the same request as the XPath data source.
✔✔Which of the following is not a possible source of data for a microflow? - ✔✔A page
passed as input parameter by another microflow.
✔✔Is the following statement true or false? By association will always be an in-memory
retrieve. - ✔✔False, if objects aren't available in memory, a retrieve by association will
automatically result in a database retrieve.
✔✔Is there ever a reason to retrieve an object from database instead of over
association? - ✔✔Yes, in cases where constraints other than a single association are
applicable or where stored database values are required.
, ✔✔In which microflow will the combination retrieve and aggregation be optimized? -
✔✔A (aggregated list not used later in flow)
✔✔What is an important rule to keep in mind when creating effective indexes? - ✔✔The
index should have the same order of attributes defined as in search and retrieve queries
in order to be available for queries.
✔✔Which of the following is NOT a benefit that XPath provides to the Mendix Platform?
- ✔✔XPath can be used to automatically generate pages and widgets to show data on.
✔✔What does the following XPath query return? //Product
[OrderManagement.OrderLine_Product/OrderManagement.OrderLine
/OrderManagement.OrderLine_Order != $Order] - ✔✔All the products that are ordered
at least once, but not on the affected order.
✔✔This XPath query can be optimized as follows:
[OrderManagement.OrderLine_Product /OrderManagement.Product/MinimalStock > 50]
[OrderManagement.OrderLine_Product /OrderManagement.Product/Status = 'Active']] -
✔✔[OrderManagement.OrderLine_Product/OrderManagement.Product [MinimalStock >
50 and Status = 'Active'] ]
✔✔The request as result of this XPath can be optimized as follows:
[OrderManagement.Stock_Product /OrderManagement.Product/Status = 'Deactivated'
or OrderManagement.Stock_Supplier /OrderManagement.Supplier/Active = false()] -
✔✔The request can be optimized by splitting it into different requests and joining the
results.
✔✔Which of the following statements is NOT an XPath best practice with regards to
optimal performance? - ✔✔Do not use XPath when you can use SQL instead.
✔✔Consider a situation in which there is an entity called Request with an attribute
status that has three values: Draft, Submitted, and Approved. There are three user
roles: Administrator, Customer, and Employee. The Customer user role is granted the
Customer module role. The only access rule configured is read/write access for the
Customer with the XPath [Status = Draft] applied. What would a user with the Customer
user role see on a page with a data grid without any additional XPath constraints? -
✔✔All the requests in the Draft status.
✔✔Consider the exact same situation as above. What would Admin users see? - ✔✔No
results would be returned.
✔✔Consider the same situation again. What would happen if you granted Admin users
access to a page with the Request entity in Studio Pro? - ✔✔Studio Pro would detect an
error and prevent a deployment.
ANSWERS RATED A+
✔✔If both the App and User time zones are set, the value of the localized DateTime
attribute displayed in the client depends on: - ✔✔The Client time zone
✔✔Jane in the Amsterdam time zone [UTC +2] selects 07/11/2020 in a date picker for a
non-localized attribute. What will be the value stored in the database? - ✔✔07/11/2020
12:00 AM
✔✔Nick in the Amsterdam time zone [UTC +2] selects 07/11/2020 in a date picker for a
non-localized attribute. What will be the date value if Nick converts it to a string in a
microflow using formatDateTime? - ✔✔07/11/2020 02:00 AM
✔✔The Mendix Client is: - ✔✔Built on a combination of HTML, CSS, and JavaScript
and runs in your browser.
✔✔Static resources in Mendix: - ✔✔Include stylesheets transmitted in CSS format to
the client.
✔✔The Communication between the Mendix Runtime and Database Server: -
✔✔Includes communication between the supported database servers using JDBC.
✔✔What is NOT an advantage of using the database source option versus the XPath
option? - ✔✔The database source option can be used to specify constraints that span
entities.
✔✔When you want to show a list of shipped orders, will the Database data source
generate a different request than the XPath data source option? - ✔✔No, the database
data source will always lead to the same request as the XPath data source.
✔✔Which of the following is not a possible source of data for a microflow? - ✔✔A page
passed as input parameter by another microflow.
✔✔Is the following statement true or false? By association will always be an in-memory
retrieve. - ✔✔False, if objects aren't available in memory, a retrieve by association will
automatically result in a database retrieve.
✔✔Is there ever a reason to retrieve an object from database instead of over
association? - ✔✔Yes, in cases where constraints other than a single association are
applicable or where stored database values are required.
, ✔✔In which microflow will the combination retrieve and aggregation be optimized? -
✔✔A (aggregated list not used later in flow)
✔✔What is an important rule to keep in mind when creating effective indexes? - ✔✔The
index should have the same order of attributes defined as in search and retrieve queries
in order to be available for queries.
✔✔Which of the following is NOT a benefit that XPath provides to the Mendix Platform?
- ✔✔XPath can be used to automatically generate pages and widgets to show data on.
✔✔What does the following XPath query return? //Product
[OrderManagement.OrderLine_Product/OrderManagement.OrderLine
/OrderManagement.OrderLine_Order != $Order] - ✔✔All the products that are ordered
at least once, but not on the affected order.
✔✔This XPath query can be optimized as follows:
[OrderManagement.OrderLine_Product /OrderManagement.Product/MinimalStock > 50]
[OrderManagement.OrderLine_Product /OrderManagement.Product/Status = 'Active']] -
✔✔[OrderManagement.OrderLine_Product/OrderManagement.Product [MinimalStock >
50 and Status = 'Active'] ]
✔✔The request as result of this XPath can be optimized as follows:
[OrderManagement.Stock_Product /OrderManagement.Product/Status = 'Deactivated'
or OrderManagement.Stock_Supplier /OrderManagement.Supplier/Active = false()] -
✔✔The request can be optimized by splitting it into different requests and joining the
results.
✔✔Which of the following statements is NOT an XPath best practice with regards to
optimal performance? - ✔✔Do not use XPath when you can use SQL instead.
✔✔Consider a situation in which there is an entity called Request with an attribute
status that has three values: Draft, Submitted, and Approved. There are three user
roles: Administrator, Customer, and Employee. The Customer user role is granted the
Customer module role. The only access rule configured is read/write access for the
Customer with the XPath [Status = Draft] applied. What would a user with the Customer
user role see on a page with a data grid without any additional XPath constraints? -
✔✔All the requests in the Draft status.
✔✔Consider the exact same situation as above. What would Admin users see? - ✔✔No
results would be returned.
✔✔Consider the same situation again. What would happen if you granted Admin users
access to a page with the Request entity in Studio Pro? - ✔✔Studio Pro would detect an
error and prevent a deployment.
