CDP Data Architecture and Modeling 1

Question 1

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

Accepted Answer

Entity-Relationship (ER) Modeling

Answer

Entity-Relationship modeling represents data as entities (business objects), attributes (properties), and relationships (associations) between entities.

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

Normalization organizes data into related tables to eliminate redundancy, reduce anomalies, and ensure data integrity in relational databases.

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

The fact table in a star schema contains quantitative business metrics (measures) and foreign keys linking to surrounding dimension tables.

Question 4

What is denormalization in database design?

Accepted Answer

Intentionally introducing redundancy into a database to improve read performance

Answer

Denormalization intentionally adds redundant data to a normalized schema to reduce joins and improve query read performance, often used in data warehouses.

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

Second Normal Form (2NF) requires that a table be in 1NF and that every non-key attribute be fully functionally dependent on the entire composite primary key.

CDP - Certified Data Professional Practice Test

CDP - Certified Data Professional Practice Test

CDP Data Architecture and Modeling 1