CDP Data Architecture and Modeling

Question 1

Which data modeling technique uses entities, attributes, and relationships to represent business concepts?

Accepted Answer

Entity-Relationship (ER) Modeling

Answer

Physical Data Modeling

Answer

Dimensional Modeling

Answer

Object-Oriented Modeling

Question 2

What is the purpose of normalization in relational database design?

Accepted Answer

Eliminate data redundancy and ensure data integrity by organizing data into related tables

Answer

Improve query performance by adding redundancy

Answer

Increase storage capacity

Answer

Create indexes for faster retrieval

Question 3

In a star schema, what does the 'fact table' contain?

Accepted Answer

Measurable, quantitative business metrics and foreign keys to dimension tables

Answer

Descriptive attributes about business entities

Answer

Configuration settings for the data warehouse

Answer

User access permissions

Question 4

What is denormalization in database design?

Accepted Answer

Intentionally introducing redundancy into a database to improve read performance

Answer

The process of converting ER diagrams to physical tables

Answer

Removing unused tables from a schema

Answer

Converting a relational model to a document model

Question 5

Which normal form requires that every non-key attribute be fully dependent on the entire primary key?

Accepted Answer

Second Normal Form (2NF)

Answer

First Normal Form (1NF)

Answer

Third Normal Form (3NF)

Answer

Boyce-Codd Normal Form (BCNF)

Question 6

What is a surrogate key in database design?

Accepted Answer

A system-generated, meaningless unique identifier assigned to each row in a table

Answer

A natural business key like a Social Security Number

Answer

A foreign key referencing another table

Answer

A composite key made of multiple columns