Mendix Advanced UPDATED ACTUAL
Exam Questions and CORRECT Answers
What is the correct XPath to retrieve the goals of the buddy of an apprentice? - CORRECT
ANSWER -
[SoccerSquad.Goal_Player/SoccerSquad.Player/SoccerSquad.Apprentice_Buddy [reversed()] =
'[%CurrentObject%]']
When localize is set to No, the date displayed in the client is based on the: - CORRECT
ANSWER - UTC value
Localizing a DateTime attribute has an effect on: - CORRECT ANSWER - Client
representation
If both the App and User time zones are set, the value of the localized DateTime attribute
displayed in the client depends on: - CORRECT ANSWER - 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? - CORRECT
ANSWER - 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? - CORRECT ANSWER - 07/11/2020 02:00 AM
The Mendix Client is: - CORRECT ANSWER - Built on a combination of HTML, CSS,
and JavaScript and runs in your browser.
Static resources in Mendix: - CORRECT ANSWER - Include stylesheets transmitted in
CSS format to the client.
,The Communication between the Mendix Runtime and Database Server: - CORRECT
ANSWER - Includes communication between the supported database servers using JDBC.
What is NOT an advantage of using the database source option versus the XPath option? -
CORRECT ANSWER - 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? - CORRECT ANSWER - 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? - CORRECT
ANSWER - 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. -
CORRECT ANSWER - 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? -
CORRECT ANSWER - 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? - CORRECT
ANSWER - A (aggregated list not used later in flow)
What is an important rule to keep in mind when creating effective indexes? - CORRECT
ANSWER - 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? -
CORRECT ANSWER - 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] - CORRECT ANSWER - 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']] - CORRECT ANSWER -
[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()] - CORRECT
ANSWER - 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? - CORRECT ANSWER - 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? - CORRECT ANSWER - All the requests in the Draft
status.
Consider the exact same situation as above. What would Admin users see? - CORRECT
ANSWER - 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? - CORRECT ANSWER - Studio Pro would
detect an error and prevent a deployment.
Exam Questions and CORRECT Answers
What is the correct XPath to retrieve the goals of the buddy of an apprentice? - CORRECT
ANSWER -
[SoccerSquad.Goal_Player/SoccerSquad.Player/SoccerSquad.Apprentice_Buddy [reversed()] =
'[%CurrentObject%]']
When localize is set to No, the date displayed in the client is based on the: - CORRECT
ANSWER - UTC value
Localizing a DateTime attribute has an effect on: - CORRECT ANSWER - Client
representation
If both the App and User time zones are set, the value of the localized DateTime attribute
displayed in the client depends on: - CORRECT ANSWER - 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? - CORRECT
ANSWER - 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? - CORRECT ANSWER - 07/11/2020 02:00 AM
The Mendix Client is: - CORRECT ANSWER - Built on a combination of HTML, CSS,
and JavaScript and runs in your browser.
Static resources in Mendix: - CORRECT ANSWER - Include stylesheets transmitted in
CSS format to the client.
,The Communication between the Mendix Runtime and Database Server: - CORRECT
ANSWER - Includes communication between the supported database servers using JDBC.
What is NOT an advantage of using the database source option versus the XPath option? -
CORRECT ANSWER - 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? - CORRECT ANSWER - 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? - CORRECT
ANSWER - 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. -
CORRECT ANSWER - 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? -
CORRECT ANSWER - 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? - CORRECT
ANSWER - A (aggregated list not used later in flow)
What is an important rule to keep in mind when creating effective indexes? - CORRECT
ANSWER - 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? -
CORRECT ANSWER - 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] - CORRECT ANSWER - 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']] - CORRECT ANSWER -
[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()] - CORRECT
ANSWER - 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? - CORRECT ANSWER - 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? - CORRECT ANSWER - All the requests in the Draft
status.
Consider the exact same situation as above. What would Admin users see? - CORRECT
ANSWER - 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? - CORRECT ANSWER - Studio Pro would
detect an error and prevent a deployment.
