Data Engineering Data Warehouse Modeling 2

Question 1

In a star schema, what is the central table that contains measurable business metrics called?

Accepted Answer

Fact table

Answer

Dimension table

Answer

Bridge table

Answer

Lookup table

Question 2

A snowflake schema differs from a star schema primarily because its dimension tables are:

Accepted Answer

Normalized into multiple related tables

Answer

Denormalized into one flat table

Answer

Removed entirely

Answer

Stored as JSON blobs

Question 3

Which type of fact table stores a row only when an event occurs, such as a single sale?

Accepted Answer

Transaction fact table

Answer

Snapshot fact table

Answer

Accumulating snapshot

Answer

Factless fact table

Question 4

What is the grain of a fact table?

Accepted Answer

The level of detail represented by one row

Answer

The number of dimensions attached

Answer

The total row count

Answer

The storage format used

Question 5

A factless fact table is most commonly used to:

Accepted Answer

Record events or coverage with no numeric measures

Answer

Store large text measures

Answer

Replace dimension tables

Answer

Compress fact data

Question 6

Which key type uniquely identifies a row in a dimension table within the warehouse, independent of the source system?

Accepted Answer

Surrogate key

Answer

Natural key

Answer

Composite key

Answer

Foreign key

Question 7

Conformed dimensions are valuable in a data warehouse because they:

Accepted Answer

Are shared consistently across multiple fact tables or data marts

Answer

Eliminate all fact tables

Answer

Store only numeric data

Answer

Require no surrogate keys