Practice — DM5-025–036
DM5-025 — Keys · Standard · distinguish
What is an alternate key?
A. A candidate key that was not selected as the primary key.
B. A foreign key used only for joins.
C. A key that cannot uniquely identify an occurrence.
D. A temporary key used during testing.
DM5-026 — Keys · Standard · recall
What is a business key?
A. A system-generated identifier with no business meaning.
B. A business-meaningful identifier used to retrieve or recognize an entity occurrence.
C. Any foreign key inherited from a parent.
D. A non-unique descriptive attribute.
DM5-027 — Keys · Difficult · distinguish
How does Chapter 5 characterize business keys and surrogate keys?
A. Every primary key must be both a business key and a surrogate key.
B. Surrogate keys are a special type of business key.
C. They are mutually exclusive classifications: a key is business-meaningful or system-generated without business meaning.
D. Business keys are always composite while surrogates are always simple.
DM5-028 — Domains · Standard · apply
An Order Status attribute may contain only Open, Closed, or Cancelled. Which domain form best fits?
A. Range
B. Data Format
C. Data Type
D. List
DM5-029 — Domains · Standard · apply
A Rating attribute must be between 1 and 5. Which domain form best fits?
A. Range
B. List
C. Data Format
D. Rule-based
DM5-030 — Domains · Standard · apply
A code must follow the pattern AAA-9999. Which domain form best fits?
A. Range
B. Data Format
C. List
D. Data Type
DM5-031 — Domains · Difficult · apply
A value is valid only when a conditional business rule involving other information is true. Which domain form is the closest fit?
A. Data Type
B. List
C. Rule-based
D. Range
DM5-032 — Schemes · Foundational · recall
Which modeling scheme emphasizes exact business meaning and the principle of keeping one fact in one place?
A. Dimensional
B. Object-Oriented
C. Graph NoSQL
D. Relational
DM5-033 — Schemes · Foundational · recall
Which scheme is designed primarily to support analytic querying around a business process using facts and dimensions?
A. Dimensional
B. Relational
C. Fact-Based
D. Time-Based
DM5-034 — Schemes · Standard · distinguish
In a dimensional model, which statement is correct?
A. Facts are descriptive labels and dimensions are numeric measures.
B. Facts are measurements; dimensions provide descriptive context used to query and report those measurements.
C. Facts and dimensions are synonyms.
D. Dimensions exist only in physical relational models.
DM5-035 — Schemes · Standard · understand
What does grain define in a dimensional fact table?
A. The number of dimensions in the warehouse.
B. The physical file size of the table.
C. The meaning and level of detail represented by one fact row.
D. The normalization level of the source system.
DM5-036 — Schemes · Standard · apply
A warehouse dimension corrects a customer's city by replacing the old value so no history is retained. Which slowly changing dimension type is this?
A. Type 2 — New Row
B. Type 3 — New Column
C. Conformed dimension
D. Type 1 — Overwrite