Exam DMF topic 1 question 14 discussion

1.3.3.1 Enterprise Data Model of DAMA-DMBOK2

The EDM can be a stand-alone artifact, or it can be comprised of the overall set of models created by the enterprise. Different types of models – at different levels of abstraction – must be related to each other. Conceptual models are ultimately linkable to physical application data models The diagram shows: • A conceptual overview over the enterprise’s subject areas • Views of entities and relationships for each subject area • Detailed, partially attributed logical views of these same subject areas • Logical and physical models specific to an application or project

An Enterprise Data Model (EDM) typically includes three core levels of abstraction: Conceptual Data Model – High-level representation focused on business entities and their relationships. It’s technology-agnostic and aimed at understanding the business. Logical Data Model – Adds more detail, such as attributes, data types, and normalization, but still independent of any specific database technology. Physical Data Model – Represents how the data is actually stored in the database, including tables, indexes, columns, data types, and relationships adapted to a specific DBMS (e.g., Oracle, SQL Server).

According to DAMA‐DMBOK2 (see especially the discussion in Chapter 4 on Data Architecture and the sections on Enterprise Data Models around p. 106), an Enterprise Data Model typically breaks the organization’s data into top‐level groups (subject areas), defines conceptual‐level entities for each subject area, and often includes at least some logical‐level detail. A full physical design is usually not part of the high‐level EDM. Hence, among the options given, the correct match with DMBOK2 is: C) Conceptual models, subject area models, and logical models.

An Enterprise Data Model (EDM) is a high-level representation of an organization’s data, typically consisting of three levels of abstraction: Conceptual Model – Defines high-level entities and relationships without technical details. Logical Model – Provides detailed structure, including attributes, keys, and relationships, independent of technology. Physical Model – Implements the logical model with database-specific structures, such as tables, indexes, and constraints.

B. Conceptual models, star schema models, and interface models → Incorrect, as star schema models are specific to data warehousing. C. Conceptual models, subject area models, and logical models → Incorrect, as subject area models are a subset of conceptual models. D. Logical models, physical models, and infrastructure models → Incorrect, as infrastructure models focus on hardware and network architecture. E. Enterprise models, data models, and compositional models → Incorrect, as enterprise models and compositional models are not standard data model categories.

Modelo conceptual, de áreas temáticas y lógico

C

Answer is C. page 106 of DMBOK2