CDP Data Architecture and Modeling 2

Question 1

In a snowflake schema, how do dimension tables differ from those in a star schema?

Accepted Answer

They are normalized into multiple related tables rather than a single denormalized table

Answer

In a snowflake schema, dimension tables are normalized into multiple related sub-tables, reducing redundancy compared to the denormalized dimension tables in a star schema.

Question 2

What is a Slowly Changing Dimension (SCD) Type 2?

Accepted Answer

A dimension that tracks history by adding new rows with effective date ranges when attributes change

Answer

SCD Type 2 tracks historical changes by adding new rows with start/end dates, allowing analysis of both current and historical dimension attribute values.

Question 3

Which data architecture style uses a central repository where raw data is stored in its native format until needed?

Accepted Answer

Data Lake

Answer

A Data Lake stores raw data in its native format at scale, allowing flexible analysis later, unlike data warehouses that require structure upfront.

Question 4

What is a conceptual data model?

Accepted Answer

A high-level representation of business concepts and relationships without technical detail

Answer

A conceptual data model provides a high-level, business-focused representation of key entities and relationships without technical implementation details.

Question 5

In data modeling, what does cardinality describe?

Accepted Answer

The numerical relationship between instances of two entities (e.g., one-to-many)

Answer

Cardinality describes the quantitative relationship between entity instances, such as one-to-one, one-to-many, or many-to-many relationships.

CDP - Certified Data Professional Practice Test

CDP - Certified Data Professional Practice Test

CDP Data Architecture and Modeling 2