Each ____ contains a single-part primary key that serves as an index for the fact table and also contains other fields associated with the primary key value.
A) primary table
B) fact table
C) dimension table
D) star table

Question

Each ____ contains a single-part primary key that serves as an index for the fact table and also contains other fields associated with the primary key value.​
A) ​primary table
B) ​fact table
C) ​dimension table
D) ​star table

Quizplus · Accepted Answer

A dimension table contains a single-part primary key that serves as an index for the fact table and also contains other fields associated with the primary key value. This linking of the fact table with the dimension table allows for easier analysis and querying of the data. A fact table contains the measured values, while a primary table and star table are not commonly used terms in the context of data warehousing.

Each ____ Contains a Single-Part Primary Key That Serves as an Index