Mendix Advanced Exam questions and Answers Verified 100% Correct

Mendix Advanced Exam questions and Answers Verified 100% Correct What does the following XPath query return? //Product [OrderManagement.OrderLine_Product/OrderManagement.OrderLine /OrderManagement.OrderLine_Order != $Order] - 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']] - 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()] - 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? - 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? - ANSWER All the requests in the Draft status. Consider the exact same situation as above. What would Admin users see? - 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? - ANSWER Studio Pro would detect an error and prevent a deployment. How does the platform use entity access XPaths to enforce security? - ANSWER The XPaths are added to all the relevant database retrieves. Where are entity access restrictions applied? - ANSWER On relevant database retrieves. Which of the following best describes how the Mendix platform applies entity access? - ANSWER 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: - ANSWER 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? - ANSWER Admin users will not see the SquareFoot attribute in the Edit page. Why is it more secure to add security rules on the entity level? - ANSWER Entity level restrictions are applied at the database level and are thus automatically applied throughout the application. For the following questions, assume there is an app with three user roles: Administrator, Teacher, and Student. Administrators are granted the ability to manage all user roles, and Teachers can manage users with the Student role. Which of the following statements is false? - ANSWER Administrators and teachers can create teacher accounts. Let's say you want Teachers to be able to manage accounts for Students, but only the Students who are in their class. So, you grant Teachers the ability to manage users with the Student role in the app security menu. Will this be sufficient? - ANSWER No, because teachers will have the ability to edit the accounts of any Student, not just their own. What is a benefit of assigning only one user role to each user? - ANSWER Simplicity Which operation can be used to select a specific set of rows in a table? - ANSWER Selection The Set Union operation combines two lists into one that contains: - ANSWER one version of the objects from both lists What operation combines the data from two different entities into one table? - ANSWER Cartesian product What does the Projection operation do? - ANSWER It allows you to select attributes for all objects. Re-take Knowledge CheckNext What can you use a constrain function for? - ANSWER To filter on strings and dates in XPath queries. Which of the queries below can be used to filter on dates two weekso in the past? - ANSWER [%BeginOfCurrentDay%] - 2 * [%WeekLength%] One of your XPath queries that use the contains() function is not performing very well. What is the most likely root cause? - ANSWER You are using the function on a string that is set to 'unlimited'. When using the 'and' operator: - ANSWER The 'and' operator will give a different result based on how you write the XPath query. The not() function: - ANSWER Generates a slow query. Which statement best describes how you would retrieve all related objects in the most optimal way? - ANSWER When comparing to a related entity, it is enough to stop at the association to get the most optimal query. When should you apply an index? - ANSWER You should apply indexes on attributes that are used in searches when the performance of your app is not up to par. What is normalization? - ANSWER The removal of duplicate data from your domain model. Why would you want to do normalization? - ANSWER To remove duplicate data from your app so you can avoid insertion, update, and deletion anomalies. What is denormalization? - ANSWER The duplication of information in several entities to increase performance. What set-up items do you need to have in place before creating your REST methods? Choose one of the below. - ANSWER An entity with attributes, a Published REST service and a resource in the Published REST service