Mendix Advanced Certification 2023 / 2024 Exam | Actual Questions and Verified Answers | Already Graded A
72 views 1 purchase
Course
MENDIX
Institution
MENDIX
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.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller quiz_bit. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $7.99. You're not tied to anything after your purchase.
