Which of the following contains a multipart primary key, each part of which is a foreign key to the surrounding dimension tables?
A) fact table
B) primary table
C) dimension table
D) star table

Question

Quizplus · Accepted Answer

Fact tables typically contain a multipart primary key, which consists of foreign keys to the surrounding dimension tables. This allows for easy joining of the fact table with the appropriate dimensions, enabling analysis and reporting on the measures (numeric data) stored in the fact table.

Which of the Following Contains a Multipart Primary Key, Each