ExamGecko
Home Home / IIBA / CBDA
Question list
Search
Search

List of questions

Search

Related questions











Question 31 - CBDA discussion

Report
Export

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?

A.
Physical
Answers
A.
Physical
B.
Hierarchical
Answers
B.
Hierarchical
C.
Conceptual
Answers
C.
Conceptual
D.
Logical
Answers
D.
Logical
Suggested answer: A

Explanation:

A physical data model is the most detailed and specific type of data model, which shows how the data is stored, accessed, and manipulated in the database. It includes the table structures, column names, data types, primary and foreign keys, constraints, indexes, and other physical attributes of the data12.

Reference: 1: Guide to Business Data Analytics, IIBA, 2020, p. 542: Data Modeling Essentials, Graeme Simsion and Graham Witt, 2005, p. 15.

asked 18/09/2024
Mike Werts
32 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first