MENDIX ADVANCED CERTIFICATED EXAM | FROM
QUESTION TO PERFECTION| STUDY WITH
CONFIDENCE!
Inheritance is used to:
A. Reuse attributes of an entity on other entities, so that you don't need to add and
maintain them multiple times.
B. Inherit the structure and behavior of an entity, so that all specializations can be used
individually within the same process.
C. Keep your domain model maintainable by inheriting the attributes and associations.
D. Inherit the history of an entity. - Answer: B. Inherit the structure and behavior of an entity,
so that all specializations can be used individually within the same process.
What is the result of generalizing the Player entity by the Person entity?
A. Three tables, one per entity plus a join table
B. A single link table to store the ID's of inherited objects
C. Two tables, one per entity
D. A single table containing the Player and Person attributes - Answer: C. Two tables, one
per entity
What will happen to the ID's after generalizing the Player and Staff entities by the Person
entity?
A. There are no changes to the ID's when inheriting.
B. The ID of the Person part of a Player or Staff will differ from the specialization part.
C. The ID's of Player and Staff will keep their own set and sequence and will equal the ID in
the Person table.
APPHIA – Crafted with Care and Precision for Academic Excellence.
1
,D. Same set and sequence for Player and Staff, the ID of person will differ. - Answer: C. The
ID's of Player and Staff will keep their own set and sequence and will equal the ID in the
Person table.
Which statement is correct?
A. A 1-1 association is a HAS and inheritance is an IS type of relation.
B. A 1-1 association and inheritance are both an HAS type of relation.
C. A 1-1 association and inheritance are both an IS type of relation.
D. A 1-1 association is an IS and inheritance is an HAS type of relation. - Answer: A. A 1-1
association is a HAS and inheritance is an IS type of relation.
Why is it a best practice to create a specialization of the filedocument and Image entities?
A. It allows for better security and property configuration based on purpose.
B. Otherwise you cannot store a file on an Amazon server.
C. It is visually a better representation of the use case.
D. It is a UML standard. - Answer: A. It allows for better security and property configuration
based on purpose.
What is the default value of the attribute deleteafterdownload?
A. True
B. False - Answer: B. False
Where are the file(s) or image(s) stored by default?
A. On the local drive of the user
B. On a dedicated Amazon file server
C. On the file server located on the application server
APPHIA – Crafted with Care and Precision for Academic Excellence.
2
, D. As binary in the contents of an attribute - Answer: C. On the file server located on the
application server
When it is better to place Indexes?
A. If a user starts complaining.
B. If you expect it might improve performance.
C. If there are more Read than Write actions.
D. If there are more Write than Read actions. - Answer: C. If there are more Read than Write
actions.
What happens when you apply an index?
A. The speed of Update and Inserts will increase.
B. The speed of Read actions will increase.
C. The speed of Read actions will decrease.
D. The speed of Write actions will increase. - Answer: B. The speed of Read actions will
increase.
The app performance is affected by a reference set (both) because:
A. You cannot store additional information in a reference set (both).
B. The join table must be queried as well.
C. There is no impact on performance, this depends only on how the association is queried.
D. Both entities needs to be joined with the reference table and data transfer increases. -
Answer: D. Both entities needs to be joined with the reference table and data transfer
increases.
What type of domain model changes can have an impact on the data in the database?
A. Structural changes and Project changes
APPHIA – Crafted with Care and Precision for Academic Excellence.
3
QUESTION TO PERFECTION| STUDY WITH
CONFIDENCE!
Inheritance is used to:
A. Reuse attributes of an entity on other entities, so that you don't need to add and
maintain them multiple times.
B. Inherit the structure and behavior of an entity, so that all specializations can be used
individually within the same process.
C. Keep your domain model maintainable by inheriting the attributes and associations.
D. Inherit the history of an entity. - Answer: B. Inherit the structure and behavior of an entity,
so that all specializations can be used individually within the same process.
What is the result of generalizing the Player entity by the Person entity?
A. Three tables, one per entity plus a join table
B. A single link table to store the ID's of inherited objects
C. Two tables, one per entity
D. A single table containing the Player and Person attributes - Answer: C. Two tables, one
per entity
What will happen to the ID's after generalizing the Player and Staff entities by the Person
entity?
A. There are no changes to the ID's when inheriting.
B. The ID of the Person part of a Player or Staff will differ from the specialization part.
C. The ID's of Player and Staff will keep their own set and sequence and will equal the ID in
the Person table.
APPHIA – Crafted with Care and Precision for Academic Excellence.
1
,D. Same set and sequence for Player and Staff, the ID of person will differ. - Answer: C. The
ID's of Player and Staff will keep their own set and sequence and will equal the ID in the
Person table.
Which statement is correct?
A. A 1-1 association is a HAS and inheritance is an IS type of relation.
B. A 1-1 association and inheritance are both an HAS type of relation.
C. A 1-1 association and inheritance are both an IS type of relation.
D. A 1-1 association is an IS and inheritance is an HAS type of relation. - Answer: A. A 1-1
association is a HAS and inheritance is an IS type of relation.
Why is it a best practice to create a specialization of the filedocument and Image entities?
A. It allows for better security and property configuration based on purpose.
B. Otherwise you cannot store a file on an Amazon server.
C. It is visually a better representation of the use case.
D. It is a UML standard. - Answer: A. It allows for better security and property configuration
based on purpose.
What is the default value of the attribute deleteafterdownload?
A. True
B. False - Answer: B. False
Where are the file(s) or image(s) stored by default?
A. On the local drive of the user
B. On a dedicated Amazon file server
C. On the file server located on the application server
APPHIA – Crafted with Care and Precision for Academic Excellence.
2
, D. As binary in the contents of an attribute - Answer: C. On the file server located on the
application server
When it is better to place Indexes?
A. If a user starts complaining.
B. If you expect it might improve performance.
C. If there are more Read than Write actions.
D. If there are more Write than Read actions. - Answer: C. If there are more Read than Write
actions.
What happens when you apply an index?
A. The speed of Update and Inserts will increase.
B. The speed of Read actions will increase.
C. The speed of Read actions will decrease.
D. The speed of Write actions will increase. - Answer: B. The speed of Read actions will
increase.
The app performance is affected by a reference set (both) because:
A. You cannot store additional information in a reference set (both).
B. The join table must be queried as well.
C. There is no impact on performance, this depends only on how the association is queried.
D. Both entities needs to be joined with the reference table and data transfer increases. -
Answer: D. Both entities needs to be joined with the reference table and data transfer
increases.
What type of domain model changes can have an impact on the data in the database?
A. Structural changes and Project changes
APPHIA – Crafted with Care and Precision for Academic Excellence.
3
