DMF Practice Test practice questions, page 8 of 12, with answer review and explanations.
Question 36
In data modelling practice, entities are linked by:
Triggers
Cardinality
Processes
Indexes
Relationships
Question 37
Data Models are critical to effective management of data, because they:
Control the list of values in dropdown lists in applications
Strategically prepare organisations to quickly evolve their products and services
Define the rules and approval mechanisms to make changes to the data structures
Determine which style of data schema is used in a data warehouse
Provide a common vocabulary around data
Question 38
The goal of data modelling, documenting different perspectives and aligning them in a single data model, achieves:
Applications that are deployed by simple version upgrades
Application projects that are less complicated due to a variant data model
Application performance that is guaranteed
Applications that meet the custom needs of specific business areas
Applications that more closely align to current and future business requirements
Question 39
Significant operational issues have been caused by the implementation of a data model that represents a Customer Agreement as a ternary relationship between the Enterprise, a Customer, and their Contact Person. Which of the following describes the likely operational issue?
Every time the customer changes addresses the address for the contact person must change as well
In the event of a merger between enterprises, the contact person addresses need to be updated
Every time the contact person changes, the customer agreement needs to be re-established
Response time for retrieving the Customer Agreement degrades rapidly due to the lack of indexing
Every time the Customer Agreement was renewed, a new Contact Person record was required
Question 40
A project scope includes the collection, exchange and reporting of data from multiple systems. Conceptual, logical and physical data models are maintained. How many models of each type can be expected?
More logical data models than physical data models, and more logical data models than conceptual data models
The same number of each of the model types
More conceptual data models than logical data models, and more logical data models than physical data models
Only 1 conceptual data model, 1 logical data model and 1 physical data model
More physical data models than logical data models, and more logical data models than conceptual data models