Certificate in Business Data Analytics (CBDA) — Question 49

An analyst has just completed building a data model that shows the table structures including table names, table relationships with primary and foreign keys and column names with respective data types.
What type of data model has the analyst just built?

Answer options

• A. Physical
• B. Logical
• C. Conceptual
• D. Hierarchical

Correct answer: A

Explanation

The correct answer is A, Physical, as this model includes specific details about the actual implementation, such as table structures and data types. The Logical model (B) focuses more on the organization of data without considering how it is physically implemented, while the Conceptual model (C) provides a high-level overview of the data. The Hierarchical model (D) is a specific database design that organizes data in a tree-like structure, which does not fit the description provided.