Mendix Advanced Exam Questions And Answers Verified 100% Correct

Mendix Advanced Exam Questions And Answers Verified 100% Correct Is there ever a reason to retrieve an object from database instead of over association? A. Yes, retrieving from the database makes sure that all the configured entity access rules are applied. B. Yes, in cases where constraints other than a single association are applicable or where stored database values are required. C. No, by retrieving over association the object will be retrieved from the object cache (if available), which improves performance. D. No, retrieving from database will exhibit the same behavior as retrieving over association if the object is retrievable over association. - ANSWER -B. Yes, in cases where constraints other than a single association are applicable or where stored database values are required. What is an important rule to keep in mind when creating effective indexes? A. An index makes sense only when querying non-persistent objects. B. The index should be defined immediately after the attributes have been defined on the entity. C. The index should have the same order of attributes defined as in search and retrieve queries in order to be available for queries. D. An index must be manually refreshed after deployment to make sure it's accurate and up to date. - ANSWER -C. 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? A. XPath provides a uniform query language regardless of which of the supported databases is used. B. XPath abstracts away individual deviations from the SQL standard in the underlying supported databases. C. The XPath notation can be derived visually by walking over the path between two entities in a domain model. D. XPath can be used to automatically generate pages and widgets to show data on. - ANSWER -D. XPath can be used to automatically generate pages and widgets to show data on. What does the following XPath query return? [OrderManagement.OrderLine_Product/OrderManagement.OrderLine/OrderMana gement.OrderLine_Order != $Order] A. All the products that are ordered at least once, including on the affected order. B. All the products that aren't ordered at any order. C. All the products that aren't ordered on the affected order. D. All the products that are ordered at least once, but not on the affected order - ANSWER -D. 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'] A. [OrderManagement.OrderLine_Product/OrderManagement.Product[MinimalStock 50 and Status = 'Active']] B. [OrderManagement.OrderLine_Product[OrderManagement.Product/MinimalStock 50][OrderManagement.Product/Status = 'Active']] C. [OrderManagement.OrderLine_Product/OrderManagement.Product[MinimalStock 50] or [Status = 'Active']] D. [OrderManagement.OrderLine_Product/OrderManagement.Product[MinimalStock 50 or Status = 'Active']] - ANSWER -A. [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()] A. [OrderManagement.Stock_Product/OrderManagement.Product[Status = 'Deactivated' or Active = false()]] B. The request cannot be optimized, since it is consuming two different paths C. The request is automatically optimized by the database server. D. The request can be optimized by splitting it into different requests and joining the results. - ANSWER -D. 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? A. Do not use XPath when you can use SQL instead. B. Limit the number of associations that are crossed when defining a constraint. C. Limit the usage of the OR operator, as it can negatively impact performance. D. When combining multiple constraints, start with the most constraining limit first. - ANSWER -A. Do not use XPath when you can use SQL instead. Which of the following best describes how the Mendix platform applies entity access? A. The platform grants read access to all attributes, but write access must be explicitly specified. B. The platform assumes access is granted until it is explicitly removed. C. The platform only grants the access explicitly defined in the entity access rules. D. The platform grants read/write access to all Admin users. - ANSWER -C. The platform only grants the access explicitly defined in the entity access rules. Why is it more secure to add security rules on the entity level? A. Entity level restrictions are applied at the database level and are thus automatically applied throughout the application. B. Entity level restrictions affect what the end-users will see. C. Entity level security secures each entity throughout the application. D. Users will not see entities to which they have no access.