Practice — DM5-061–072
DM5-061 — Activities · Standard · recall
Which sequence represents forward engineering?
A. Requirements → Conceptual Data Model → Logical Data Model → Physical Data Model
B. Physical → Logical → Conceptual → Requirements
C. Logical → Requirements → Physical → Conceptual
D. Requirements → Physical → Conceptual → Logical
DM5-062 — Activities · Standard · recall
Which sequence best represents reverse engineering?
A. Requirements → Conceptual → Logical → Physical
B. Existing database/physical implementation → Physical model → Logical model → Conceptual understanding
C. Conceptual → Physical → Requirements
D. Physical → New database without logical interpretation
DM5-063 — Activities · Difficult · apply
A team replaces a natural composite primary key with a surrogate key during physical design. What does Chapter 5 say should happen to the original uniqueness?
A. Delete the original uniqueness because the surrogate makes it unnecessary.
B. Convert every original key attribute into nullable text.
C. Preserve it as an alternate key or equivalent uniqueness constraint.
D. Move the original uniqueness only into documentation, not the database.
DM5-064 — Activities · Standard · recall
What three qualities should a data-model review assess?
A. Performance, security, and maintainability
B. Clarity, accuracy, and completeness
C. Scope, cost, and schedule
D. Correctness, completeness, and consistency
DM5-065 — Activities · Difficult · understand
What is a key maintenance expectation in Chapter 5?
A. Keep models synchronized with implemented change, often reverse-engineering the latest physical state and reconciling it with the logical model.
B. Freeze the logical model after first approval.
C. Update only diagrams and ignore definitions/lineage.
D. Discard physical models after deployment.
DM5-066 — Tools · Standard · recall
Which set is explicitly associated with supporting Data Modeling and Design?
A. Only spreadsheet software and slide decks
B. Data modeling tools, lineage tools, data profiling tools, Metadata repositories, data model patterns, and industry data models
C. Only DBMS administration consoles
D. Only data-quality scorecards
DM5-067 — Best Practices · Difficult · distinguish
Which naming practice best matches Chapter 5?
A. Use cryptic abbreviations in both logical and physical models.
B. Use environment-specific labels such as TEST_ and PROD_ as entity names.
C. Use meaningful business-friendly full words in logical models where possible, while physical names may use approved abbreviations/underscores to fit DBMS constraints.
D. Physical and logical names must always be identical character-for-character.
DM5-068 — Best Practices · Standard · recall
What does PRISM represent in Chapter 5?
A. Privacy, Retention, Integration, Stewardship, and Metadata
B. Planning, Review, Implementation, Scope, and Modeling
C. Performance, Replication, Indexing, Storage, and Migration
D. Performance and ease of use, Reusability, Integrity, Security, and Maintainability
DM5-069 — Governance · Difficult · apply
A formal design review finds unresolved disagreement and the model is not approved. What should happen according to Chapter 5?
A. Rework the model; if a final unresolved design decision remains, the owner of the system being modeled has decision authority.
B. Approve it automatically because the meeting occurred.
C. Let the modeling tool choose the final design.
D. Delete the rejected alternatives and continue without recording them.
DM5-070 — Governance · Standard · recall
Which four dimensions should model version/change control record?
A. Only the new model filename and date
B. Why, What/How, When, and Who/Where
C. Only who approved and the final score
D. Only physical column differences
DM5-071 — Metrics · Difficult · recall
Which two Data Model Scorecard categories carry the highest individual weights in Chapter 5?
A. Naming standards and Readability, at 15 each
B. Enterprise consistency and Naming standards, at 15 each
C. Capture requirements and Completeness, at 15 points each (with Structural soundness also weighted at 15).
D. Definitions and Metadata matches data, at 15 each
DM5-072 — Metrics · Expert-discrimination · apply
A model diagram looks polished, but several business requirements are missing and the stored Metadata no longer reflects the actual database. Which scorecard concerns are most directly implicated?
A. Naming standards and Readability only
B. Generic structures and Reusability only
C. Performance and Security only
D. Capture requirements / Completeness and Metadata matches data