DMC Data Modeling Fundamentals

Question 1

Which of the following best defines a data model?

Accepted Answer

An abstract representation of data structures and their relationships

Answer

A diagram showing network topology

Answer

A physical server configuration plan

Answer

A software deployment pipeline

Question 2

What are the three levels of data abstraction in the ANSI/SPARC architecture?

Accepted Answer

External, Conceptual, Internal

Answer

Physical, Logical, Virtual

Answer

Operational, Analytical, Strategic

Answer

Raw, Processed, Stored

Question 3

In data modeling, what is an entity?

Accepted Answer

A person, place, object, event, or concept about which data is stored

Answer

A database index

Answer

A stored procedure

Answer

A foreign key constraint

Question 4

What does cardinality describe in a data model?

Accepted Answer

The number of instances of one entity related to instances of another

Answer

The data type of an attribute

Answer

The primary key selection strategy

Answer

The indexing method used in storage

Question 5

Which concept represents a property or characteristic of an entity in a data model?

Accepted Answer

Attribute

Answer

Relationship

Answer

Cardinality

Answer

Schema

Question 6

What is the purpose of a data dictionary in data modeling?

Accepted Answer

To document the definitions, formats, and usage of data elements

Answer

To store compressed database backups

Answer

To translate SQL queries automatically

Answer

To map network traffic routes