Project Management Answers

Fill in the blank: In a dimensional model, a foreign key is used to connect a _____ table to the appropriate fact table.

Q: Fill in the blank: In a dimensional model, a foreign key is used to connect a _____ table to the appropriate fact table.

or

Q: Complete the blank: A foreign key links a _______ table to the relevant fact table in a dimensional model.

  • relationship
  • dimension 
  • measurement
  • primary

Explanation: In a dimensional model, a foreign key is used to connect a dimension table to the appropriate fact table. The foreign key in the fact table references the primary key in the dimension table, establishing the relationship between the two.

Leave a Reply

Your email address will not be published. Required fields are marked *