Practice — DM5-037–048
DM5-037 — Schemes · Standard · apply
A warehouse must preserve every historical customer region change by adding a new dimension row for each version. Which SCD type is this?
A. Type 2 — New Row
B. Type 1 — Overwrite
C. Type 3 — New Column
D. Snowflaking
DM5-038 — Schemes · Difficult · apply
A dimension keeps the current department plus one 'previous department' column. Which SCD type best fits?
A. Type 1 — Overwrite
B. Type 3 — New Column
C. Type 2 — New Row
D. Conformed fact
DM5-039 — Schemes · Difficult · understand
What is the purpose of a conformed dimension?
A. To force every dimension into third normal form.
B. To store only slowly changing attributes.
C. To provide a consistently defined dimension that can be shared across dimensional models.
D. To replace the need for facts.
DM5-040 — Schemes · Standard · recall
Which scheme uses UML-style classes or objects that combine attributes with operations or methods?
A. Relational
B. Dimensional
C. Fact-Based
D. Object-Oriented
DM5-041 — Schemes · Difficult · recall
Which statement best characterizes Fact-Based Modeling in Chapter 5?
A. It models objects, facts, and roles and can verbalize facts in controlled natural language rather than treating attributes as the primary construct.
B. It models only star schemas for analytics.
C. It is a NoSQL document approach.
D. It uses only physical tables and indexes.
DM5-042 — Schemes · Standard · recall
Which trio belongs to Data Vault modeling?
A. Facts, dimensions, and grain
B. Hubs, links, and satellites
C. Anchors, ties, and knots
D. Nodes, edges, and properties
DM5-043 — Schemes · Standard · recall
Which set belongs to Anchor Modeling?
A. Hubs, links, and satellites
B. Facts, dimensions, and measures
C. Anchors, attributes, ties, and knots
D. Documents, keys, and columns
DM5-044 — Schemes · Standard · apply
Which NoSQL category is most naturally described as storing self-contained document structures?
A. Key-value
B. Column-oriented
C. Graph
D. Document
DM5-045 — Schemes · Difficult · apply
A system's dominant requirement is traversing highly connected relationships among people, devices, and accounts. Which NoSQL category best fits the chapter's scheme recognition?
A. Graph
B. Document
C. Key-value
D. Column-oriented
DM5-046 — Levels · Foundational · recall
What is the primary purpose of a conceptual data model?
A. To specify DBMS indexes and partitions.
B. To establish a high-level business view of important concepts/entities and relationships, defining scope and vocabulary.
C. To define every attribute data type and length.
D. To record only production database tables.
DM5-047 — Levels · Foundational · recall
What most clearly distinguishes a logical data model?
A. It contains only high-level subject-area names.
B. It specifies vendor-specific storage and indexes.
C. It captures detailed data requirements, including attributes, keys, domains, and normalized structure, while remaining technology-independent.
D. It contains only data flows between applications.
DM5-048 — Levels · Foundational · recall
What most clearly distinguishes a physical data model?
A. It is always enterprise-wide and technology-independent.
B. It contains no keys or attributes.
C. It is used only before requirements are understood.
D. It represents a technology-specific implementation, including database/storage details.