Free DMF – Cdmp DMF Practice Test Question

Reference / correct answer:

Most accepted answer: D. Denormalised

Community votes: A=1, B=1, D=3

Selected Answer: D During planning stage of a data model which of the following is not a valid scheme? The correct answer is D. Denormalised. Denormalised is not a valid data modeling scheme — it is a technique applied to an existing model (typically relational) to improve performance by intentionally introducing redundancy. You don't plan a model as "denormalised" from the start; you start with a properly normalized model and then selectively denormalize specific areas for performance reasons. The valid data modeling schemes recognized in DMBOK are: E. Relational — based on relational theory, entities and relationships, normalized structures (the most traditional approach) C. Dimensional — star/snowflake schemas with fact and dimension tables, designed for analytical/BI workloads B. Fact-based — ORM/FCO-IM approach, captures business facts at the most granular level for conceptual modeling A. NoSQL — document, key-value, graph, column-family models for flexible/unstructured data Each of these represents a fundamentally differ upvoted 1 times

Selected Answer: D The six most common schemes used to represent data are: Relational, Dimensional, Object-Oriented, Fact-Based, Time-Based, and NoSQL.”Denormalization is a technique, not a scheme. upvoted 1 times

Selected Answer: B Fact-Based Models are conceptual modeling techniques. They can be transformed into valid physical schemas (e.g., relational database schemas, dimensional schemas). It’s not a schema type like Star Schema, Snowflake Schema, or Data Vault but can lead to those through transformations. upvoted 1 times

Selected Answer: D DMBOK "The six most common schemes used to represent data are: Relational, Dimensional, Object-Oriented, Fact-Based, Time-Based, and NoSQL." upvoted 1 times

Selected Answer: A NoSQL is a database technology category, not a modeling scheme. upvoted 4 times