Mendix Advanced Certification 2023/ 2024 Exam |Actual Questions and Verified Answers| Already Graded A Q: What is an important rule to keep in mind when creating effective indexes? Answer: The index should have the same order of attributes defined as in search and retrieve queries in order to be av...
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.
Voordelen van het kopen van samenvattingen bij Stuvia op een rij:
Verzekerd van kwaliteit door reviews
Stuvia-klanten hebben meer dan 700.000 samenvattingen beoordeeld. Zo weet je zeker dat je de beste documenten koopt!
Snel en makkelijk kopen
Je betaalt supersnel en eenmalig met iDeal, creditcard of Stuvia-tegoed voor de samenvatting. Zonder lidmaatschap.
Focus op de essentie
Samenvattingen worden geschreven voor en door anderen. Daarom zijn de samenvattingen altijd betrouwbaar en actueel. Zo kom je snel tot de kern!
Veelgestelde vragen
Wat krijg ik als ik dit document koop?
Je krijgt een PDF, die direct beschikbaar is na je aankoop. Het gekochte document is altijd, overal en oneindig toegankelijk via je profiel.
Tevredenheidsgarantie: hoe werkt dat?
Onze tevredenheidsgarantie zorgt ervoor dat je altijd een studiedocument vindt dat goed bij je past. Je vult een formulier in en onze klantenservice regelt de rest.
Van wie koop ik deze samenvatting?
Stuvia is een marktplaats, je koop dit document dus niet van ons, maar van verkoper quiz_bit. Stuvia faciliteert de betaling aan de verkoper.
Zit ik meteen vast aan een abonnement?
Nee, je koopt alleen deze samenvatting voor €7,91. Je zit daarna nergens aan vast.
