Academic Curator
search
Model Data Object Exam
Time Left: 00:00

Model Data Object Practice Exam

Instruction: Select the correct answer for each of the 25 questions based on the Model Data Object (M02) module.

1. Which data analysis method answers the question "Why did it happen?" by finding causes from statistical insights?




2. Which analysis method uses previous data to show "what is likely to happen" through forecasting?




3. Which analysis method determines the specific action to take to solve a current problem by combining insights from all other analyses?




4. According to the document, a system scope statement must be a complete definition encompassing which requirements?




5. What is the term for an entity set that does not have sufficient attributes to form a primary key and depends on another entity?




6. Which type of entity is used to convert a Many-to-Many relationship into two One-to-Many relationships?




7. An address that is subdivided into City, Sub-city, and House Number is an example of which attribute type?




8. Which type of attribute is calculated from another attribute (e.g., calculating AGE from Date of Birth)?




9. A person having multiple phone numbers is an example of which attribute type?




10. Which key is chosen as the main method of uniquely identifying a row and cannot contain null values?




11. Which key is used to create a relationship by referencing the primary key of another table?




12. Which level of ERD is the highest-level view, contains little detail, and is solution agnostic?




13. For data entries with variable length (like an address), which data type is recommended?




14. In a relationship where one building contains many different employees, but each employee works in only one building, what is the cardinality?




15. What is a statement that defines or constrains some aspect of business and always resolves to true or false?




16. What is the process of refining a database design to resolve inconsistency, ambiguity, and redundancy?




17. Which anomaly occurs when it is impossible to insert a new record without including additional, unrelated data?




18. Which anomaly occurs when changing a field (like a Class name) requires renaming every row where that field appears?




19. Which normal form requires that all underlying domains contain atomic values only and eliminates repeating groups?




20. Which normal form requires that every non-key attribute is fully dependent on the entire primary key (no partial dependencies)?




21. Which normal form is the most optimal and eliminates transitive dependencies?




22. What occurs when an attribute depends on another non-key attribute rather than directly on the primary key?




23. What process confirms the accuracy, completeness, and appropriateness of a data model design with stakeholders?




24. Which documentation component serves as a centralized reference for all entities, attributes, and constraints?




25. When resolving arising issues, what is the first step according to the module?