Answer-first summary for fast verification
Answer: Design multiple bridge tables, each managing a specific relationship between entities, ensuring they link correctly with the fact and dimension tables.
Option B is the correct approach as it involves designing specific bridge tables for managing complex relationships, ensuring they integrate correctly with the existing data model. This method maintains the integrity and clarity of the data relationships.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
In a data warehousing scenario, you are asked to implement bridge tables to manage complex relationships between entities. Explain how you would design these bridge tables, including the types of relationships they would manage and how they would integrate with the existing data model.
A
Create a single bridge table for all relationships, merging all entities into one table.
B
Design multiple bridge tables, each managing a specific relationship between entities, ensuring they link correctly with the fact and dimension tables.
C
Avoid using bridge tables; instead, integrate all relationships directly into the fact table.
D
Use bridge tables only for one-to-many relationships, ignoring many-to-many relationships.
No comments yet.