Mendix Advanced Certificated Exam
Questions and Answers
1.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.
2.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
3.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.
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.
4.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.
5.Why is it a best practice to create a specialization of the File-Document
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.
,6.What is the default value of the attribute DeleteAfterDownload?
A. true
B. false
Answer B. false
7.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
D. As binary in the contents of an attribute
Answer C. On the file server located on the application server
8.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.
9.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.
10.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
associa- tion 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.
11.What type of domain model changes can have an impact on the data in
the database?
A. Structural changes and Project changes
B. Type changes and Structural changes
C. Module changes and Project changes
D. Domain model changes and Type changes
Answer B. Type changes and Structural changes
12.What are the four stages of data conversion? (multiple answers are
cor- rect)
A. Search for good conversion tables
B. Skip them all and just do it
C. Clean up model
Questions and Answers
1.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.
2.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
3.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.
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.
4.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.
5.Why is it a best practice to create a specialization of the File-Document
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.
,6.What is the default value of the attribute DeleteAfterDownload?
A. true
B. false
Answer B. false
7.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
D. As binary in the contents of an attribute
Answer C. On the file server located on the application server
8.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.
9.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.
10.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
associa- tion 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.
11.What type of domain model changes can have an impact on the data in
the database?
A. Structural changes and Project changes
B. Type changes and Structural changes
C. Module changes and Project changes
D. Domain model changes and Type changes
Answer B. Type changes and Structural changes
12.What are the four stages of data conversion? (multiple answers are
cor- rect)
A. Search for good conversion tables
B. Skip them all and just do it
C. Clean up model
