Mendix Advanced Certification Exam
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.
How does the platform use entity access XPaths to enforce security?
The XPaths are added to all the relevant database retrieves.
Where are entity access restrictions applied?
On relevant database retrieves.
Which of the following best describes how the Mendix platform applies entity
access?
The platform only grants the access explicitly defined in the entity access rules.
, In this domain model, assume that House is a specialization of Building:
Admin users will be able to read the SquareFoot attribute in data views for
Buildings and read and write in data views for Houses.
Referring to the same domain model as was used in question #2, if we create a page
with a data grid containing Houses and autogenerate a House_NewEdit page,
which of the following statements is FALSE for an Admin user?
Admin users will not see the SquareFoot attribute in the Edit page.
What is a benefit of assigning only one user role to each user?
Simplicity
Which operation can be used to select a specific set of rows in a table?
Selection
The Set Union operation combines two lists into one that contains:
One version of the objects from both lists
What operation combines the data from two different entities into one table?
Cartesian product
What does the Projection operation do?
It allows you to select attributes for all objects.
Re-take Knowledge CheckNext
What can you use a constrain function for?
To filter on strings and dates in XPath queries.
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.
How does the platform use entity access XPaths to enforce security?
The XPaths are added to all the relevant database retrieves.
Where are entity access restrictions applied?
On relevant database retrieves.
Which of the following best describes how the Mendix platform applies entity
access?
The platform only grants the access explicitly defined in the entity access rules.
, In this domain model, assume that House is a specialization of Building:
Admin users will be able to read the SquareFoot attribute in data views for
Buildings and read and write in data views for Houses.
Referring to the same domain model as was used in question #2, if we create a page
with a data grid containing Houses and autogenerate a House_NewEdit page,
which of the following statements is FALSE for an Admin user?
Admin users will not see the SquareFoot attribute in the Edit page.
What is a benefit of assigning only one user role to each user?
Simplicity
Which operation can be used to select a specific set of rows in a table?
Selection
The Set Union operation combines two lists into one that contains:
One version of the objects from both lists
What operation combines the data from two different entities into one table?
Cartesian product
What does the Projection operation do?
It allows you to select attributes for all objects.
Re-take Knowledge CheckNext
What can you use a constrain function for?
To filter on strings and dates in XPath queries.
